Subreports ok in preview, don't run correctly in VB6

[mpdinosaur]

Folks;

I've got a main report with multiple subreports. The subreports are passed an id as a parameter. When I check the preview (in Crystal) it works fine. When I run it through VB6, the 2nd and 3rd subreports work fine, the 1st and 4th don't find any data.

I've verified the parameters my VB6 program is sending, I've verified that the parameters are being received by the report. I've double checked by record selection formula in the subreports (all 4 are identical). I've even verified that the 4 stored procedures actually retrieve data.

Don't know what else to check. I'm running CR8.5, VB6 and MSSQL2000.

Thanks in advance for your help.


MikeTheDinosaur

 

[IdoMillet]

Do all 4 subreports receive their parameter values as links from the main report? It sounds like 2 of the subreports expect their own parameter values...

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mpdinosaur]

I'm still kind of new to Crystal, so I'm not 100% sure of your terminology, but I've verified (by printing the value of the parameter on the subreport) that the value is, in fact, making it to the subreport. Here's the subreports record selection formula:
{spProductUseProfitAnalysis2.LocationID} = {?Pm-spProductUseProfitAnalysis.LocationID}

Got any ideas?

Thanks for the response.

MikeTheDinosaur