Home » Developer & Programmer » Reports & Discoverer » REPORT COLUMN NAME CHANGING (FORMS 6I)
icon7.gif  REPORT COLUMN NAME CHANGING [message #391177] Wed, 11 March 2009 06:31 Go to next message
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 .





Re: REPORT COLUMN NAME CHANGING [message #391200 is a reply to message #391177] Wed, 11 March 2009 07:42 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: REPORT COLUMN NAME CHANGING [message #391726 is a reply to message #391177] Fri, 13 March 2009 03:53 Go to previous message
AAKHEEB
Messages: 9
Registered: June 2004
Junior Member
Thank you very much for the replay.
its helped me alot.
thanks again.
Previous Topic: date as page item
Next Topic: How to modify text in OD
Goto Forum:
  


Current Time: Sat Dec 10 22:24:37 CST 2016

Total time taken to generate the page: 0.15439 seconds