Post reply

SSRS shared dataset parameters not showing in expression builder

  • February 3, 2026 at 8:54 pm

    #4729296

    I am creating shared datasets that our executive staff can use for creating reports in Report Builder.

    I need to pass parameter value to the shared dataset query such as "Location" and "AddressType"

    I can define parameters for shared dataset.

    They are set to be used in query.

    When i go to expression builder, they are not available and says  "report has no parameters"

    SQL Server 2016, VS 2022, Windows 10

  • February 4, 2026 at 9:10 pm

    #4730025

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • February 17, 2026 at 4:03 pm

    #4736305

    Right Click on Parameters .......add Parameter....Name It Locations.......get Values from a Query or Specify Values, and in your Dataset add  @Locations in your where clause.  do you want to report on multiple locations?

  • February 17, 2026 at 5:58 pm

    #4736337

    While expression editor won't work, what i did end up finding out was that i needed to use :Parm  not @Parm since the query was against Oracle

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

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