OraFAQ Forum: Reports & Discoverer » REPORT COLUMN NAME CHANGING

Home » Developer & Programmer » Reports & Discoverer » REPORT COLUMN NAME CHANGING (FORMS 6I)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REPORT COLUMN NAME CHANGING [message #391177]

Wed, 11 March 2009 06:31

AAKHEEB
Messages: 9
Registered: June 2004

Junior Member

hi,

i designed report with following query
select empno,fname from emp and its fine.
i changed the query to
select empno,substr(fname,1,3) fname from emp;

in result column names all in my report changed to
empno1 ,fname1 instead of empno,fname

every time i am channging query its keep changing the name
to empno2,empno3......and so.

how to avoid this i hardcoded this column name so many places in this report.

Any body help me .

Report message to a moderator

Re: REPORT COLUMN NAME CHANGING [message #391200 is a reply to message #391177]

Wed, 11 March 2009 07:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes, it is annoying ... and I don't have a smart way to solve it.

However, I can tell you what I do: in the first step, I rename (i.e. create column aliases), such as

select empno my_empno, substr(fname,1,3) my_fname from emp

which eliminates "empno1" and "fname1" labels. Next step is to name them as they should be named:

select empno, substr(fname,1,3) fname from emp

Sorry for not being able to help you any better.

Report message to a moderator

Re: REPORT COLUMN NAME CHANGING [message #391726 is a reply to message #391177]

Fri, 13 March 2009 03:53

AAKHEEB
Messages: 9
Registered: June 2004

Junior Member

Thank you very much for the replay.
its helped me alot.
thanks again.

Report message to a moderator

Previous Topic:	date as page item
Next Topic:	How to modify text in OD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:57:34 CST 2024