Crosstab columns

[dday01]

Hi All,

I have a crosstab report where the columns are age ranges based on a formula that I created. All works fine accept that the columns only show up if there are totals for the columns. Is there a way to make each of the age range columns be displayed even if there are no numbers for that column? ie. have a zero show up.

Thanks for any help,

D

 

[lbass]

You can't force a zero in an inserted crosstab unless you have a column field coming from a table that contains all instances of the field that is then left joined to the table that contains the field you are summarizing.

You could create a manual crosstab where you insert a group on what is currently your row field, and then create a series of detail level formulas based on specific columns, as in:

//{@age1to3}:
if {table.field} in 1 to 3 then 1 //or then {table.amt}

//{@age4to6}:
if {table.field} in 4 to 6 then 1 //or then {table.amt}

Then insert summaries (sums, not counts) on these formulas at the group level and suppress the detail section. This will allow you to display 0's where there are no records.

-LB