Post reply

SSRS shared dataset parameters not showing in expression builder

  • February 3, 2026 at 8:55 pm

    #4729297

    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:27 am

    #4729634

    This usually happens because the SSRS expression builder only shows parameters that belong to the report itself, not the shared dataset. Even though the dataset has parameters, they don’t automatically appear in the expression UI. To use them, you still reference them manually through Parameters!YourParameterName.Value once the report has its own matching parameters mapped to the shared dataset. In other words, make sure the report has parameters with the same names and that they’re linked to the shared dataset parameters. Once that mapping exists, the expressions work normally even if the parameters never show up in the expression builder list.

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

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