Post reply

Conditional Dataset based on Parameter

  • April 20, 2018 at 1:35 pm

    #403284

    Is it possible to conditionally select datasource in a dataset through a report parameter? So for example  i have datasource1 and datasource2, i will define a reportparameter based on these datasources. When a user select datasource1 or datasource2 it should use the selected datasource name as my Data Source in my dataset.

    Any thoughts? 

    Thanks in advance.

  • April 20, 2018 at 3:00 pm

    #1987769

    lein - Friday, April 20, 2018 1:35 PM

    Is it possible to conditionally select datasource in a dataset through a report parameter? So for example  i have datasource1 and datasource2, i will define a reportparameter based on these datasources. When a user select datasource1 or datasource2 it should use the selected datasource name as my Data Source in my dataset.

    Any thoughts? 

    Thanks in advance.

    Another option is to use an expression to build the connection string for the Data Source properties. There are quite a few examples of doing this if you search on SSRS dynamic data source - here are a couple of examples:
    Implement Dynamic Data Sources in SQL Server Reporting Services
    How to use Dynamic data sources in your SSRS report

    Sue

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

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