You have to have a source data that is includes of all of the months (or days of the month) and then left join that to the other data to get it to present data in the crosstab this way. Or you can change your crosstab from the group header to the report header and include the groupings within the crosstab itself. Since one of the groups had data in each month all of the months will appear for the entire crosstab and display either a 0 or null in the groups that had no data for those months.
In some case you can incude formula data as summaries but without seeing your set up and the formulas it is hard to tell for sure if these can be done as you desire. basically if you can create the field by a formual field that you are summarizing on or by using a RT then usually you can get those to display in a crosstab. You cannot just create a blank cell and drop a summary formula field into that cell.
Edited by DBlank - 08 May 2009 at 10:58am
IP Logged
