cross tab question

[jobillborf]

Using version 9 connecting to a oracle database

We have a crosstab where there are 18 districts in the columns. If there is no data for the distict the district number does not appear. I would like the district labels for all districts to appear even though there is no data.

The districts are numbered 1 - 18.


please help.

Thank You

 

[lbass]

You can only do this if you have a table that contains all districts with a left join TO the transaction data table, and with no selects on the right hand table. Otherwise you would need to create a manual crosstab to accomplish this.

-LB