Subreport in master report using datatype binary

[nguyen]

hello team, 

I have a report created in web designer and store the data in the database (binary). Now I want it to become sub report in my master report, I am using UriReportSource, then type the subreport name in the Uri text box, it does not work, it shows it could not find the subreport name, do we have any idea or solution to custom the path or load subreport here?

Thank u.

[Dimitar]

Hello Nguyen,

Thank you for the attached report!

When the master report is opened in the Web Report Designer, it is not possible to load the SubReport item's report as binary saved in a database. The only way to load a report in the SubReport item, that is stored on the database, is by storing the report as XML string.

Then, you may use the SqlDataSource Component to retrieve the XML from the database. You may assign this data source to the report's DataSource property so that you may access the field with the XML(e.g. =Fields.MyXmlData) or you may use the data source through a Report Parameter. 

For example:

If you use the report parameter approach, in the Xml input you would need to write an expression such as = Parameters.XmlReport.Value.

I hope that this approach will work for your needs. 

Regards,
Dimitar
Progress Telerik