Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!
Report Designer Page Break
Re: Report Designer Page Break
Hi, yes you're right, it does. See attached.
Last edited by LisaPD on 03 Dec 2020, 11:51, edited 1 time in total.
Re: Report Designer Page Break
Yes, that works.
Thanks for your help.
Thanks for your help.
Re: Report Designer Page Break
Glad to be of help 

Re: Report Designer Page Break
They are to a certain degree in order, but it goes from (ie.) A39 to A4 and then A40. But I can live with that.
- brucedenney
- Site Admin
- Posts: 4331
- Joined: 28 Feb 2006, 09:56
- Sage Version: v2017 23 UK/Europe/Africa
Re: Report Designer Page Break
I think the issue is that you have the wrong substring, you are looking at the first 3 chars not just the first.
Change it to
Substring(STOCK.LOCATION, 0, 1)
and I think it will work
The sorting of strings is Alphanumeric so A2 comes after A10
To get around this zero pad the numbers eg A01 A02 A10 A11 and then they will sort as you want.
Change it to
Substring(STOCK.LOCATION, 0, 1)
and I think it will work
The sorting of strings is Alphanumeric so A2 comes after A10
To get around this zero pad the numbers eg A01 A02 A10 A11 and then they will sort as you want.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. 

Re: Report Designer Page Break
I set the report earlier at Substring(STOCK.LOCATION, 0, 1), that is the only way I could get it to work.
If I set it at Substring(STOCK.LOCATION, 0, 2), it page breaks between (A1, A11, A12 etc) and (A2....)
If I set it at Substring(STOCK.LOCATION, 0, 3), it messes the page break up completely.
Yes, I suppose I could amend the location to A01 etc.
If I set it at Substring(STOCK.LOCATION, 0, 2), it page breaks between (A1, A11, A12 etc) and (A2....)
If I set it at Substring(STOCK.LOCATION, 0, 3), it messes the page break up completely.
Yes, I suppose I could amend the location to A01 etc.
Who is online
Users browsing this forum: No registered users and 1 guest