1. create new report in Report Studio
2. add the objects to be displayed on the report, ie. lists, crosstabs, text items, etc. (you can add 3 list objects using 3 different queries for example or 3 crosstabs which uses only 1 query)
3. create a prompt page and add a prompt object, ie. value prompt (this can be a new query or just using static choices)
4. in the properties pane of the prompt object, add a parameter to associate with the prompt (eg. parameter=displayparam)
5. go to query explorer and add a data item object to your report query (if report has 3 list objects with 3 queries, the data item only need to be added to one of the queries)
6. set the expression for the data item object to refer to your parameter which was associated with the prompt (eg. expression definition for the data item = ?displayparam?)
7. go back to the report page
8. add a conditional block to the report
9. click on conditional block property and a small window will pop up
10. click on the "Variables" button
11. create a new variable (eg. variable=displayvar)
12. set the expression to read the parameter value passed from the prompt (eg. ParamDisplayValue("displayparam") ) and click OK
13. create values to use for the different report types (eg. report1, report2, report3) which should match the values passed by the prompt
14. on the properties pane of the conditional block, select the current block property (eg. report1)
15. drag objects that are to be displayed when user selects a report from the prompt page (eg. report1) into the conditional block, ie. drag the list object to be displayed when user selects report1 in the prompt page into the conditional block
16. change the current block (eg. report2) and repeat step 15
17. set the objects for the rest of the possible values for the variable in the conditional block
18. run the report
No comments:
Post a Comment