Forum Discussion
Paginated Report Help!
I can find no help on this issue anywhere. I hope this is the right forum to ask.
I have a paginated report with nine parameters. At the moment, I am being forced to select from the first parameter, to activate the second, then the third and so forth. I am unable to select from parameter nine independantly without having chosen something from 1 to 8.
Not all users want to select from all parameters. So, how can I edit my parameters so that 'select all' is defaulted, or a solution so that users can pick whatever parameter(s) they want and leave the rest to run the report?
Attached shows my problem.
2 Replies
Hi JemmaD ,
To allow users to select from any parameter independently without having to select from the other parameters first, you can set the default value of each parameter to "All" or "Select All" (or a similar value that represents all of the available options for that parameter). This way, the user can choose to override the default and select a specific value for the parameter if desired, but they will not be required to do so in order to run the report.
Here are some steps you can follow to set the default value of a parameter to "All" or "Select All":
- Open the report in the report designer.
- Navigate to the "Parameters" panel.
- Select the parameter for which you want to set the default value.
- In the "Default Values" section, select the option to use a "Specified value" as the default.
- In the "Default Values" field, type in "All" or "Select All" (or a similar value).
Save the report.
Now, when the user runs the report, they will be able to select any parameter they want independently without having to select from the other parameters first.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-henryk-mstf thanks for responding. Typing 'Select all' in the default value didn't change the result. It still did not display all values in the paramater field when I run the report, and when I try to View the report with out the parameter selected, it still prompts me to choose something from this field.
