New line formatting
APEXOfficePrint - AOP tips
How to get your AOP showing the new line?
Just a quick demo on how you can create new line using AOP.
Let's say we have a column that contains char(13)char(10) (Carriage return and Line feed) characters which user wants to have reflected on pdf or Word output.
In you source query you would have to do something like:
This is then at run time translated to new lines and everyone is happy.
If you have any questions please do not hesitate.....
Thanks,
Lino
Let's say we have a column that contains char(13)char(10) (Carriage return and Line feed) characters which user wants to have reflected on pdf or Word output.
In you source query you would have to do something like:
select replace('a ' || chr(10)||chr(13)|| ' BBBBBB', chr(10)||chr(13), '\n') as "cust_info" from dual
This is then at run time translated to new lines and everyone is happy.
If you have any questions please do not hesitate.....
Thanks,
Lino
No comments:
Post a Comment