nuBuilder Forum

Posted: **Mon Sep 10, 2018 11:58 pm**

Hi
I have a field which runs on a textarea control which can contain multiple lines of text.
i want this information to appear on the report in the page footer

The field control on the report displays the mulitple lines of text but only if the field is the detail section.
It does not show the multiple lines when it is in the page footer.

Andrew

report.png

Posted: **Wed Sep 12, 2018 3:27 am**

Andrew,

Page Headers and Footers can't grow - if they did they may become longer than the page and lock up.

Steven

Posted: **Fri Sep 14, 2018 12:29 am**

Ok. i worked out a way to split the field into five separate lines using the following sql code. So now i have 5 field obejcts in the page footer to display the text. Its a long winded fudge but it does the trick. Hopefully the user will not use more than five lines of text

Code: Select all

SELECT 

SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',1),'\n',-1) as line1,

IF(STRCMP(SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',1),'\n',-1),
           SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',2),'\n',-1)),
   SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',2),'\n',-1),'') as line2,
   
IF(STRCMP(SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',2),'\n',-1),
           SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',3),'\n',-1)),
   SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',3),'\n',-1),'') as Line3,

IF(STRCMP(SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',3),'\n',-1),
           SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',4),'\n',-1)),
   SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',4),'\n',-1),'') as Line4,

IF(STRCMP(SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',4),'\n',-1),
           SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',5),'\n',-1)),
   SUBSTRING_INDEX(SUBSTRING_INDEX(DeliverySpecialInstructions,'\n',5),'\n',-1),'') as Line5
FROM `Delivery` WHERE DeliveryID ='#RECORD_ID#'

Posted: **Fri Sep 14, 2018 6:03 am**

Andrew,

I think that is the way to go.

Steven

Posted: **Fri Dec 23, 2022 1:21 am**

Hi,

Any other alternative for multiline text object?

nuBuilder Forum

multiline text object not working in page footer

multiline text object not working in page footer

Re: multiline text object not working in page footer

Re: multiline text object not working in page footer

Re: multiline text object not working in page footer

Re: multiline text object not working in page footer