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

Report Designer Page Break

Report design issues and solutions.
LisaPD
User
User
Posts: 18
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: 102
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: 18
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: 102
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: 18
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: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- 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.

LisaPD
User
User
Posts: 18
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: Google [Bot] and 14 guests