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:

1. Right-click on Data Sources (in the left panel).
2. Click on "Add Data Source".
3. Give it a name (e.g., MyDataSource)
4. Select "Use a connection embedded in my report".
5. Choose your database type:
   • SQL Server → Select "Microsoft SQL Server"
6. Enter connection details (server name, database name, authentication).
7. Click "Test Connection" → OK.

Step2: Create a Dataset with a Query

1. Right-click on "Datasets" → Click "Add Dataset".
2. Enter a dataset name (e.g., MyDataset).
3. Select "Use a dataset embedded in my report".
4. Choose the data source you created (or an existing one).
5. 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