summary and GT of a shared variable field

[bv0719]

I finally have my report returning the data I need to see although some tweaking is needed. I have 2 shared variables that are returned from 2 subreports to my main report. I need to enter a summary total for each field as well as a grand total. These options are not available from the insert menu. How can I get these shared fields to total?

 

[fredp1]

The issue that your experiencing is the evaluation time of the variable. You probably have Whileprintingrecords as the evaluation time.
This means that variable is only evaluated when the report prints hence you cannot subtotal it.

Using Subreports you are normally forced to use whileprintingrecords.
A solution to your problem is to have a subreport to have a subreport to calcuate the subototal and another subreport to calculate the grand total. (Not nice, but works well.. all be it slow)

Other than that, the only possibilty is to get the database to summarise the information you want. This can either be done at the database via a View, or with version 9, modify the SQL to simulate the view.

Cheers
Fred

 

[fredp1]

Since my last post, I have spoken to Crystal Support about Running Totals.
While it is true that you cannot use the running total Expert to do a total on "whileprintingrecords" formulae, you can create a manual running total using the 3 variable technique.
here is the link to the document

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_running_total.zip.asp

This document will help

Fred

 

[cmpgeek]

what i did was create a set of "regular" variables in the main report that totaled each variable per detail field and totaled in the group footer.

in order to get my averages correctly i then created a variable set to count up the # of entries within the group and divided the variable's value within the footer by that total...

that seems a little simpler than adding more subereports, but then again i need all the practice with variables i can get...