Binding data to Report file in ASP.Net MVC application

[Venkat]

Hi,

We are designed the report using Report Viewer and able configure the report file using Report Viewer of Kendo.UI for ASP.Net MVC application.

Since in Report Designer, the report controls are bind with Data Source object with results. But as per my requirement, we need to bind the data at the run time based on other filter options. I tried to look into the Demo and Documentation of the reporting for this but could not able to get it.

Here is my reportViewer code used to display the report:

    @(Html.TelerikReporting().ReportViewer()
       .Id("reportViewer1")
       .ServiceUrl("/api/reports/")
       .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.html")
               .ReportSource(new UriReportSource() { Uri = "TransactionSummary.trdx" })
       .ViewMode(ViewModes.INTERACTIVE)
       .ScaleMode(ScaleModes.SPECIFIC)
       .Scale(1.0)
       .PersistSession(false)
    )


To the transaction summary report I need to pass the data at the run time.

Can some one please guide us on this as early as possible?

Regards!

[Venkat]

Hi,

Can some one please give a details for the same as urgent basis?

Regards!

[Stef]

Hello Venkat,

Please check the explanation how the HTML5 Report Viewer and the Reporting REST service work together in this forum thread.

In the thread I mention a custom report resolver, where you can apply your logic for getting the TRDX file, deserializing it in Telerik.Reporting.Report object and changing the data items' DataSource properties.
Keep in mind the revolver's Resolve method can be called multiple times on a request for report, and you may need a mechanism to preserve the changes to avoid re-retrieving the data.


In future, if it is an emergency please use the support ticketing systems. This guarantees you a response from Telerik representative in time range set by the system based on your purchased support plan.

Regards,
Stef
Telerik

 

 

[Venkat]

Hi Stef,

Thanks for your reply. Will check the links and get back to you if I have any other issues.

Regards!

[Venkat]

Hi Stef,

It had worked for us, thanks!

Regards!

[Daniel]

Stef,

[quote]Keep in mind the revolver's Resolve method can be called multiple times on a request for report, and you may need a mechanism to preserve the changes to avoid re-retrieving the data.[/quote]

Could you ​give an example of how to preserve changes? Our ReportResolver implementation does a fair amount of work. We could cache ​the report ​on the first ​call made per request, but the report id being passed to Resolve isn't an adequate key.

[Stef]

Hello Daniel,

The argument of the resolver's Resolve method is the string description sent by the viewer(client) reportSource.report. Thus you can include any information that can help you determine if the same report is requested and it must be taken from your custom cache, or it is a new report that has to be resolved.

I hope this information helps you.

Regards,
Stef
Telerik