OraFAQ Forum: Reports & Discoverer » automatic update reports if column added in database

Home » Developer & Programmer » Reports & Discoverer » automatic update reports if column added in database

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

automatic update reports if column added in database [message #234745]

Thu, 03 May 2007 01:52

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

Report message to a moderator

Re: automatic update reports if column added in database [message #234884 is a reply to message #234745]

Thu, 03 May 2007 07:04

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: automatic update reports if column added in database [message #235113 is a reply to message #235027]

Fri, 04 May 2007 02:01

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.

Report message to a moderator

Re: automatic update reports if column added in database [message #235125 is a reply to message #235113]

Fri, 04 May 2007 02:31

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

have u tried it if yes then send the rdf...

Report message to a moderator

Re: automatic update reports if column added in database [message #235155 is a reply to message #235113]

Fri, 04 May 2007 03:27

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: automatic update reports if column added in database [message #235202 is a reply to message #235155]

Fri, 04 May 2007 05:45

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

Report message to a moderator

Re: automatic update reports if column added in database [message #235206 is a reply to message #235202]

Fri, 04 May 2007 05:58

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 06:24:23 CST 2024