mixing datasources in a report via asp crviewer

[duckyboyz]

I have a report and I'm getting the generic "20618" error. I'm tryin to use stored procedure in the main program and tables as the datasource in the subreport. Reason for this the look up is faster in the main report using a stored procedure where as, I need the table datasource in the subreport because i'm accessing an image field. I could'nt include the image field via the sp, cr8.0 does'nt like that.

Can you mix datasources like this?

using sql200, asp as the front end, and cr8.0.

 

[synapsevampire]

You should be able to.

Since a subreport is a different query, I would think that it would work OK. If you open the report in CR 8 directly does it work?

Is the subreport linked to the main report?

-k

 

[duckyboyz]

works fine running it in crystal.. just when i try to run it through asp via. the crviewer... i get that generic error when using mixed datasources. I thought there might have been a problem trying to pass parameters to the sub reports.