Report not displaying certain characters [message #245205] |
Fri, 15 June 2007 07:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
garyt
Messages: 8 Registered: May 2007
|
Junior Member |
|
|
I've got a report that needs to display a list of names.Some of the names have characters like "." or "-" or "\", when I run the report it gives me the names without those characters.
Whats up ?
|
|
|
|
Re: Report not displaying certain characters [message #245454 is a reply to message #245205] |
Sun, 17 June 2007 09:40 ![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) |
garyt
Messages: 8 Registered: May 2007
|
Junior Member |
|
|
I quite new to reports, what I did was create a report with a simple query like :
SELECT name
FROM persdata
WHERE name LIKE '%/%'
OR name LIKE '%\%'
OR name LIKE '%-%';
So that returns all the names with those characters in them, when I run the report though, it displays those names but without the specified characters.
I did not create a REPLACE function or a formula column.
|
|
|
|
|
|
Re: Report not displaying certain characters [message #245641 is a reply to message #245205] |
Mon, 18 June 2007 04:54 ![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) |
garyt
Messages: 8 Registered: May 2007
|
Junior Member |
|
|
I tried with Courier New, did not work.
How do you change the font ? I went to 'Report Editor', then clicked on 'Paper Design', then selected the field displaying the names from the query, then selected Courier New from the list of fonts in the tool bar. Is that correct ?
|
|
|
Re: Report not displaying certain characters [message #245661 is a reply to message #245641] |
Mon, 18 June 2007 06:07 ![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 |
|
|
Yes, that's the way to do it. But, obviously, it didn't solve your problem. Reading your question once again, I believe I was very wrong about the font you used.
Let me try again: this is (part of) a query you used:SELECT name
FROM persdata
WHERE name LIKE '%/%'; In SQL*Plus, it does return valid values, such asHowever, when you execute the same query in Reports Builder, you see it as Right, so far?
What would this query display in Reports Builder:SELECT 'Little/foot' name FROM dual; Do you see a slash sign or not?
|
|
|
|
|
|
|
|