Home » Developer & Programmer » Reports & Discoverer » error in report builder (report builder 6i)
error in report builder [message #517817] Thu, 28 July 2011 09:41 Go to next message
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 798 times)
Re: error in report builder [message #517826 is a reply to message #517817] Thu, 28 July 2011 10:10 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: error in report builder [message #517840 is a reply to message #517826] Thu, 28 July 2011 11:50 Go to previous messageGo to next message
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 ..
Re: error in report builder [message #517851 is a reply to message #517840] Thu, 28 July 2011 13:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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
Re: error in report builder [message #517860 is a reply to message #517851] Thu, 28 July 2011 23:16 Go to previous messageGo to next message
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
Re: error in report builder [message #517861 is a reply to message #517860] Thu, 28 July 2011 23:22 Go to previous messageGo to next message
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
Re: error in report builder [message #517864 is a reply to message #517861] Fri, 29 July 2011 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: error in report builder [message #517865 is a reply to message #517864] Fri, 29 July 2011 00:23 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

/forum/fa/9230/0/


Please see the image only here it is changing

[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 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

/forum/fa/9231/0/

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 1621 times)
Re: error in report builder [message #517869 is a reply to message #517866] Fri, 29 July 2011 00:44 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: error in report builder [message #517870 is a reply to message #517869] Fri, 29 July 2011 00:52 Go to previous messageGo to next message
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
Member

thnks for support littlefort..

Can any one help on this issue
Re: error in report builder [message #517892 is a reply to message #517870] Fri, 29 July 2011 03:54 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: error in report builder [message #517933 is a reply to message #517892] Fri, 29 July 2011 09:33 Go to previous message
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 ....
Previous Topic: OG-01603
Next Topic: rep-1213 & rep-1517
Goto Forum:
  


Current Time: Thu Mar 28 11:33:35 CDT 2024