Page 2 of 2

Re: Report Designer Page Break

Posted: 03 Dec 2020, 11:39
by LisaPD
Hi, yes you're right, it does. See attached.

Re: Report Designer Page Break

Posted: 03 Dec 2020, 11:49
by sageNoob
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.

Re: Report Designer Page Break

Posted: 03 Dec 2020, 11:51
by LisaPD
Yes, that works.

Thanks for your help.

Re: Report Designer Page Break

Posted: 03 Dec 2020, 11:52
by sageNoob
Glad to be of help :D

Re: Report Designer Page Break

Posted: 03 Dec 2020, 11:54
by LisaPD
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.

Re: Report Designer Page Break

Posted: 03 Dec 2020, 12:02
by brucedenney
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.

Re: Report Designer Page Break

Posted: 03 Dec 2020, 12:16
by LisaPD
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.