Separate records by page

[aymanmb]

I have a report based on a query that shows Company name, total sales, net profit with a sub report showing detailed orders for that company.

problem is no proper page break by company as I want to, so the pages continue and accordingly the 1st page will have the send company name then the second page will continue with the records of the second company, and so on.

attached are photos of my 2 pages report and the report design window, may be you can help me

thanks

 

[GohDiamond]

In your report design view, right click in any free space, select "Sorting and Grouping" from the menu that pops up. Select the ClientName in the upper part of the list. Set Group On:EACH VALUE and Keep Together: WHOLE GROUP.

You can play around with the items in the list until you get the desired grouping.

I'd save the report as Report2 before playing with it.Don't save changes UNTIL you have the grouping you want.

I hope that helps.

Goh