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

Showing all of the columns of a crosstab

Status
Not open for further replies.

SFinch

Programmer
Jun 16, 2000
9
US
I have created a crosstab in CR7 which looks like this:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUN MON TUE WED THU FRI SAT TOTAL<br>AREA1<br>AREA2<br>AREA3<br>AREA4<br>AREA5<br>TOTAL<br><br>When I run the report with sparse data it looks something like this:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TUE WED TOTAL<br>AREA1<br>AREA2<br>AREA3<br>AREA4<br>AREA5<br>TOTAL<br><br>The summary field is a count on the area.&nbsp;&nbsp;Is there a way to force the crosstab to show the &quot;null&quot; cells with a &quot;0&quot; and thus the column titles instead of suppressing them?<br><br>Not looking forward to breaking this report into separate fields.<br><br>Any help would be appreciated,<br>Scott
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top