SageForum for UK versions of Sage 50- Help and support.

Hi, I have a report that outputs the contents of a customers custom price list, all nicely formatted, with their terms and what not in the footer.

Upon running it, I am offered a criteria popup asking which list I want to report, and it allows 'between', so i select (for example) between A and B.

Problem is, if customer A price list ends half way down page 1, it immediately prints the items on customer B's list, with no space,. or (as I want) no company name/header stuff.

I know when I was working with emailing invoices, there was a setting in the email options i could change to make each report start separately. Is there something similar i'm overlooking here?

Hi Sam

There were some report headers and footers that were not needed
The pricing Ref header/footer was not needed because you can print that as part of the page header on each page so I moved it there.
You need an account ref section, in the header add an "insert page before"
The terms information, doesn't need to be on the bottom of every page, it only needs to be printed on the last page of an account so I moved it in the account footer

See the attached, hopefully it gives you an idea of what you need to do.

I think you had it all apart from the structure.

Bruce

Fabulous, works a treat, thanks very much. It's a flippin' minefield this reporting lark!

Ahjhhh, i see the 'Page Break Before - True' property on the ACCOUNT_REF header now, makes perfect sense.

Glad to be of service