Report from 2 different database sources

[2012385096]

Hi,

I am creating a report from 2 database sources. 1 table from SQL and 1 table from Oracle. But there is no way I can join these 2 tables. I need below information from these tables and report should look like this.

Member Name TotalServices
FROM SQL Table ABC 10
FROM Oracle Table ABC 20
-----------
30

FROM SQL Table XYZ 15
FROM Oracle Table XYZ 25
-------------
40

The members are same in the SQL and Oracle Table but there MemberID is different and naming style is different in the both table.

I would really appreciate any help.

Thanks in advance.

 

[lbass]

What do you mean the members are the same, but the "naming style" is different?

-LB

 

[jmd0252]

When you get to the link tab,, do a drag and drop and link the two tables togather,, even if the name are different,, you know what they mean..

 

[2012385096]

Hi,

Most of the members are common in both the tables but some members are in the SQL table but not in the Orcle table and the other way also (Some member are in the Oracle table but not in the SQL table)

Thanks for the response.

 

[lbass]

The question is whether any of the fields are the same--for linking purposes.

-LB

 

[2012385096]

No, there is no field i can link these 2 tables. Even though some members are different in these tables i tried to link them but not getting any records. So it's not working if i joined these tables.

Is there any way i can get this without joining these 2 tables?

Thanks

 

[lbass]

Please show samples of actual member fields from each table. These might be ID or name fields.

-LB

 

[jmd0252]

going back to your original example the ABC and the XYZ,, what are those??