report from view [message #289065] |
Wed, 19 December 2007 07:32 |
kand
Messages: 20 Registered: November 2007 Location: USA
|
Junior Member |
|
|
Hi all
I need to create a report and for this first i need to do the ETL part for this i need to use a view from another datavase,can u please tell me , how toimport a view in to the canvas?
Thanks
|
|
|
Re: report from view [message #289072 is a reply to message #289065] |
Wed, 19 December 2007 07:46 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Use a view as a data source in SELECT statement of the report's query (or one of available PL/SQL objects - report triggers, formula columns, etc.).
|
|
|