If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help with Grouping
Hello all,
I have a report with a sub-report. The sub-report is located in the Detail section of the report and linked (master and child) using a book code. The problem that I am having is when I have records in the sub-report, they will show for each record in the Detail section of the report. At the same time, when there are no records in the sub-report, the sub-report area will have a big area of blank (again) for each record in the Detail section of the report. What I like to do is when there are records in the sub-report, instead of showing after each record in the Detail section of the report, I would like all the records in the Detail section of the report group and show the records of the sub-report after the records of the Detail section of the report for that book code. On the other hand, when there are no records in the sub-report, I would like the records of the Detail section of the report grouped without showing a big area of blank. Please help. Thanks. |
#2
|
|||
|
|||
Please help with Grouping
Hello again,
I got it figured out. I placed the sub-report in the book code group footer, which solves the problem of repeating after each record in the Detail section of the report, and set the Shrink property of the sub-report to "yes", which solves the problem of having a big blank area. Thanks again. "AccessHelp" wrote: Hello all, I have a report with a sub-report. The sub-report is located in the Detail section of the report and linked (master and child) using a book code. The problem that I am having is when I have records in the sub-report, they will show for each record in the Detail section of the report. At the same time, when there are no records in the sub-report, the sub-report area will have a big area of blank (again) for each record in the Detail section of the report. What I like to do is when there are records in the sub-report, instead of showing after each record in the Detail section of the report, I would like all the records in the Detail section of the report group and show the records of the sub-report after the records of the Detail section of the report for that book code. On the other hand, when there are no records in the sub-report, I would like the records of the Detail section of the report grouped without showing a big area of blank. Please help. Thanks. |
Thread Tools | |
Display Modes | |
|
|