OraFAQ Forum: Reports & Discoverer » error in report builder

Home » Developer & Programmer » Reports & Discoverer » error in report builder (report builder 6i)

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

error in report builder [message #517817]

Thu, 28 July 2011 09:41

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

In report builder when i modified the code ,At compilation time one of the column name is changed.
eg : empno is changed to empno1

please Can any one help on this its urgent

Attachment: Capture.PNG
(Size: 10.28KB, Downloaded 994 times)

Report message to a moderator

Re: error in report builder [message #517826 is a reply to message #517817]

Thu, 28 July 2011 10:10

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Reports does that when you select the same column twice in the same report and don't use column aliases to distinguish them.
Is it causing you an actual problem?

Report message to a moderator

Re: error in report builder [message #517840 is a reply to message #517826]

Thu, 28 July 2011 11:50

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

hi,
thanks for reply..
in this query am not using any allias names .my problem is I have modified a report querry , the modified one is running successfully in Toad ,and I replaced this modified query in place of old report and compiled after compilation the column names are changing..
ex : column name plant changed to plant1 ..

Report message to a moderator

Re: error in report builder [message #517851 is a reply to message #517840]

Thu, 28 July 2011 13:50

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

Senior Member
Account Moderator

Yes, that happens sometimes.

Try to do the following:
- open the query
- remove the PLANT column from the SELECT statement
- click <OK>
- make sure that the column is no longer visible in the Data Model Editor
- reopen the query
- include the PLANT column into the SELECT statement again
- click <OK>
- it should be there now, having its original name

Report message to a moderator

Re: error in report builder [message #517860 is a reply to message #517851]

Thu, 28 July 2011 23:16

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

hi littlefoot ,
thanks for reply
yes it will work but this column is used in many group and sum functions this not possible to change in all places ..
whether there is another way to solve this issue..its urgent

Report message to a moderator

Re: error in report builder [message #517861 is a reply to message #517860]

Thu, 28 July 2011 23:22

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

hi LittleFoot when i changed the column name Am getting error while running the report as Field plant(one of column name in my querry) references invalid column

Report message to a moderator

Re: error in report builder [message #517864 is a reply to message #517861]

Fri, 29 July 2011 00:09

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

Senior Member
Account Moderator

if the column is used in many places, it is used with its original name: PLANT. "Invalid" name, the one you are trying to get rid of, is PLANT1. So, the only place it is "invalid" is the original query. I don't think that this should be a problem (i.e. my previous suggestion *should* work) - at least, I believe so.
"referencing an invalid column" means that you didn't use it correctly. If you use table aliases, you used the wrong one. If you think that you referenced the right table, then it doesn't contain that column.

Report message to a moderator

Re: error in report builder [message #517865 is a reply to message #517864]

Fri, 29 July 2011 00:23

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

Please see the image only here it is changing

Attachment: Capture old.PNG
(Size: 11.45KB, Downloaded 2134 times)

[Updated on: Fri, 29 July 2011 00:24]

Report message to a moderator

Re: error in report builder [message #517866 is a reply to message #517865]

Fri, 29 July 2011 00:28

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

see the above image it is not changing in xml settings..please observe both places marked with arrow

Attachment: Capture.PNG
(Size: 16.62KB, Downloaded 2050 times)

Report message to a moderator

Re: error in report builder [message #517869 is a reply to message #517866]

Fri, 29 July 2011 00:44

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

Senior Member
Account Moderator

OK, but I don't have anything new to say. Remove the column, include it back again.

Report message to a moderator

Re: error in report builder [message #517870 is a reply to message #517869]

Fri, 29 July 2011 00:52

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

thnks for support littlefort..

Can any one help on this issue

Report message to a moderator

Re: error in report builder [message #517892 is a reply to message #517870]

Fri, 29 July 2011 03:54

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Try aliasing the column to it's own name.
2) Is the change of name actually causing you a problem? Why does it matter?

Report message to a moderator

Re: error in report builder [message #517933 is a reply to message #517892]

Fri, 29 July 2011 09:33

shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad

Member

My querry having a column alias as plant when i developed the report then report is successfully developed but when I modified the query and placed this modified query in my old report then all column names are changed...our column having a function in report so it is showing error at compilation time .
to avoid this we have developed a new report....now problem is solved..
But I want to know why this happens ....

Report message to a moderator

Previous Topic:	OG-01603
Next Topic:	rep-1213 & rep-1517

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 06 19:13:39 CST 2025