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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstabs 1

Status
Not open for further replies.

RichMaine

Technical User
Feb 11, 2004
6
US
I have a Crosstab report, and it doesn't print column heading for which te row has no data. In other words, say there are three rows 1,2, and 3 and 3 different data types A, B, and C. Row 1 has values for A, B, and C, Row 2 has B and C, and row 3 has A and C. What I get is:

A B C
1 a b c
B C
2 b c
A C
3 a c

The capital letters are the group headers, and the lower-case letters are the data.

What I want is:
A B C
1 a b c
2 b c
3 a c

Can anyone help me?
 
Try placing the crosstab in the report header or report footer instead of a group section.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top