Forum Discussion
Need a help in SSRS Paginated Report
Hey guys,
To integrate with Azure Synapse Analytics in Paginated report builder.
How can I connect? Could anyone of you help me with this?
Hi, Anonymous
Open Report Builder, and in the Report Data pane, right-click Data Sources and select Add Data Source. Next, select Azure Synapse Analytics from the list of connection types.
You can enter the connection string directly, or use the Build button to open the connection properties dialog.
Fill in the necessary fields such as server name, database name, and authentication method (Basic, SSO, or OAuth2).
Once you've entered the connection details, click Test Connection to make sure the data source is configured correctly.Specify the credentials to use for this data source. You can choose to use Windows authentication, SQL Server authentication, or other supported methods.
Once the data source is set up, you can create a dataset by right-clicking Datasets in the Report Data pane and selecting Add Dataset. Use the query designer to build queries from Azure Synapse Analytics data sources.
You can check the following link:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Anonymous
Open Report Builder, and in the Report Data pane, right-click Data Sources and select Add Data Source. Next, select Azure Synapse Analytics from the list of connection types.
You can enter the connection string directly, or use the Build button to open the connection properties dialog.
Fill in the necessary fields such as server name, database name, and authentication method (Basic, SSO, or OAuth2).
Once you've entered the connection details, click Test Connection to make sure the data source is configured correctly.Specify the credentials to use for this data source. You can choose to use Windows authentication, SQL Server authentication, or other supported methods.
Once the data source is set up, you can create a dataset by right-clicking Datasets in the Report Data pane and selecting Add Dataset. Use the query designer to build queries from Azure Synapse Analytics data sources.
You can check the following link:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.