Add reports in the fly

[Eric]

Hi

We want our consulting team to create custom reports for our customers.

It works like this:

- In our program the user uses a wizard to create a dataset , this query is saved in the database and can be exported to excel

- now the consultant should be able to use the excel to create a report

- the report file will be placed in a specific folder of the client

- the rest server scans the report folder and sends Json the user to show a list of reports

- if the report is selected, the reports should use the dataset (not the excel) to run the report

- so we have to switch the datasource of the report from excel to the dataset

Is this all possible?

Thanks for answering!

Eric

[Todor]

Hi Eric,

If I understood correctly, you would like to use an Excel file with data as a data source for a report and then replace this data source in run-time with a database data source.

Generally, we provide a CsvDataSource that may be linked to an Excel file to get the data. Here are the relevant links to our Documentation:

• CsvDataSource Component Overview
• Connecting the CsvDataSource Component to a CSV Source

When it comes to replacing the data source, based on your recent forum post and the Ticket info, I infer that you would like to do this in a Blazor application with our Blazor Report Viewer. In this case, you would need to create a Custom ReportSource Resolver to replace the report data source in the Telerik Reporting REST Service where the reports will be rendered.

Briefly, you would need to instantiate the report, modify its DataSource(s) and return the report instance in an InstenceReportSource. For this, you may find useful also the article How to use Custom Report Source Resolver and Custom Report Document Resolver.

Regards,
Todor
Progress Telerik