Using multiple tables and 1 group

[keylen]

Hi everyone.....

I am using Crystal reports embedded in VS .NET but I am actually having problems with my principal report

I´ve 2 DB, one DB is MySQL and the another is Access.

I have a table in my access database called "TblSpot", this table contains spot info (its columns are spotName, productName,ClientName, spotURL, spotVersion,spotDurationn) actually this table contains only 17 data rows.

I have a table in MySQL database called "TblSpotReproduction", it contains spot reproduction info (its columns are spotName. playerName, reproductionTime) also it has 150000 data rows.

I tried to make a report grouped by SpotName with only TblSpotReproduction:

SpotName <------ Init Group Header
---------------------------------------------
playerName reproduction Time
---------------------------------------------------
<---------End Group Header

ALL DATA
..
.
.
.
.

----------------------------
Group Foot

Next group etc etc etc


This report works perfectly. It shows the solution delayed but it works perfectly.

But my client ask me to make a better report that include spot information. For that i´d to include the Access database. My new report must be like this:

SpotName <------ Init Group Header
spotURL
spotVersion
Client
Product
spotDuration
---------------------------------------------
playerName reproduction Time
---------------------------------------------------
<---------End Group Header

ALL DATA
..
.
.
.
.

----------------------------
Group Foot

Next group etc etc etc

My problem is that this reports never open, i think that the combination of 2 databases causes CR crash, maybe the combination between 150000 rows with 17 rows make a impossible JOIN. Friends told me I have to use sub-reports but i have no idea how to use them on the fly.

P.D. Sorry for my really bad english.


Thanks for advance-----

Keylen