Page Breaks

[keiath]

Hi Guys



Another question

I have a report based on main database that list all "Sites" by Manager, when i open the report it gives me all the details as I want, what I would now like to do is page break at the end of each manager, in addition the each record as a "completed" and "active" field I only want to show on the report the "Active" Records.

ie:- After it reports all the Active marked sites for 1 manager is starts the second manager on a new page, can this be done? and how do I do it?

Keiath

[June7]

Have you created a Group section on the Manager? Try the ForceNewPage property of the group footer section.

[keiath]

the group by manager works good thats fine but the ForceNewPage sorry little bit of a noob on reports how do I do this?

[June7]

Select the Manager group footer section (will have to activate footer in the Grouping & Sorting set up). ForceNewPage is on the Property Sheet.

[keiath]

Added a screen shot still not sure how to do this, sorry like i said a noob at reports

[June7]

Right click on the Site Manager Header bar and open the Grouping & Sorting designer. In the designer at bottom of form, activate the associated Site Manager Footer. Select the Site Manager Footer bar and look for the ForceNewPage property.

[keiath]

Brilliant thank you so much, worked a treat. Will make other reports that I need to do so much simplier