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!

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

Cross Tab Suppression XI

Status
Not open for further replies.
lisa626

lisa626

Programmer
Aug 9, 2006
92
0
0
US
I have a crosstab as follows in the report footer:

mickey mouse 0 0 0 1 2 3 6
donald duck 1 2 1 0 0 0 4
goofy 0 0 0 0 2 0 2

I want to be able to suppress anything less than 3.
 
Sort by date Sort by votes
In preview or design mode, select the cell->right click->format field->common->suppress->x+2 and enter:

currentfieldvalue < 3

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
123
hilfy
hilfy
PremHealth1
  • Locked
  • Question
Calculate Values Based Upon Cells in Different Cross-Tabs
Replies
1
Views
39
lbass
lbass
pndMaster
  • Locked
  • Question
Hide column in Cross tab - CR2013
Replies
1
Views
42
SkipVought
S
Lucy_G
  • Locked
  • Question
Highlight whole row in a crosstab based on non crosstab info
Replies
2
Views
74
Lucy_G
Lucy_G
VHDN
  • Locked
  • Question
CR XI default layout window
Replies
1
Views
60
VHDN
VHDN

Part and Inventory Search

Sponsor

Back
Top