XML Data

[Walter Robert]

Hi,

unfortunatelly i haven't found any example showing a ReportDesigner opening a RDL file with a in-memory System.Data.DataSet holding the report data.

Is there any brief example around?

Thanks a lot,

Walter

[Vinoth Srinivasan]

Hi Walter, 

Thanks for your interest in Syncfusion Components. 

If your requirement is to render the report which used locally saved XML data in our report designer, you can able to view the report. We have prepared simple report designer sample based on this and it can be downloaded from the below location. 

http://www.syncfusion.com/downloads/support/forum/134684/SALESD~1-1050786485.ZIP 

If the above sample does not meet with your requirement, then could you please provide some additional details regarding your requirement. It will be helpful for us to provide the solution at the earliest. 

Regards, 

Vinoth S. 

[Walter Robert]

Hello Vinoth,

many thanks for the demo. i think i couldn't express myself right due language Problems. attached i send you a PDF as a zip file (syncfusion_reportdesigner_szenario_2aa5a0f2.zip) explaining my Situation.

1) i made two application

a) a Report designer application where you have a XML data as a stream. this XML data is only for Report design purpose due to have all fields in the Report designer. after designing a Report the Report (rdl as a stream) will be stored in the database, without the XML data!

b) a .net 4.7.1 Service reading on request the rdl data from the database (rdl as a stream), selecting the XML data (XML as a stream, equivilant to the XML schema at design time), bind the XML to the Report datasource on runtime and render a PDF as a stream which will be after send via email.

I hope i could clarify my case a bit better for you to investigate in this matter,

many thanks in advance,

Walter

Attachment: syncfusion_reportdesigner_szenario_2aa5a0f2.zip

[Vinoth Srinivasan]

Hi Walter, 

Query	Response
a Report designer application where you have a XML data as a stream. this XML data is only for Report design purpose due to have all fields in the Report designer. after designing a Report the Report (rdl as a stream) will be stored in the database, without the XML data!	You can design a report with dummy XML data and save the report into the database with dataset structure for binding data at runtime. Please find the sample report based on your requirement.  http://www.syncfusion.com/downloads/support/forum/134684/ze/1346841688604370
) a .net 4.7.1 Service reading on request the rdl data from the database (rdl as a stream), selecting the XML data (XML as a stream, equivilant to the XML schema at design time), bind the XML to the Report datasource on runtime and render a PDF as a stream which will be after send via email.	Your requirement can be achieved by two methods.  1. You can bind the XML data to the report in code behind by converting the XML data into datatable and load this datatable as a datasource for the report viewer to achieve your requirement. We have prepared a sample to save the RDL report in database as stream and retrieve the RDL file from the database to load the report in viewer. Also, we have converted a “Employee.xml” as datatable to provide dataset values to the report viewer. Please find the sample from the below location.  http://www.syncfusion.com/downloads/support/forum/134684/ze/RDLReportSample-1460678070  Note: We have used local database for saving the RDL report, so we request you change the database part based on your need.  2. Alternatively you can edit the RDL report in code behind and update the XML dataset query in report definition to bind the data. Please find the below KB link for editing report in code behind.  https://www.syncfusion.com/kb/7083/how-to-edit-a-report-at-runtime

Regards, 

Vinoth S.