> I have tried to get them to accept the totals in the Break Footer, but it
> is being insisted upon having them in the Header.

There are two ways of handling this:

1. Create a temporary view with the totals and calculations, and put lookup
variables into the header to retrieve the information from the view.

2. Use SQL lookup as variable expressions in the header.  For instance:

vSectionTotal = (SUM(AmountCol)) IN ReportTable WHERE SectionCol = SectionCol

You can use the various SQL Aggregate functions (SUM, COUNT, MIN, MAX, AVG, and
even LISTOF) to get values.

In either case, make sure that you set the report section for the variables
properly.
--
Larry

Reply via email to