Telerik report impement report in in-memory in web forms

[aruljothi]

Hi I am using telerik report in web forms. we have implement it is from physical file i..e report definition  is present in SQL columns. will be modified at runtime and save a file in temp path. and set in to report viewer.

in c# 
 var clientReportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
 clientReportSource.IdentifierType = IdentifierType.UriReportSource;
 clientReportSource.Identifier = strXml;

how it can be used in in-memory or  without using physical file as references.

[Ivet]

Hello Aruljothi,

Thank you for reaching out.

To display a Telerik report in the HTML5 Report Viewer for Web Forms using an in-memory report definition (such as one stored in a SQL column), you should avoid using the UriReportSource, which requires a physical file. Instead, you need to use the XmlReportSource, which can work directly with an XML string from memory.

First, you have to retrieve the XML report definition from your SQL database as a string. Create an XmlReportSource and assign the XML string to its Xml property. Pass the XmlReportSource to the server-side Reporting REST Service, which serves the report to the HTML5 Report Viewer - Implementing a Custom ReportSource Resolver Explained with Example - Telerik Reporting

On the client side (JavaScript), configure the report viewer to request the report by a custom identifier, and ensure your REST service knows how to resolve this identifier to the in-memory XML report.

Do not use UriReportSource for in-memory reports, as it requires a physical file path. Use XmlReportSource for reports stored as XML in a database or generated at runtime.

Your ReportsController should accept a custom identifier (such as a report ID or name) and resolve it to the appropriate XML from your database, returning an XmlReportSource.

I hope the above information will be useful. Let me know if you have other questions.

Regards,
Ivet
Progress Telerik