CSV Export and subforms

3 posts, 0 answers
  1. PJB
    PJB avatar
    6 posts
    Member since:
    Sep 2010

    Posted 28 Apr 2011 Link to this post

    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

  2. Steve
    Steve avatar
    10941 posts

    Posted 29 Apr 2011 Link to this post

    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:
    In short if you're after WYSIWYG representation of the report, please export to Excel.

    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. PJB
    PJB avatar
    6 posts
    Member since:
    Sep 2010

    Posted 03 May 2011 Link to this post

    Thanks Steve,

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