June 20, 2017 at 8:30 pm
Hi All
Newbie to SSRS here.
I want to add a Optional parameter to my report by default it selects all but other options is to include if order has been invoiced or include if it has been invoiced.
If it has been invoiced it has a date in the invd column otherwise its blank (column is text in format 20170501).
In TSQL select * from orders where invd <> '' to get invoiced
Select * from orders where invd = '' to get those not invoiced
I have had a look at but brain is spinning on the spot trying to get this to work.
Any pointers would be much appreciated.
Thank you.
Cheers Greg
June 26, 2017 at 1:18 pm
taane - Tuesday, June 20, 2017 8:30 PMHi All
Newbie to SSRS here.
I want to add a Optional parameter to my report by default it selects all but other options is to include if order has been invoiced or include if it has been invoiced.
If it has been invoiced it has a date in the invd column otherwise its blank (column is text in format 20170501).In TSQL select * from orders where invd <> '' to get invoiced
Select * from orders where invd = '' to get those not invoiced
I have had a look at but brain is spinning on the spot trying to get this to work.
Any pointers would be much appreciated.Thank you.
Cheers Greg
You can set up a filter based on the parameter, but you may want to change the dataset query to deliver a NULL value whenever the invd field = ''. Thus, perhaps:SELECT fld1, fld2, fld3, etc..., NULLIF(invd, '') AS invd
It's also a bad idea to SELECT *, as a schema change could mess with your report.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 4, 2017 at 7:30 pm
Thank you Steve.
Appreciate the help
Cheers Greg
July 5, 2017 at 9:01 am
taane - Tuesday, July 4, 2017 7:30 PMThank you Steve.
Appreciate the help
Cheers Greg
Glad to help out.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply