Crosstab Stays With the Same Columns Even If there are no values.

[gosoccer]

Hi guys,
We are running on Relational Model using Report Studio 10.2.2

I have to do something that the Crosstab maintains the Columns even if there is no values associated to the Intersection between the Top Edge and Left Edge of the Crosstab.

For right now, it's taking off the Columns and makes my Crosstab looks very goofy. :o

I don't need to do any Suppression.

Thanks for your help as always. :) :)

[tjohnson3050]

Make a separate query for the data item that you are going to put on the columns, then join that query with your other query using an outer join (0..1) on the side of your original query.  Base your crosstab on this query (result of the joined queries).

This should give you all the values on for columns, ever when there is no data for the column.

[gosoccer]

Thanks a lot. I'll try that.  :) :)