At 01:33 PM 3/31/2009, Roberts, Jennifer wrote:
I would like to display a report with four slave tables and
four sub-reports. My slave tables are actually temporary
views that are created before the report generates. I am
only able to get one sub-report to display. I am using the
child option, and I have them shifting relative to the report
in front of it. Currently all the reports are in the detail
band of my main report. I have tried moving them each to a
band of their own and then making them section reports and
that didnt work either.
Is there some sort of settings like with the forms where
you can set your table settings, such as one to one or one to
many? For a report, does the slave tables have to have a
column in common with the main table for items to display?
Jennifer,
Similar to designing One-to-Many relation form with Master/Slave
tables in Form Designer, the Sub-Reports are designed to achieve
the same goal in Report Designer.
A properly designed and normalized database with Primary/Foreign
keys (or common columns), and the order of tables in form/report
designer should give you the desired results you need.
Take a look at the following two sample reports in RRBYw14 and
RRBYw15 databases.
Databases: RRBYW14 or RRBYW15
Sample Sub-Reports with 2 Tables: CustomerContacts
Sample Sub-Reports with 4 Tables: CustContInvoices
Very Best R:egards,
Razzak.
