Help with report design please
Hi, let me describe how I want my report to look and act.
My two tables are in a Master Detail relationship.
Static Report Heading: At Top Of Every Page
Master Heading(contains data from master table): As long as their are
detail records
Static Detail Heading: As long as their are detail records
Record
Record
Record
...
Static Heading: At Top Of Every Page
Master Heading: As long as their are detail records
Detail Heading: As long as their are detail records
Record
Record
...
etc.
No band should split across pages.
How Do I do this?
TIA, Darin
My two tables are in a Master Detail relationship.
Static Report Heading: At Top Of Every Page
Master Heading(contains data from master table): As long as their are
detail records
Static Detail Heading: As long as their are detail records
Record
Record
Record
...
Static Heading: At Top Of Every Page
Master Heading: As long as their are detail records
Detail Heading: As long as their are detail records
Record
Record
...
etc.
No band should split across pages.
How Do I do this?
TIA, Darin
This discussion has been closed.
Comments
Hi, let me describe how I want my report to look and act.
My two tables are in a Master Detail relationship.
Static Report Heading: At Top Of Every Page
Master Heading(contains data from master table): As long as their are
detail records
Static Detail Heading: As long as their are detail records
Record
Record
Record
...
Static Heading: At Top Of Every Page
Master Heading: As long as their are detail records
Detail Heading: As long as their are detail records
Record
Record
...
etc.
No band should split across pages.
Can I test the vertical size of the detail band and then decide weather
I want to let it split or print fully on the next page?
How Do I do this?
TIA, Darin
Sorry, for not responding sooner.
1. Create a main report with a header/detail/footer.
2. Connect the Report.DataPipeline to the master.
3. Add a group to print for each master record and set reprint on
subsequent pages to true. You can optionally set KeepTogether to true.
4. Add a subreport to the detail band. Optionally set
subreport.KeepTogether to true.
5. Connect the subreport to the detail data.
6. Access the workspace for the subreport and remove the title and
summary. Note: Rather than a group on the main report, you can probably
add a group to the subreport instead - your preference.
7.
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com