Crystal Reports VB.net

Hi,
I have created a crystal report with sub reports using visual studio 2005 (vb.net). I have created 4 stored procedures to get the data for all the reports with all procedures using @siteid as a parameter. I have updated the sub report links to use the @siteid parameter from the main report and all works fine on the development machine. When I install the application/database on a client machine I get promted to enter the @siteid parameter for each sub report. I added code to the application to change the location of each sub report at runtime but I then get an error:-

This field name is not known.
Error in <path> & sub report <file name> .rpt
Error in formula <Record Selection>.
'({<report_name>;1.site_id}={?@siteid})'
This field name is not known.

Does anybdy know how to resolve this issue?
continumAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
continumConnect With a Mentor Author Commented:
I have now fixed the problem. This problem is related to a Crystal bug. The fix I installed on the client machine is ftp://ftp1.businessobjects.com/outgoing/CHF/crnet20win32x86_en_chf.zip

This corrected the problem immediately without any code change.

Thanks for your comments anyway
0
 
Haris VCommented:
0
 
Éric MoreauSenior .Net ConsultantCommented:
this is one of the reason why I push data to CR (instead of having querying the database itself). see http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
0
 
mlmccCommented:
I agree with emoreau.  This is one of the more frequently asked questions and also one that it seems to have limited success in resolving.

mlmcc
0
 
Éric MoreauSenior .Net ConsultantCommented:
you should ask to send this question to PAQ (accepting your own comment) since it may help other people.
0
All Courses

From novice to tech pro — start learning today.