delimiter in oracle reports [message #426034] |
Tue, 13 October 2009 21:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
radhavijaym
Messages: 65 Registered: December 2008 Location: singapore
|
Member |
|
|
Hi All,
i had a report i had many columns in my layout so i want to use delimiter '^' for columns in my report.
how to set delimiter for columns in an oracle reprot.
thanks,
radha
|
|
|
Re: delimiter in oracle reports [message #426055 is a reply to message #426034] |
Wed, 14 October 2009 00:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Wouldn't you, rather, create a text box around the value (and, thus, distinguish one value from another)? You'd do that simply by selecting a field and setting its "line color" to ... black, for example.
Otherwise, if you insist on delimiting values by a certain character, you'd have to concatenate it with all values of the select statement, such asselect id ||'^'|| name ||'^'|| address ||'^'|| telephone
from some_table
Note that such an approach requires additional job on your side as all those values probably won't have the same length which means that you wouldn't have strict columns but somewhat scrambled output, difficult to read. Therefore, you'd have to use TO_CHAR function for numbers, RPAD for characters and/or some other functions which would make the output readable.
If I were you, I wouldn't do that. (Unless there's some hidden reason you didn't share).
|
|
|
|
|
|
Re: delimiter in oracle reports [message #427561 is a reply to message #426349] |
Fri, 23 October 2009 04:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
beginnerHere
Messages: 55 Registered: October 2009
|
Member |
|
|
hey radha,
if you are to print the report then why don't you generate it through File->Generate to file-> and then choose what format you want to save it in and specify the delimiter there. you have various delimiters to choose from
|
|
|