Exporting to CSV includes hidden sections

[Former Member]

Post Author: Brad Kunkel

CA Forum: Exporting

When I export to CSV format, the export file includes data from hidden sections in the report. If I print the report or export in any other format, it works correctly. I am using CR XI. The report format is simple, just two group summary sections on the same group. One is hidden based on a report parameter. Both are hidden if the SUMmed field is 0. All other sections are suppressed. Anybody have suggestions?

Thanks,

Brad Kunkel

[Former Member]

Post Author: pvierheilig

CA Forum: Exporting

Brad - sounds like this is the designed behavior:

"Like record-style formats, the Separated Values format also creates one line of values for each record in your report. A record contains all of the fields in each section of your report as seen in the Design view. That is, fields in the Report Header section are exported first, followed by the Page Header section, the Group Header section, the Details section, the Group Footer section, the Report Footer section, and finally, the Page Footer section."