CSV Export does not export tables

4 posts, 0 answers
  1. Craig
    Craig avatar
    1 posts
    Member since:
    Oct 2016

    Posted 07 Oct Link to this post

    We have several reports where we are not using the detail section, and we put tables in the header or footer. When we export to csv, we get one line of data containing the customer name and other variable data that goes in the header, but the table data does not export.

    We do have one report that has the table in the detail section. Oddly, that table does export, but the customer name and other header data does not.

    Now I should point out that when we design our reports, we do not use a data source. We type in the column names manually, as in:

    =Fields.FieldName

    The reports get their data from a web service, and we then bind it to the report and render it in the report viewer. I don't know if that has any effect on this issue or not.

    PDF and Excel work fine.

    Is there any way we can get all the data to export?

     

  2. Katia
    Admin
    Katia avatar
    308 posts

    Posted 11 Oct Link to this post

    Hello Craig,

    Known considerations when exporting a report to CSV format are described in Design Considerations for CSV Rendering help article where PageHeader/Footer Sections are ignored during the processing.

    Thus, you can move the tables into ReportHeader/Footer or GroupHeader/Footer sections in order to export the detailed table records.


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Craig
    Craig avatar
    8 posts
    Member since:
    Jul 2016

    Posted 11 Oct Link to this post

    Okay, that does explain part of the problem for one of the reports. However, there are still issues. For one report, we have a table in the group header, along with some other header information, nothing in the detail section, and a table in the group footer. When we export to csv, it exports the header information in the group header. The table in the group header is ignored. It ignores the group footer completely. Basically, it will export the first few lines of the group header, then stop.

    As I mentioned earlier, we didn't use a data source to design these reports. Can you confirm that this is the expected behavior?

  5. Katia
    Admin
    Katia avatar
    308 posts

    Posted 13 Oct Link to this post

    Hi Craig,

    If the same report exports to other formats (you mentioned PDF and Excel) as expected it means that there are no issues with connecting directly to the data via web service.

    In general, the Table item is rendered to CSV format by expanding the table and creating a row and column for each row and column at the lowest level of detail. Because of this data denormalization (flattening) some Crosstab configurations will not be exported correctly - Flattening the Hierarchical and Grouped Data.

    The described behavior is expected - when exporting to CSV the content of GroupHeaderSection is rendered at the beginning of each detail row while the content of Detail section will be rendered as a record for each detail row.
    Thus, test placing the Table item into Detail Section instead of GroupHeaderSection - Report Structure(Report Sections).


    Regards,
    Katia
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
Back to Top