Hi all,
new to SSRS, so needing a little help. I have a main report tablix. On a text box I have an Action based on the Switch expression below to go to 4 reports along with a start date and end date parameter. The date parameters are being passed to the 4 reports, however I needs it to be suppressed for the Employee report as this is a "current state" metric. It's currently giving me the "an attempt was made to set a report parameter 'StartDate' that is not defined in this report" error for this particular report,. Thank you for any help.
=Switch(
ReportItems!SafetyEvents.Value = "Safety", "Rpt_Safety",
ReportItems!SafetyEvents.Value = "Employee", "Rpt_Emp",
ReportItems!SafetyEvents.Value = "Labor", "Rpt_Labor",
ReportItems!SafetyEvents.Value = "Sales", "Rpt_Sales",
1=1, "Not Assigned"
)