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 Mike Lewis 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 of Groups CRXI

Status
Not open for further replies.
jarmend

jarmend

IS-IT--Management
Jun 3, 2004
10
0
0
US
I am using CRXI to report on a SQL 2000 table. I have a formula that results in 4 rows in a cross-tab, which I would like to have not include 1 of the 4 groups. Is there a way to accomplish this other than using grouping/sections or a manual cross-tab? Thanks.
 
Sort by date Sort by votes
In the crosstab expert, you could select the row field->group options and choose specified order. Select the three groups you want displayed and then select the "others" tab and check "discard all others".

-LB
 
Upvote 0 Downvote
Thanks Ibass!!!...sorry to bother you guys with something I should have found myself.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Cross Tab Sorting Columns
Replies
1
Views
80
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
90
SoftwareRT
SoftwareRT
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
76
RoknRole
RoknRole
Beth_a_ny
  • Locked
  • Question
Supressing two groups
Replies
14
Views
115
Beth_a_ny
Beth_a_ny
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
71
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top