Forum Discussion
Assistance Required for Resolving URL Character Limit Issue in Paginated Report
Hi Heena_9980400
If your datasSource (e.g., SDRDS_wali) is already configured and connected to your database, you do not need to create a new one. Try to create a new dataset under this data source.
Please follow the below steps to create a New Data Source (If required):Step1: If no data source exists or if you want to use a different one:
- Right-click on Data Sources (in the left panel).
- Click on "Add Data Source".
- Give it a name (e.g., MyDataSource)
- Select "Use a connection embedded in my report".
- Choose your database type:
- SQL Server → Select "Microsoft SQL Server"
- Enter connection details (server name, database name, authentication).
- Click "Test Connection" → OK.
Step2: Create a Dataset with a Query
- Right-click on "Datasets" → Click "Add Dataset".
- Enter a dataset name (e.g., MyDataset).
- Select "Use a dataset embedded in my report".
- Choose the data source you created (or an existing one).
- Enter the SQL query, adjusting for your database type:
SELECT * FROM my_table WHERE Zone1Wo IN (SELECT value FROM STRING_SPLIT(@Zone1Wo, ','))
If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.
Thanks,
Cheri Srikanth
Hi Heena_9980400
Yes! you can implement passing comma-separated values when "Select All" is chosen directly in power-bi report builder (.rdl) without involving a database.
By default, report builder sends multiple values as separate parameters (e.g., &Zone1Wo=value1&Zone1Wo=value2). Instead, combine them into a single comma-separated string.
Steps to Implement:
Configure the parameter in report builder:
- Open Report Data Pane, right-click on the parameter (e.g., Zone1Wo), and select Properties.
- In the General tab, enable Allow multiple values to support multiple selections.
Adjust the Parameter Expression in Report Builder:
- Use the JOIN function in SSRS expressions to convert multiple selected values into a single, comma-separated string.
Expression for the dataset parameter:
=Join(Parameters!Zone1Wo.Value, ",")
This ensures that multiple selected values (e.g., value1,value2) are passed as "value1,value2" instead of separate parameters.
Modify the SQL Query in the Dataset to handle multiple values efficiently, update the dataset query using sql functions that can split comma-separated value.
SELECT * FROM my_table WHERE Zone1Wo IN (SELECT value FROM STRING_SPLIT(@Zone1Wo, ','))
Postgresql query correctly filters based on the selected values without requiring multiple parameters.
SELECT * FROM my_table
WHERE Zone1Wo = ANY(string_to_array(@Zone1Wo, ','))
If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.
Thanks,
Cheri Srikanth
Hi v-csrikanth ,
Here at the left side we have the datasource option.
you are asking me to create a table here by writing query, if yes can you please help me with the steps one by one in ssrs
thanks in advace!