Manual Crosstab Help 1

[shaleen7]

I'm trying to create a manual crosstab where it counts the number of apps submitted per month. I want to use a zero as my placeholder where no applications have been submitted.


Desired Results:

Jan Feb Mar Apr May June

20 10 20 30 0 0

In my select statement I've indicated that I want the months between january and decemeber of 2004

I created the following formula for each of the 12 months.

//Jan
If month ({VRPT_TABAPP.APPDATE}) = 1 then COUNT({VRPT_TABAPP.APPNO}) else 0



Current Results:

Jan Feb Mar Apr May June

80 0 0 0 0 0

It's giving me the total for the entire date range in the month Jan. It's not separating the number of apps submitted for the appropriate month.

What am I doing wrong? Thanks.

 

[lbass]

Your formula should be in the detail section and look like:

//{@Jan}:
If month ({VRPT_TABAPP.APPDATE}) = 1 then 1 else 0

Then you right click on the formula and insert a summary (SUM, not count) on this formula and then suppress the details.

//{@Feb} would look like:
If month ({VRPT_TABAPP.APPDATE}) = 2 then 1 else 0

-LB

 

[shaleen7]

Instead of placing the formula and inserting a summary in the detail section. I placed the summaries of the formulas in the report footer.