Report Indicates Multiple Pages

[stevebp]

Hello to anyone who can assist.

I have created a report based on a query, but the report separateseach row by Goods Description onto multiple pages, where I need each GoodsDescription listed beneath each other on the page/report.

I have attached screen shots and a copy of the report.



Thanks in advance for any guidance.

Steve

[A S MANN]

It look like the either Goods Description or Labour Description has group by property is set to force New page is set to Yes.
Select Groupby or Details Prpoerty. Format tab , ForceNewPage and Select None to keep it on same page.

[Bullschmidt]

It looks to me like if a job has 5 detail records then the whole job is being printed 5 times - one for each detail item.

So perhaps do something like this...
Report's Design View | right-click | Sorting and Grouping | Add a Group | Choose Job Number | Then put most of the job in the Job Number header section, put the Goods Description rows in the Detail section, and put the rest in the Job Number footer section...

[stevebp]

Thanks for replying, these settings were already in place. The next reply to the thread has resolved this.

Regards

Steve

[stevebp]

Thanks for replying, your response works a treat and has improved my knowledge.

Kind regards

Steve

[Bullschmidt]

You're welcome and so glad to hear