Home » Developer & Programmer » Reports & Discoverer » automatic update reports if column added in database
automatic update reports if column added in database [message #234745] Thu, 03 May 2007 01:52 Go to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

can reports be automatically updated if the base table has been added with new columns
Ritika
Re: automatic update reports if column added in database [message #234884 is a reply to message #234745] Thu, 03 May 2007 07:04 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
, but first try it yourself then ask such type of questions. I will wait for your answer. Steps are

1. Add a new column in the table
2. Open the report
3. See it the chages automatically comes or not.
4. Please let me know and everybody

Ashu

[Updated on: Thu, 03 May 2007 07:06]

Report message to a moderator

Re: automatic update reports if column added in database [message #235027 is a reply to message #234745] Thu, 03 May 2007 15:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, no - it isn't possible.

Would a query you write automatically reflect newly added column? Of course not! The same goes for Report Builder - it doesn't know you have added a column; query (run in SQL*Plus) would do the job if it was of a "SELECT * FROM some_table" type, but the same query in Report Builder ends up with an error (saying that number of columns selected in a query differs from report definition; REP-0498).

Shortly, you can't expect it to be done automagically.
Re: automatic update reports if column added in database [message #235113 is a reply to message #235027] Fri, 04 May 2007 02:01 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

yes i have tried it but right--i got the same error as told by littlefoot.Isn't there any other method.
Re: automatic update reports if column added in database [message #235125 is a reply to message #235113] Fri, 04 May 2007 02:31 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
have u tried it if yes then send the rdf...
Re: automatic update reports if column added in database [message #235155 is a reply to message #235113] Fri, 04 May 2007 03:27 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sure. Another method is:
- start Report Builder
- open the report
- modify it accordingly to new table description
- compile, generate
- run report
Re: automatic update reports if column added in database [message #235202 is a reply to message #235155] Fri, 04 May 2007 05:45 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

Thanks littlefoot.But that is the manual thing but i was looking out for a flexible report structure
Ritika
Re: automatic update reports if column added in database [message #235206 is a reply to message #235202] Fri, 04 May 2007 05:58 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi ritika,

As littlefoot earlier said that
Quote:
As far as I can tell, no - it isn't possible.


I also don't know that how is it possible that you do somechages in table structure and at the same time its effect in the report?

If you come to know the solution please share with us?

Ashu
Previous Topic: Printing based on the count of records / running total (merged)
Next Topic: Creating Report using the Procedure
Goto Forum:
  


Current Time: Wed Dec 07 20:45:29 CST 2016

Total time taken to generate the page: 0.11030 seconds