Make a Crosstab display all rows, even if there is a zero total for that row
Posted on 2003-12-02
I cannot find any answers anywhere to this question. I am trying to make a crosstab that will show all rows even if there is no data to display.
My problem is that I need to regually generate a report and export its data to an Excel spreadsheet. If there is no data for a particular row, CR wont display this row at all. So when I export to Excel, the data shifts up or down depending on what records were omited.
An example of what I am trying to do is:
JAN FEB MAR TOTAL
17 and under 6 0 10 16
18-24 0 0 0 0
25-34 1 7 2 10
TOTAL 7 7 12 26
If it doesn't look right, copy and paste it into Notepad. Thanks.