How to display colums with no values in Crosstab

[banditx42]

I have set up a crosstabs to display summarized monthly totals in my report. The problem is, some groups have no data for some months, and therefore the crosstabs are a different size than the rest (only show july-oct rather than jan-oct). Is there any way to force the crosstab to show the months that have no data? I have a formula outside the crosstab to do a ratio calculation for each month that is not possible in the crosstab and it needs to be aligned properly with the crosstab on all the groups.

If it is not possible to force the crosstab to do that, then is there any way to divide a summarized field in the crosstab by another summarized field in the crosstab? I have tried just making a formula, but what I think it is doing is on each record it will divide one field by another, and if either of the fields is zero, the result is zero. Any help would be appreciated, thanks.

 

[synapsevampire]

There are ways to do this, for instance a manual cross tab, but I always suggest that you create a Periods table to join to, that way you ALWAYS have a row for any time period.

I think that kenhamady.com has an example of a manual crosstab, but they are really ugly solutions to a fairly simple problem.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[banditx42]

Yeah, I started out doing a manual crosstab and found it to be really cumbersome. I think my report is too big for that because I am doing monthly, weekly, and daily crosstabs. I am gonna try the periods table, I just hope I don't have to change my formulas too much. Thanks