Hello,
We are migrating a 100+ reports from Crystal Reports to Telerik as part of an app redo. The old app was a windows app, the new app is an Angular (12 or 13) app. We will have the Angular ReportViewer presenting the report. The server side is C# .net5 or .net6.
We are the beginning of the project and have been creating proof of concepts to ensure functionality and no surprises when integrating with the main app.
The back-end database is MS-SQL (any version, any edition supported).
Focusing on speed, least data transmitted from server to client, etc. AND without concern for parameters - what is the recommended DataSource choice?
We are capable of using any of the supported methods, we just don't know if any have advantages given the above critera.
Thanks in advance for any help.
1 Answer, 1 is accepted
Hi Robert,
Generally, the report processing and rendering happen entirely server-side, in the Telerik Reporting REST Service that hosts the Reporting engine. For that reason, the data for the report is fetched and utilized entirely on the server. The client, e.g. the Report Viewer, requests the report from the service and receives a completely rendered document or document page. That said, the client doesn't know anything about the data coming from the report DataSources and the latter doesn't travel from the server to the client.
If you are going to use an MSSQL database, the best choice would be our dedicated SqlDataSource component. It utilizes the specified data provider to connect to the database and fetch the data. The SqlDataSource accepts parameters to be passed to the query or Stored Procedure - see Using Parameters with the SqlDataSource component. In the general case, this data source won't require custom code for fetching data, which would make the project easier for maintenance.
Regards,
Todor
Progress Telerik
Rank 1