on 04-23-2014 12:22 PM
Hi Expert ,
I'm using below query to display only customer code for parameter selection but its displaying Vendor code too.
Kindly guide me.
Declare @Fromdate Datetime
Declare @frmcode nvarchar(max)
Declare @Tocode nvarchar(max)
set @Fromdate = (select MAX(T12.RefDate) From JDT1 T12 where T12.RefDate <= '[%0]')
set @frmcode = (select MIN(T13.cardcode) From ocrd t13 where t13.CardType='c' and T13.cardcode >= '[%1]')
set @Tocode = (select MAX(t14.cardcode) From ocrd t14 where t14.CardType='c' and T14.cardcode <= '[%2]')
Thanks
-Rajesh N
Hi Rajesh,
This is by design. You may not be able to change the selection list for the parameter even if you give the condition.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The query is working fine. If you add selection parameter for card code, it will show all BP code regardless of card type condition. But when you select for example vendor code, no result will be displayed.
Try without declare statement also same result.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.