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!

Report Designer Page Break

Report design issues and solutions.
LisaPD
User
User
Posts: 15
Joined: 19 Oct 2020, 09:51
Sage Version: Other

Re: Report Designer Page Break

Post by LisaPD » 03 Dec 2020, 11:39

Hi, yes you're right, it does. See attached.
Last edited by LisaPD on 03 Dec 2020, 11:51, edited 1 time in total.

sageNoob
User
User
Posts: 34
Joined: 03 Aug 2020, 12:04
Sage Version: v2015 21 UK/Europe/Africa

Re: Report Designer Page Break

Post by sageNoob » 03 Dec 2020, 11:49

LisaPD wrote:
03 Dec 2020, 11:39
Hi, yes you're right, it does. See attached.
Simply move the Headers "Stock, Description, ..." to the Substring() Header.

BUT, keep the "Location: <>" Data in the Location Header.

That should save space.

P.S. They already seem to be in Alphabetical order.

LisaPD
User
User
Posts: 15
Joined: 19 Oct 2020, 09:51
Sage Version: Other

Re: Report Designer Page Break

Post by LisaPD » 03 Dec 2020, 11:51

Yes, that works.

Thanks for your help.

sageNoob
User
User
Posts: 34
Joined: 03 Aug 2020, 12:04
Sage Version: v2015 21 UK/Europe/Africa

Re: Report Designer Page Break

Post by sageNoob » 03 Dec 2020, 11:52

Glad to be of help :D

LisaPD
User
User
Posts: 15
Joined: 19 Oct 2020, 09:51
Sage Version: Other

Re: Report Designer Page Break

Post by LisaPD » 03 Dec 2020, 11:54

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.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4331
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Report Designer Page Break

Post by brucedenney » 03 Dec 2020, 12:02

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.
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. Image

LisaPD
User
User
Posts: 15
Joined: 19 Oct 2020, 09:51
Sage Version: Other

Re: Report Designer Page Break

Post by LisaPD » 03 Dec 2020, 12:16

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest