Solved

Crystal Reports VB.net

Posted on 2009-04-08
6
326 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:continum
6 Comments
 
LVL 8

Expert Comment

by:Haris V
ID: 24097452
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 24098529
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 24101021
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
 

Accepted Solution

by:
continum earned 0 total points
ID: 24105684
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
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 24106099
you should ask to send this question to PAQ (accepting your own comment) since it may help other people.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now