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: Brad Kunkel

CA Forum: Exporting

I think it isn't designed behavior. If bands are explicitly suppressed, the fields in those bands are not exported. But if a band is conditionally suppressed, the fields in those bands are always exported whether the band happens to be suppressed or not. None of the other export formats do this. I think the "one line of values" statement simply means that all values that are exported are put on one line as opposed to separate lines of data for each band.

After doing other searching on this bug, I've found that there are many developers that have this problem. CR XI R2 supposedly fixes the problem but I haven't downloaded it yet because it is a very large file and I'm also not ready to resolve compatibility issues that it may cause.

Thanks,

Brad Kunkel