Home » Developer & Programmer » Reports & Discoverer » Queries in data model of report (reports 10g builder)
Queries in data model of report [message #327700] Tue, 17 June 2008 05:48 Go to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
Hi,
I am using report 10g builder.
I am copying the select statements from 1 instance of data model to another then the column alias are changed with extension'_'.
I am not able to edit the field name.
Is it possible to change the name?
Please see the attachment for more details.
  • Attachment: report.jpg
    (Size: 35.25KB, Downloaded 772 times)
Re: Queries in data model of report [message #327718 is a reply to message #327700] Tue, 17 June 2008 06:27 Go to previous message
Littlefoot
Messages: 21822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As two fields can not have the same name, you'll have to open Q12 query and - if you don't like suggested aliases - rewrite the SELECT statement in order to modify field names as you wish. For example, if it was
SELECT id, name
FROM ...
that made field names look like "id_" and "name_", modify the query to
SELECT id customer_id, name customer_name
FROM ...

If you wanted to change field name in Data Model Editor "directly" (by overtyping the old name), I'm quite sure that you can't do that.
Previous Topic: Printer Tray control from Develper 6
Next Topic: passing/testing DATA parameter
Goto Forum:
  


Current Time: Tue Nov 12 22:04:39 CST 2024