sorting and grouping issue

[JB]

Hello
I have a report from a query which is as such:

Report Header = "Folder Contents"
FolderID Header = FolderId , FolderName, FolderYearRange
Detail = SketchID, SketchName, SketchCode
FolderID Footer =Count([SketchName])
Report Footer =now()

No Page Header or Footer.
I've sorted it so that there is a new page for each FolderID and it's ok
except for half way through there is a page that continues with a couple of
records from the previous folderID but unlike other folders that then start
on a new page, it starts a new folder on the same page!!! WHY!!!

this is my sorting & grouping properties

FolderID - Ascending
Group Header - Yes
Group Footer - Yes
Group on - Each Value
Group Interval -1
Keep Together - Whole Group

Please can someone HELP with this
Thank you Jenny
SketchCode - Ascending
Group Header - No
Group Footer - No
Group on - Each value
Group Interval - 1
Keep Together - Whole Group

 

[GL]

Hi JB
Check the properties for your FolderID footer section (by double clicking
the box to the left of the FolderID Footer). Make sure the property Force
New Page has After Section selected. This will ensure a new page is forced
after the section is complete regardless of where it falls on the page. I'm
guessing the other ones just fell right for it to go to a new page. Hope
that helps!
GL

 

[JB]

Yeay! Thank you. Thank you !!
Could never do this stuff without you guys
JenX

Hi JB
Check the properties for your FolderID footer section (by double clicking
the box to the left of the FolderID Footer). Make sure the property
Force
New Page has After Section selected. This will ensure a new page is
forced
after the section is complete regardless of where it falls on the page.
I'm
guessing the other ones just fell right for it to go to a new page. Hope
that helps!
GL

Hello
I have a report from a query which is as such:

Report Header = "Folder Contents"
FolderID Header = FolderId , FolderName, FolderYearRange
Detail = SketchID, SketchName, SketchCode
FolderID Footer =Count([SketchName])
Report Footer =now()

No Page Header or Footer.
I've sorted it so that there is a new page for each FolderID and it's ok
except for half way through there is a page that continues with a couple
of
records from the previous folderID but unlike other folders that then
start
on a new page, it starts a new folder on the same page!!! WHY!!!

this is my sorting & grouping properties

FolderID - Ascending
Group Header - Yes
Group Footer - Yes
Group on - Each Value
Group Interval -1
Keep Together - Whole Group

Please can someone HELP with this
Thank you Jenny
SketchCode - Ascending
Group Header - No
Group Footer - No
Group on - Each value
Group Interval - 1
Keep Together - Whole Group