Toggle view between two reports(tables)

[Jdbenike]

I have two different reports within one report in SSRS.

Originally I want to hide both, then based on a paramater, or textbox, or checkbox give the user the ability to view one or the other.

Is there a simple way of dong this? I see you can make the tables non-visible, but what would i put in the toggle item part then?

Any help would be appreciated.

 

[RiverGuy]

You can create a new parameter to prompt for the report to be shown. Add the names or descriptions of your reports as the values for the new parameter.

Then, in each "report"--whether it's by table, matrix or list--set the expression of the Hidden property to an expression like this:

=iif(Parameters!ShowReport.Value = "Report1", false, true)

You would obviously change the string in that expression to the name which corresponds to the selected value.