Crystal Subreport - Passing Parameters

Good Day
Experts:

I am having a bit of trouble with a Crystal Report that contains a Subreport.  That Subreport gets it's data from a Stored Procedure which takes a parameter supplied by the main report.  It is apparent that I need additional coding in my VB.net application as the report works fine from the Crystal Editor.  I have attached my code in a file that shows what I am doing so far.  I am changing the connection information at the Subreport level...so I think I am close here.  Just not sure how to pass the parameter that the S/P requires.

I have tried searching the net for assistance but have not found a conclusive solution.  

Thanks,
jimbo00000
SubReport.doc
Jimbo99999Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jimbo99999Connect With a Mentor Author Commented:
Thanks for your replies.  I had to apply a hotfix with a couple new dll's.  

jimbo99999
0
 
mlmccConnect With a Mentor Commented:
I believe the code you are using to pass parameters to the main report should work but you need to do it with the subreport object.

mlmcc
0
 
Jimbo99999Author Commented:
We found the following ServicePack --> CrystalReportForVisualStudio2005_SP1

One of the items that was a fix involved the ParameterFieldDefinition.IsLinked property which returns a boolean indicating whether the parameter field is the link between a SubReport and the Main report.  This property was always returning false.

My Report is now working as designed.

Thanks,
jimbo99999

0
 
nismotoConnect With a Mentor Commented:
Have you tried to set the sub-report parameters in the main report? Open the report in the editor (VS or Crystal), right-click on the sub-report and select "Change Subreport Links..." (see screenshot).
screenshot.png
0
All Courses

From novice to tech pro — start learning today.