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?
3 Answers, 1 is accepted
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
Rank 1
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?
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 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