| Unable to display additional space in the parameter values (merged by CM) [message #454273] |
Tue, 04 May 2010 16:54  |
gentleman777us
Messages: 122
Registered: April 2005
|
Senior Member |
|
|
Hi,
I have converted oracle 6i report to 10g. The report when converted to oracle 10g does not display the additional space in the values of the parameter form.
ex: in 6i for one of the parameter contains persons name and office. In oracle 6i it displays as follows
David Gibster OFFICE1
Gilbert Dawn OFFICE2
In 10g report parameter form the same list is displayed as follows
David Gibster OFFICE1
Gilbert Dawn OFFICE2
The space betwee name and office is trimmed. Is there anyway in oracle 10g we could display the list as in 6i.
Additional Info:
Iam running oracle reports in Unix.
Thanks
CM: When showing an issue with formatting it pays to use [code] tags to preserve the formatting. I've added them for you this time, but next time please do so yourself - see the orafaq forum guide if you're not sure how.
[Updated on: Tue, 04 May 2010 17:59] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Unable to display additional space in the parameter values (merged by CM) [message #454456 is a reply to message #454288] |
Wed, 05 May 2010 11:57  |
gentleman777us
Messages: 122
Registered: April 2005
|
Senior Member |
|
|
List of values is based on the following query:
select
0,
' ',
' '
from dual
UNION
SELECT
distinct(presubmissions.RPM_ID),
Person.NAME_LAST ||', '|| Person.NAME_FIRST ||' '|| Person.Name_MI,
' ' || Person.Office
FROM
PERSON Person,
PTS_PRESUBMISSIONS presubmissions
WHERE presubmissions.RPM_ID = Person.PERSON_ID
ORDER BY 2 NULLS FIRST
The data type for person id is Number, and everything else is char
Thanks
[EDITED by LF: formatted and applied [code] tags]
[Updated on: Wed, 05 May 2010 14:58] by Moderator Report message to a moderator |
|
|
|
| Re: Unable to display additional space in the parameter values (merged by CM) [message #454475 is a reply to message #454456] |
Wed, 05 May 2010 15:05 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
What is distinct (presubmissions.RPM_ID)
Whyand not simply
Is it a "standard" Reports' list of values on the parameter form? Could you post a screenshot? I don't have Reports here to check, but - as far as I can recall - columns are nicely aligned in version 10g (as if font was Courier); nothing strange and nothing special to be done in order to achieve such a result.
I can't imagine what might be wrong.
[Updated on: Wed, 05 May 2010 15:05] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
