subreports - based upon specific record type/group

rbuser

i'm looking for a suggestion on how best to do the following. i have a
master/detail report relationship. depending upon the master record
type (there are 6 possible types), i have a subreport for each record
type - and whether or not there is a record the subreport will print or
be suppressed. i'm thinking that's the easy part. each subreport is
also grouped upon a field type and each type has a unique presentation.
i'm not sure if i should use more subreports or sections or????
i haven't found the right layout yet and was hoping for some insight.
the output i want would look something like:

master record (e.g., name/address)
detail A (visible if there is data)
type 1 (visible if there is data)
detail data
detail data
detail data ... as many detail records
summary - type 1 if visible

type 2 (visible if there is data)
detail data
detail data ...
summary - type 2 if visible

type 3 (visible if there is data)
detail data...
summary - type 3 if visible
detail B (visible if there is data)
same as above

hoping this makes sense!
any suggestions in pointing me down the right path would be great!
thanks!
-martha

nardmoseley

> i have a master/detail report relationship. depending upon the master

Use the DetailBand.BeforePrint event to set each subreport.Visible property


The subreport will traverse the detail datapipeline to which it is assigned
and will generate a detail band for each detail record corresponding to the
master.

Similar to above use the DetailBand.BeforePrint to check the FieldType and
set the Visible property of each field layout.

You could use additional Subreports for each field type or use Regions. If
you use Subreports, leave the datapipeline unassigned - so that the
subreport will print the current record only.




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

rbuser

thanks!