Showing results for 
Search instead for 
Did you mean: 

Export to Excel, Suppressed Rows appear??

Former Member
0 Kudos

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.



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Active Contributor
0 Kudos

Almost done with the report!

So I won't export now!

Thumps up John!


Former Member
0 Kudos


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