How to save the report generated by Web Report Designer to AzureSQL

1 Answer 14 Views
Report Designer - Web Report Viewer - Blazor
Umais
Top achievements
Rank 1
Umais asked on 14 May 2024, 07:42 PM

Hi Support,

Is there any documentation on it that i can read? My project is Blazor WASM based.

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 17 May 2024, 12:36 PM

Hello Umais,

It is possible to connect to any SQL database within the Web Report Designer through the SqlDataSource component. The only requirements are to have a valid connection string and to use the correct data provider for the selected database.

For example, for an Azure SQL database, you may use the Microsoft.Data.SqlClient data provider to connect to the database and query data according to the official MS docs - Connect to and query Azure SQL Database using .NET and the Microsoft.Data.SqlClient library - Azure SQL Database | Microsoft Learn.

For instructions on how to use this data provider in the Web Report Designer, you may visit the Connecting to Microsoft.Data.SqlClient in Web Report Designer - Telerik Reporting KB article and also the SqlDataSource Wizard Tutorial - Telerik Reporting article which has instructions on how to use the wizard of the SqlDataSource component.

I hope that the provided information will help.

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Tags
Report Designer - Web Report Viewer - Blazor
Asked by
Umais
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or