Post reply

Need to suppress date parameters

  • October 19, 2018 at 8:51 am

    #379908

    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"
    )

  • November 2, 2018 at 10:11 am

    #2012221

    Did you try to "Omit" a parameter?  When you "Omit" passing a parameter, it takes a "TRUE/FALSE" value.  That should allow you to not pass the "StartDate" parameter to the report.  If you need step-by-step instructions please let me know.

    Thanks.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply