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!

How can I get multiple groups on the same page

Status
Not open for further replies.

Tiree

Technical User
May 4, 2003
2
CA
The report I have has two files, Master and Detail, linked by Comp#. It's a 2 Col report with detail going across then down. Each group looks fine. The problem is it
skips to a new page after each group, whereas I only want a few lines between each group - and a skip to new page when the group cannot be kept together on the same page I'd appreciate if someone could tell me how I might do this. Thanks!
The layout is as follows:

(Master) Comp# , Description
(Detail) Comp#,ID,LastName,FirstName ID,LastName,FirstName
(Two Cols. going across, then down)

Comp#Header Sorting on Comp# Asc; Grp Header = Yes;
GrpFooter=No; Grp On=EachValue; Grp Intvl=1
KeepTogether=Whole Grp;
Prop: Force New Page=None; NewRowOrCol=After Section
KeepTogether=Yes

Detail
ForceNewPage=None; NewRowOrCol=None;KeepTogether=Yes
 
have you tried "Sorting and Grouping" from the toolbar?

enter the field that you want it to group on, and then set it to not give a new page. Adjust the size of your group footer for spacing between groups.
 
rssql,
just want to say thanks for your help. I've got it working as it should.
Thanks again,
Tiree
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top