mysql - SSRS mutiple database source to be joined -

just stuck on getting information 2 sources, have mysql database repairs information have in ssrs, brings 7000 rows. have repairs database in oracle brings on 3 million rows.

i can't seem bring 1 oracle exceeds maximum limit, there way left join using can bring 2 columns need oracle 1 mysql 1 mean have 7000 rows plus 2 columns oracle have common primary key. can't seem join on 2 dataset being on 2 database.

can help.

thank in advance

you can use lookup function in ssrs find value 1 dataset based on common key.

=lookup(fields!saleprodid.value, fields!productid.value,  fields!name.value, "product") 

use lookup retrieve value specified dataset name-value pair there 1-to-1 relationship. example, id field in table, can use lookup retrieve corresponding name field dataset not bound data region. (bids description)

in above example, salesprodid 1 dataset being used relate productid in product table name field.

this return 1 value, though. may or may not ok depending on data. if need return multiple values, use lookupset.

=lookupset(fields!territorygroupid.value, fields!territoryid.value, fields!storename.value, "stores") 

use lookupset retrieve set of values specified dataset name-value pair there 1-to-many relationship. example, customer identifier in table, can use lookupset retrieve associated phone numbers customer dataset not bound data region.

unfortunately, might need sum lookup isn't supported function in ssrs. fortunately, users created function it:

ssrs count occurances based on multiple columns