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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

seperator page on sub report.

Status
Not open for further replies.

GShen

MIS
Sep 26, 2002
561
US
Hi, I have a main report with 4 subreports. On 1 of the subreports I need it to break on one of the groupings when a field on the group header is set to a certain value. I know you can't use sep. pages in subreports. So in the ON FORMAT of the grouping, I set the grouping force new page = 2 to page break after the grouping (EG. "Me.GroupHeader2.ForceNewPage = 2"). Perfect, except for 1 problem. It page breaks, prints the new grouping at the top with no detail. Then it does another page break and starts printing the detail. Obviously I only want it to break once and start printing the detail immediately. I tried setting the detail keep together to true to try and overide anything but VB does not allow you to change that control. Anyone have any ideas? I am trying countless scenerios and none have worked yet. The above is the closet I have gotten to get it to work.

Remember when... everything worked and there was a reason for it?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top