Grand Total Between tables

[rickdunna]

I have (1) table with a sum for each section. Which has a total for all the sums.

Then on the same report I have another table with a sum for each section.

I need to sum the sums on the second table and then do a grand total for both tables.

Help.

 

[satinsilhouette]

What are you doing this in? If Crystal either do an sql command line object to combine or add a subrepor to a main report and share the variables across the two to get your totals.

Thanks so much!
satinsilhouette

 

[rickdunna]

Sorry this is BO 6.5

 

[skrandel]

It's hard to say without seeing the report.

How many data providers? Are they properly linked?

Have you tried building a variable that just adds the totals together?

Steve Krandel
Intuit

 

[rickdunna]

Duh, Yep that is what it took to get it done.

Thanks Rick