June 16, 2010 at 8:55 pm
I have a parameter in a query whose default values are A, B and C. Its available values should be A, D, E, F(drop down, allow single value, not multiple value). For these two, I have two different queries. I created two datasets and directed them to default and available values for the parameter in parameter properties page. Now, when I run the report and I don't specify any value for the parameter (I want to get the data for default values) and I click on run report, it is prompting me to enter the value for the parameter. How do I force the report to consider default values when I don't specify any value for the parameter. Also tried with selecting "Allow blank value" for the parameter. Any help will be greatly appreciated.
June 17, 2010 at 11:35 pm
Hi... 🙂
I may not be understanding the exact requirement here but I could guess that you want to display a report with a parameter whose default values should be A,B,C and dropdown values should be A,D,E,F... ???
Jst asking, can't we use a single dataset here and display initially the report for A,B,C parameter data and allow users to select A,D,E,F...parameter and filter the data based on this parameter selection.???
Can you please describe a little more abt this !... 🙂
Thanks,
Niraj
June 18, 2010 at 6:19 am
Hi Niraj,
Thanks a lot for replying. You understood the requirement correctly. For parameter values, I have two datasets - one for default values (A,B,C) and one for available values (A, D,E,F). In the front end, for end users, for this parameter, default value is "All Countries" which gets the data for A,B,C. In the drop down, they should see only A,D,E,F. When the user wants to select a particular country, he shouldn't see B and C values in the drop down. Please let me know if you need any other information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply