Export to Excel, Suppressed Rows appear??

[Former Member]

The battle with Crystal never ends.

So, I've got a report that is working great, even exporting to excel (data only) where all the data is in the cells I expect them to be. However, I just noticed that some of the rows that were suppressed appear in the excel output. What the heck?

Any workarounds or solutions to this?

... enterprise solution <-- uh huh.

Thanks,

John

[Former Member]

Fastest problem solved all week

... so, the way to fix this is this.

If you encounter this problem, it may be because the suppression logic is applied to the start of a Row Group such as Group 4, Group 4a, Group 4b, etc. and your suppression logic is only in Group 4. The logic needs to be applied to all of the individual sections in order for the excel output to be correct.

Yay for enterprise solutions

[abhilash_kumar]

Almost done with the report!

So I won't export now!

Thumps up John!

-Abhilash

[Former Member]

Abhilash,

Not gonna lie... I almost lost it... all the way to end of the report to find that bug... Thankfully, it was an easy workaround

J