Calculating sub total in Crystal Reports for Enterprise

[Former Member]

Hi all,

I have to display a report with BW hierarchy (Divisions--->Districts--->Jobs)

	Comp Code	Profit Center	60-90 days	90-120 days
Dist A (header2)
Job 1 (header 3)	1000	2100	40000	50000
Job2  (header 3)	3000	3223	40000	50000
sum (footer 3)			80000	100000
Dvision A TOTAL (footer 1)			80000	100000

I want to display the report in the above format.

But the problem when I'm doing the sub total for jobs, sum is carried out for each row of job instead of sum of all jobs thereby creating additional row.

How to solve this problem?

Please advise.

Thanks

John

[jyothirmayee_s]

Hi,

Can you post a screen shot of your actual report?.

Is it a crosstab?.

Thanks

Jothi

[Former Member]

Hi Jothi,

Here is the screenshot of actual report:

As you can see the total is carried out for each job of the district instead of all jobs.

Please advise.

Thanks

[abhilash_kumar]

Ho John,

Just Hide the Group Footer 3 and see if that's how you want the report to look like.

-Abhilash

[jyothirmayee_s]

Hi,

Looks like the subtotal is showing for GH3. Can you suppress the GF3 and check?.

Thanks

Jothi