M
Monte
The other respondent is correct. It's hard without
knowing your DB structure. I have several reports that
pull up subreports. They take a little practice and
patients to get them the way you want them.
Assume I have a Loan database with three tables.
Borrower Data, Payment Data, and Collateral Data. All
have the common field LOANID. Assume that I want have a
form that is based on borrower data and two subforms
showing payment data and collateral data. similarly I
have a report that is based on borrower data with
subreports showing payment history and a collateral
lisitng.
Start by building one report that corresponds to the data
in your one of your subforms (e.g. Payment Data).
Because it is intended as a subreport it should be very
simple in structure. No headers, footers, etc. Just the
data you want to display (i.e. detail only). Now build a
simple report with the only control being LOANID in the
Page Header. In the detail section, insert your Payment
data subform with the master and child links being
LoanID. The report should list the LoanID and then all
the Payment data for that LoanID in the subreport. If it
works, it will be easy to build the second subreport
insert it below the first and dress up the report the way
you want it.
knowing your DB structure. I have several reports that
pull up subreports. They take a little practice and
patients to get them the way you want them.
Assume I have a Loan database with three tables.
Borrower Data, Payment Data, and Collateral Data. All
have the common field LOANID. Assume that I want have a
form that is based on borrower data and two subforms
showing payment data and collateral data. similarly I
have a report that is based on borrower data with
subreports showing payment history and a collateral
lisitng.
Start by building one report that corresponds to the data
in your one of your subforms (e.g. Payment Data).
Because it is intended as a subreport it should be very
simple in structure. No headers, footers, etc. Just the
data you want to display (i.e. detail only). Now build a
simple report with the only control being LOANID in the
Page Header. In the detail section, insert your Payment
data subform with the master and child links being
LoanID. The report should list the LoanID and then all
the Payment data for that LoanID in the subreport. If it
works, it will be easy to build the second subreport
insert it below the first and dress up the report the way
you want it.