Add reports in the fly

1 Answer 28 Views
Report Viewer - Blazor
Eric
Top achievements
Rank 1
Iron
Iron
Iron
Eric asked on 01 Jun 2022, 09:27 AM | edited on 01 Jun 2022, 09:29 AM

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

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 Jun 2022, 08:06 AM

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:

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

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Report Viewer - Blazor
Asked by
Eric
Top achievements
Rank 1
Iron
Iron
Iron
Answers by
Todor
Telerik team
Share this question
or