I'm pulling from Table A which has 4 Transaction Statuses... '03', '05', '06', & '07' I've defined a dataset which pulls them...
But when I try to define the Parameter, when I select ALL from the drop down menu of the report, it doesn't pull '03', '05', '06' and '07' - in fact, it pulls NOTHING... how do I make it so that the 'ALL' choice will pull ALL statuses in one report? When I select any of the individual statuses, it runs the report just fine... but ALL doesn't get the report to run it for ALL statuses Report Parameter Properties:
How are you passing the parameter to your report and generating the report data?
My assumption, based on what you've given, is that your report data is coming from a stored procedure, called by a statement along the lines of
In which case, I would expect your stored procedure to contain a
If you're confident that the TransactionStatus will always exactly match the parameter passed, then you can replace the
In general you have 2 options.
The option 1 is better from my point of view. So you only need to handle the NULL passed in the query.
answered Oct 22 '11 at 11:03 AM