Skipping a record if Sum < than a value

rbuser

Hello!

Well, I have searched the pdf documentation and the forums and can't find
info on skipping a record much less doing so if a value is greater than or
less than a certain value. I'll bet its there but I couldn't find it.
Anyway...

I have a basic report with a query that retrieves certain records on people
based by a purchase. I have a detail band and group footer that lists the
buys and then in the group footer sums the Buys which are listed in a
column format in the detail.

I want to skip an entire record/group footer if the dbcalc (sum) of the Buys
is less than a certain value and move on to the next record/report band(s).

How do I do this?

Thanks for any help!

John J

nardmoseley

The standard way to suppress information is to either use a Query to select
only the records that you want to print or use the Band.BeforePrint event to
set the Band.Visible property. (It is also possible to use the DataPipeline
to skip records and this is shown in main reports demo, see demo 116. But I
prefer the other two techniques listed above).

If I understand your description correctly, the issue here is that you do
not know which records you want to skip until after you have performed the
calculations. If you want to suppress the GroupFooter, then you should be
able to check the value of the variable. But if you want to suppress the
detail bands that were generated prior to the group footer, then its too
late. In this latter case, I think you need to create a summary dataset that
contains the sums so that you know ahead of time what data you want to
print.




--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com