Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab - Sub total conditional formatting!!

Status
Not open for further replies.

santy2906

Programmer
Feb 8, 2011
2
US
I have a cross tab report that displays sub group total conditionally but leaves a blank row if one not available like:
Total
100 20
-----Blank Row-----
101
ABC 15
DEF 10
Total 25

I have also checked the suppress empty rows and columns.
I would like to eliminate this blank row. Any help please!!
 
How was the subtotal suppressed conditionally? What formula? What version of CR are you using?

-LB
 
if rtrim(GridRowColumnValue ("Column1")) = "101" then false else
true

I have suppressed the label text object.

Crystal Reports 11.

 
Unfortunately the suppress empty rows/empty columns doesn't work for situations like this and I don't know of a way to get around this.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top