[RESOLVED] sum of two grand total in different reports

[_Wired_]

hi.. i have two reports... 1st report is for regular employee and 2nd report is for project employee... i use crosstab table to show this data's... i want to display the sum of grand totals of my 1st and 2nd report to obtain the sum of employees... is this possible? thanks

[_Wired_]

i think this is not possible.. thanks anyway..

[rasinc]

I think I was reading once that you can use formulas as rows, use Shared variables to pass outside the crosstab and calculate your own totals, then pass the totals out to a Report Footer to give you the total of both.

I don't have any code but I would assume and start with the same code you would use to create your own totals (I personally don't use the Running Totals in Crystal). I do know you can put in rows and hide them but I don't know if they will still calculate but I would give it a shot since it would only take 10-15 minutes.

Hope this helps, rasinc