Showing different tables based on report parameter

joo

Is is possible to show different report results based on a parameter that a user chose ? The report shown for each case would come from a different data set and would not result in the same table.

For example in the 'enter parameters' screen the user can choose

1. Report1
2. Report2

If user chooses Report1, a table showing data from companyDataSet should be displayed. The table has 3 columns.

If user chooses Report2. a table showing data from departmentDataSet should be displayed. This table has 5 columns and runs a query that is different from companyDataSet

Is this possible ?

4robert

Hi,
It can be done using "Visibility" properties.
To do this you have to do the following.
1> Create your full report with both table1 and table2.
2> Add dataset1 and dataset2 to design table data.
3> Place the table according to your requirement.
4> Create new "Parameter" to get user choice. Here you can also add the exact values such like "Report1" or "Report2"
5> Hide/unhide table1 and table2 as per user choice with the help of "Visibility" properties. You have to use "Report1" or "Report2" values to write
expression here.

Hope this will help you.

---

Regards

Robert