continum
asked on
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 }={?@sitei d})'
This field name is not known.
Does anybdy know how to resolve this issue?
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
This field name is not known.
Does anybdy know how to resolve this issue?
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
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
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you should ask to send this question to PAQ (accepting your own comment) since it may help other people.
1. http://www.codeproject.com/KB/vb/CrystalContrl.aspx