Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
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: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 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 :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, 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 5 guests