If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#40872 by rbross
Mon Oct 03, 2016 10:32 pm
Hello,

Is there a way to include a CR or Line Break in a report Tag?
I want to format an address in one tag control on the form instead of having multiple tags.
Can you use ASCII codes in a tag element?
I see that html does not work in a standard AwareIM Report.

Roger
#40873 by kklosson
Mon Oct 03, 2016 11:11 pm
I did it once but I don't remember quite how. I have put a carriage return element into the SystemSettings then insert <<SystemSettings.LineBreak>> into the report. I just can't remember how I captured the line break - but I did.
#40883 by rbross
Tue Oct 04, 2016 1:38 am
Tom,

Tried added SystemSettings.CR and then doing 'Enter' on the CR field.
I added the SystemSetting.CR to my Tag Control formatted like this:

TRIM(Contact.ContactBusinessName)+SystemSettings.CR+
TRIM(Contact.PhysicalAddress1)+SystemSettings.CR+
TRIM(Contact.PhysicalAddress2)+SystemSettings.CR+
TRIM(Contact.PhysicalCity)+' '+TRIM(Contact.sc_State_PhysicalStateCode)+' '+Contact.PhysicalZipCode

BUT no luck no CR?
Is the CR attribute plain text or a numeric field. How ling should it be?

Roger
#40887 by rbross
Tue Oct 04, 2016 2:08 am
Now to get the proper format so it skips address2 if it is blank so it does not have blank lines in the address when it iis printed.

Any idea's?
#45137 by Jaymer
Mon Oct 09, 2017 3:17 am
Using v8, and MySQL

I added the CR field from SystemSettings to a form.
I could not get a CR to "stick" in the field. using Safari (Mac), I tried pasting in a CR (copied to clipboard from a text field in an app) but Aware didn't think I'd changed the field because if I clicked Close, it didn't say that there had been changes to fields on the form.

Using TOAD EDGE on Windows, I could edit the CR field in their mini editor, and enter a CR, but it wouldn't stick either.

Then, a simple SQL statement set it just fine.
update testbo_systemsettings
set CR = '\n'
#45144 by rbross
Mon Oct 09, 2017 11:43 am
When you enter the CR in SystemSettings you just park on the CR field and press the Enter key. You will not see any value but the character is there. Then in the report, you have your BO.Attr+systemstettings.CR and it will do the carriage return for you. works good for formatting addresses.
Good to know '\n' works as well.
#45151 by Jaymer
Mon Oct 09, 2017 3:32 pm
rbross wrote:When you enter the CR in SystemSettings you just park on the CR field and press the Enter key. You will not see any value but the character is there. Then in the report, you have your BO.Attr+systemstettings.CR and it will do the carriage return for you. works good for formatting addresses.
Good to know '\n' works as well.


Roger, I read that above, but that DID NOT work for me.
I looked at the raw data (via MySQL) and it did not save a CR.
have you done this recently in v8 - maybe something changed.

Who is online

Users browsing this forum: No registered users and 27 guests