Re: Filtering a summarized report

[Vince Mancino <e5d4@EARTHLINK.NET>]

The answer is to remove your on-break logic and code the program the old
fashion way.
Select the data. Edit the data. Table the detail lines. Run a sub total
accumulator.
When you determine a break is required then test your accumulator.
Based on your logic you print the detail from the table and add the
accumulator to the total amount or clear the table and the accumulator.
It sound more complicated then it really is.


Kris Cagan wrote:

> I have been working on this report for WEEKS, and I am at an impasse.  Any
> help would be IMMENSELY appreciated:
>
> The original report shows detail comparing transactions on two tables over
> a period of time.  For each item, there is a subtotal, at the end of the
> report are grand totals.  I used ON-BREAK processing to get the different
> levels of the report.  Looks nice.  The subtotals are calculated AS the
> detail is printed with an ADD to the Subtotal variable which is printed
> later when the item-level breaks.
>
> Okay, nice straight forward, no problem.  User came back with the request
> for a second report that showed the SAME INFORMATION but only for those
> items with a subtotal greater than 2.  The subtotal is done AFTER the
> detail is printed.  Is there a way to have SQR do such a filter?
>
> thanks in advance.
>
> Kris