Multiple Detail Formats

rbuser

I have a report which lists transactions posted to a database. The
problem is each of the transactions has a format dependent on its
transaction code. The report runs from the "Transactions" file and
must list a detail for each record. Here is a simplified view of the
data:

Transactions(BatchNo)
TransactionNo
TransactionCode(Payment,Return,TransferIn...)
Date
BatchNo

Payments
TransactionNo
AccountNo
Amount

Returns
TransactionNo
AccountNo
Year
Month
Gross
Tax

TransferIn
TransactionNo
AccountNo
FromAccount
Amount

How can I get Report Builder to produce this report?

Do you have an example?

Thanks, Sidney

digitalmetaphors

It looks like TransactionNo is the key linking field. You can use one
report, but place 4 detail subreports in the detail band. Toggle the
subreport visibility properties to view only one of the subreports before
the main report prints.


Cheers,

Jim Bennett
Digital Metaphors