Transaction Listing - Multiple Record Formats

rbuser

Hello:

Hello:

I need to do a report that lists various transactions on the same
report. Examples would be Payments, Adjustments, Transfers, etc. The
transactions need to printed on the report in the order received and
in the correct format for that particular transaction.

The database consists of a Transaction table recording common
information for all transactions such as transaction number,
transaction type, account number, film number, etc. There are
separate tables for each of the different transaction formats which
are all linked to the transaction table via its transaction number.

Tables:
(TranNo) Trans [TranType determines which table is linked]
(TranNo) payments
(TranNo) returns
(TranNo) adjustments
(TranNo) transfers
(TranNo) etc.

Report (to give you an idea):

Tran 1 10202 Smith, John Payment $400
Tran 2 76923 Adams, Sandy Transfer $200 33392 Owens, Alan
Tran 3 32031 Jones, Mary Return Gross $200 Deductions $50 Tax $15
Tran 4 32031 White, Tom Return Gross $400 Deductions $50 Tax $35
Tran 5 18330 Baker, Joe Payment $300

The actual report is much more complex than this and several types of
transactions require multiple lines per transaction.

How can I do this with Report Builder?

Thanks, Sidney

digitalmetaphors

If I understand correctly, that the TransNo is a key field which can link
the different transaction types. Use a master-detail approach with
subreport. The subreports can print each of the different transaction types
for each transaction number, respectively.


Cheers,

Jim Bennett
Digital Metaphors Corp

rbuser

On Wed, 13 Feb 2002 10:33:18 -0600, "Jim Bennett \(Digital

digitalmetaphors

I think the best approach is to use multiple subreports and toggle their
visibility, bsed on which one you want to print. When the detail band goes
to print (DetailBand.BeforePrint event), you can read the type from the
master datapipeline, and then set the visibility of the proper subreport
that you want to use for the detail records for this master.


Cheers,

Jim Bennett
Digital Metaphors Corp