Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reports with two datasource

Status
Not open for further replies.
rhubi

rhubi

Programmer
Aug 24, 2006
15
SG
good day!

i am developing report but the problem is i have to use datasource other than oracle database. i will be using a column in oracle then the description of that field is in microsoft access. how could i possibly do that?

thanks!
 
Sort by date Sort by votes
Starting from Reports 9i, you may use JDBC query object to connect to Access
 
Upvote 0 Downvote
thanks but i am using reports 6i. would you know if it has a counterpart on 6i?
thanks again.
 
Upvote 0 Downvote
AFAIK, Reports 6i do not have this functionality. You may try using Ref cursor query and reach Access tables from the PL/SQL code. Chances are there is a library or procedure out there to do this.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OrangeMonkey
  • Locked
  • Question
Reports Builder Novice
Replies
0
Views
143
OrangeMonkey
OrangeMonkey
blobby36
  • Locked
  • Question
crystal reports command and oracle tables
Replies
1
Views
115
oradba101
oradba101
soushi01
  • Locked
  • Question
Oracle reports bulider cannot use CASE WHEN statement 1
Replies
4
Views
182
soushi01
soushi01
thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
202
thatgirl100
thatgirl100
KenCunningham
  • Locked
  • Question
Reports 10G Single Sign On issue
Replies
0
Views
88
KenCunningham
KenCunningham

Part and Inventory Search

Sponsor

Back
Top