Does Report Server support embedded XML as a data source?

[Martin Jørgensen]

Is it possible to create a XML data source, which contains the actual XML data, like:

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/xml-connection-type-ssrs?view=sql-server-2017 

Where the connection string is empty, it will use embedded xml data.

Or what is the best way of importing xml data set without using a webservice?

Best regards

Martin

[Mageshyadav M]

Hi Martin, 

  

Yes, our ReportViewer in ReportServer loads report with embedded XML data source. Please find the demo sample report which loads from embedded XML data source, 

 

https://reportserver.syncfusion.com/reports/?category=Sample%20Reports&report=Company%20Sales&view=categories 

 

Please let us know in case of further reference details needed. 

 

Regards, 

Mageshyadav.M 

[Martin Jørgensen]

Hi Mageshyadav,

I am able to embed the data as show in the example. Thanks for showing.

Unfortunately that would require, that the data is embedded in multiple datasets.

What I idealy want is:

1. Define a DataSource with XML data, but the data is embedded in this data source. That allows me to share the data between multiple datasets.

2. Create multiple data sets using the above DataSource.

Is it possible with the c# sdk to implement my own DataSource type, which could supply this XML data?

Best regards

Martin

[Vinoth Srinivasan]

Hi Martin, 

We can able to pass multiple dataset from code behind using RDLC report in our Report Viewer. Please find the below help documentation for your reference. 

https://help.syncfusion.com/js/reportviewer/rdlc-report#bind-data-source-in-web-api-controller 

Please find the below KB documentation for your reference for how to create a RDLC report with dataset from code behind. 

https://www.syncfusion.com/kb/10146/how-to-create-rdlc-report-using-business-object-data-source-in-syncfusion-javascript-report-viewer 

The above suggestions did not meet with your requirement then could you please share some additional details and it is very helpful for us to provide solution earlier. 

Regards, 

Vinoth S.