CSV Export and subforms

[PJB]

I have a report with four sub reports, when I export it to pdf or excel it all looks fine, but when I export it to CSV none of the data from the sub reports is exported. Is this expected behaviour or have I just missed something simple.

Thanks for any help

Patrick

[Steve]

Hello PJB,

As you can see from our Invoice report, the subreport data is exported properly to CSV. Are your subreports related to the master report i.e. master-detail? If so note that the data from the master and detail report is joined together into one big denormalized table with INNER JOIN.
In other words, the CSV would export the subreport only if there is data returned based on the master report parameter passed. If there is data in the master report that does not have match in the subreport, then the subreport would not be shown. You can find more information about the peculiarities and limitations of both CSV and Excel formats in the following articles:

• Design Considerations for CSV Rendering
• Design Considerations for Excel Rendering

In short if you're after WYSIWYG representation of the report, please export to Excel.

Regards,
Steve
the Telerik team

[PJB]

Thanks Steve,

I'll check those pages out and the detail on the report.