Current Position:Home > 2 data sources (oracle db) for the same report

2 data sources (oracle db) for the same report

Update:11-30Source: network consolidation
Advertisement
Hi
I was wondering if I can have 2 sources (could be same or different instances). Example, I want to get information from one instance in the report trigger, and output of that i pass to the report (inside the query in the where clause).Is this possible with Oracle reports?
Any help appreciated.
Thx!

The Best Answer

Advertisement
Hi Dan
Thanks for the response.
I need some information (in before report trigger) - from one oracle instance - and then pass this information as a parameter to the report - whose output will come from another oracle instance.
I haven't given it a try yet what you had recommended but will do so.
Thx!
  • 2 data sources (oracle db) for the same report Update:11-30

    Hi I was wondering if I can have 2 sources (could be same or different instances). Example, I want to get information from one instance in the report trigger, and output of that i pass to the report (inside the query in the where clause).Is this poss

  • JDBC runtime error using data source (Oracle 9i server & Oracle 8i client) Update:10-11

    Hi, Wud someone help me with this? Why am I getting this run-time error? D:\shilpa\javaprogs>java -classpath %classpath%;.; CreateMovieTables javax.naming.NoInitialContextException: Need to specify class name in environmen t or system property, or as

  • Cannot create new Data Source - Oracle ODBC does not show in System DSN Update:11-30

    On Windows 7 x64, Installed Oracle 10g to use ODBC to connect to Oracle database but am not able to create new data source as Oracle ODBC does not show in System DSN.... only shows SQL server etc etc...If you installed 32-bit Database Client, try the

  • PowerPivot supported Data Sources [Oracle] Update:11-30

    Reading about Supported data sources in Office help page I see: '.NET Framework Data Provider for Oracle Client' Does this refers to Oracle's ODP.NET Managed dll? I succesfully installed Oracle's managed dll with xcopy/deployment [platform: both] [ma

  • Change Data Source for a lot of Crystal Report Update:10-11

    I have a lot of reports which use Visual FoxPro as datasource. We will mirgrate to MS SQL Server and change the names of tables. Is there any way to set data source to new table in new ODBC other than do it manually ? Please advice. Thanks.Hi Leo, If

  • Change crystal report data source dynamically failed with multi tables report Update:10-11

    hello all i have many reports created by someone else on his own machine using same database file i use my application use Visual studio 2013 win form with crystal report pack 9 i use rpt files provided to me connect database use OLEDB to show form i

  • CrystalReports error in XI 3.1 with Oracle Data Source Update:10-11

    Having trouble running Crystal Reports with Oracle data source off XI 3.1 SP3. Reports hang through CMC or InfoView. Have no trouble on identical environment (presumably) with the same reports. Basically this happened after migration. Report can be r

  • ODBC Data Source Not Available Update:10-11

    Completed installation of Oracle Business Intelligence Enterprise Edition, when attempting to configure data source, Oracle in OraClient 10g home 2 is not an available driver, attempting to connect to an Oracle Database, can connect correctly PL SQL?

  • Switching Data Source for a report with stored procedure Update:10-11

    Post Author: ysbn CA Forum: Data Connectivity and SQL I've created a report and deployed it on a Crystal Server. The report is based on a certain stored procedure which also exists on other DB machines in my environment (Oracle machines). When I try

  • Even with parameters, reports reading entire data source and then filtering Update:10-11

    I'm working with an Oracle database (read-only access) and Crystal Reports 2008.  I have created a report and added three parameters for which I have already done all necessary steps in the select expert.  But when I do a Print preview of the report,