filter datapipeline

rbuser

Hi

I have a report template that uses the end user reporter.
it has a main report followed by a subreport in its Summary.
so first report runs, then second report runs.

They are both using the same pipeline and table.
Problem is, the min report needs to be filtered while the subreport does
not.

Is there any way of filtering data within RAP for the main report ?
I am not using the data tab in the designer so not using SQL just linked to
master-detail order printout.

Basically the main order items need to exclude certain items when printing
but the subreprt or the same items needs to print all records.

many thanks

Andy Dyble

nardmoseley

1. If you have two reports/subreports connected to the same datapipeline and
you need filtering, then you really need two datapipelines (two querys).
The only other alternative would be to use the detailband.BeforePrint event
to toggle the detail band Visible property to hide the detail band for
unwanted records in the second subreport.

2. When I need one report to print after another, I usually create a main
report with no header/footer and then add two section style subreports to
the detail band.

main - no datapipeline
subreport1 - datapipeline1
subreport2 - datapipeline2




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