How to show group total at the end of the report

[maas]

Hello All,

I am having a problem while trying to view the group totals in the report footer separately.

My report is having three groups as they are in the report
Group 1: Status includes (Approved/Rejected/Pending)
Group 2: Directorate includes (Directorate A, Directorate B ....etc)
Group 3: Departments includes (IT, Finance ......)
In the Details, there is the employee name.

Now for each Group 1 (Status), there will be a total for the employees. ( I used the normal summary)

I am trying to have the totals separately in the report footer, but can not get this.
E.x:
No. of Approved, No. of Rejected, No. of Pending

So, please help me on how to get these totals

 

[lbass]

Insert a crosstab in the RF that uses status as a row and count of distinctcount (depending on your needs) of the employee field.

-LB

 

[lbass]

Oops. I meant count OR distinctcount.

-LB

 

[maas]

Thank you lbass, I will try this.

But, I thought of another idea, is to use subreports. Is this is appropriate in my situation and please guide me on how to show the value which is shown correct in the subreport and want to use it in the main report.

Thanks for your help

 

[lbass]

A crosstab would be much more efficient than a subreport.

-LB