i have done this for an invoice
for a BILL TO and SHIP TO
sections, side by side
I used a temp field.
before printing the invoice, I ran a process which calcs the 2 "address blocks", this also allows removing of blank lines when a "Address Line 2" line is empty.
after the process, I print the invoice which has 1 field for ShipTo and 1 for BillTo
BUT...
remember when you put a tag in the report writer, that means 1 Open and 1 Close marker:
<<Customer.Name + SystemSettings.CR + Customer.Address + SystemSettings.CR + Customer.Account>>
... where SystemSettings.CR is a 1byte field for CHR(13) carriage return
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer, how did you get the carriage return to stay in the field. I have used that technique in another AwareIM app, but when I tried to add it to another application when I hit Enter on the field in system settings it did not store the CHR(13)?
Roger Ross
AwareIM 8.7 (build 3025) ~ MS-SQL ~ Windows 10 ~
AwareIM 8.5 (build 2828) ~ MS-SQL ~ Windows 10 ~
Thank you for your replies.
I'm talking here about Report Designer and having 7 places in the same Report where I have to fill data like this.
Making 7 more columns in mySql is not so good.
Thx,
George
________________________________
Developer Edition AwareIM: v8.5, build 2824 OS: Windows Server 2012 DB: MySql 5.6.42