Skipping a record in a report

rbuser

Hi All,

I have a query which gathers the data to be shown in the report. I need to
do another query based on one of the fields in the main data to determine
whether or not that record will be shown in the report. Basically, I need
to know where I can put the code to be able to skip a whole record w/o using
before print on each of my bands. I just want the report to move on to the
next record and ignore the unwanted record.

Thanks,
Stacey

digitalmetaphors

Put the code that checks whether the detail will be printed or not in the
detail band's BeforePrint event. If the test comes back saying not to print
set the detail band's Visible property to false.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

Yes, but that will only suppress the detail band...it will still print the
group header, etc. I want it to skip the entire record...any other
suggestions. For instance, my report is a statement. It is grouped by
client_id. I may put a client in a group (stored in another table) called
'No Statement'. So, as the data traverses, I will do a query on the group
table, see if that client is in that group and then I want to skip that
client completely.

"Alexander Kramnik (Digital Metaphors)" wrote

digitalmetaphors

See the 'Pipeline.Traverse question' thread (5/2/02 12:15PM). You can use
the Pipeline.Skip method when traversing the data in the pipeline to skip
the record entirely.

--
Cheers,

Alexander Kramnik
Digital Metaphors