I'm running CR 2011

I'm trying to create a crosstab report inside a Group Header.
Fields are as follows coming from a stored procedure.

ServiceLine
RequestType
FiscalPeriod
StartedToCompleted
Need to calculate average started to completed for each request type for selected date range.

I also have setup a reference table as a left outer join on FiscalPeriod to force all periods to appear.


The Desired Output would be:

[ServiceLine] Medicine
[RequestType]Jul Aug Sep Oct Nov Dec Jan Feb YTD
Admissions    22   19   18                          20
OR/PACU       32   62   81                          69
ER            79   83   61                          74
TC            77   15   154                        106
Unit to Unit 101 95   115                        104

[ServiceLine] Heart
[RequestType]Jul Aug Sep Oct Nov Dec Jan Feb YTD
Admissions    22   19   18                          20
OR/PACU       32   62   81                          69
ER            79   83   61                          74
TC            77   15   154                        106
Unit to Unit 101 95   115                        104

What I'm getting in my results is:

[ServiceLine] Medicine
[RequestType]Jul Aug Sep YTD
Admissions    22   19   18 20
OR/PACU       32   62   81 69
ER            79   83   61 74
TC            77   15   154 106
Unit to Unit 101 95   115 104

It also creates a 'Blank' group with the following:
'others'       Oct Nov Dec Jan etc


I have to group by ServiceLine so I do not have a create a unique report for each of our 15 facilities as they all have unique service lines.

When I create an identical Crosstab in the Report Footer and eliminate the Group and look at overall performance (All service lines)

I get the desired output for overall:

Bed Request TAT:
     Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD
Adm   14 18 13 0   0   0   0   0   0   0   0   0   15
Cath 61 70 57 0   0   0   0   0   0   0   0   0   64
ER    73 62 60 0   0   0   0   0   0   0   0   0   65
NU   137 176 171 0   0   0   0   0   0   0   0   0 160
OR    60 46 62 0   0   0   0   0   0   0   0   0   56


Any help and/or ideas of what I can do would be greatly appreciated.





      

The crosstab is inside the group header