Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport and Keep Together not working right

Status
Not open for further replies.

xsw1971

Programmer
Jun 21, 2001
153
US
I have a report with 3 groups and 4 subreports. Each subreport has 1 group. When I run the main report, if there are numerous records in any of the subreports, it pushes the start of the subreport to the next page in the main report, leaving a big white space on the previous page.

I have verified that every "Keep Togehter" box is unchecked using both the Section Expert and the Change Group Expert, in both the main report and subreports.

Any ideas why it's insisting on keeping the subreport together?

Thanks,
Jennie
 
There is also a "keep together" on the subreport object. Right click the subreport from the main report.. select format object..

Lisa
 
Never mind, I just answered my own question. I figured out there's a THIRD place to check - in the field itself. There's a box called "Keep Opject Together" that I unchecked, now it works great.

Sometimes you just have to write out a question for the answer to come to you!
 
Lisa, we must have posted at the same time! Thanks for the fast reply anyway!

Jennie
 
Jennie,
i am glad i am not the only one that does this... a couple times now i have been half way through typing in my problems when i get an idea to try...

whatever works right? [smile]

[americanflag] ShannonLea [americanflag]
 
Hi Jennie,

I have a similar problem as you describe above.

I have a report with 3 groups, and I display the actual data in the detail section. I display Group 1 and Group 3 header, and supress Group 2. I separate each records by a horizontal line in the detail section. I have also added vertical lines to separate the columns. These vertical lines are drawn from the Group 3 section and ends at Group 3 footer section.

If there are numerous records in the third group, it pushes the start of the 3rd group header and the details to the next page in the main report, leaving a big white space on the previous page. I unchecked Group 1's "Keep Group Together" option. Now, the white space is gone. However, the Group 1's header is now printed on a different page than the Group 3 header and the contents in the detail section.

My question is how can I display Group 1's header together with Group 3 header and the detail section content?

Also, since the vertcal lines are drawn across the detail section from Group 3 header to Group 3 footer, the vertical lines did not end properly. It is drawn beyond the last record displays on the first page.

Please help.

Thanks,
Kaelin

I have verified that every "Keep Togehter" box is unchecked using both the Section Expert and the Change Group Expert, in both the main report and subreports.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top