Solved

Crystal Reports VB.net

Posted on 2009-04-08
6
329 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 70

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 70

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# guarantee sql connection close 6 39
Publisher:   Unknown     VB.exe Application 1 19
JQuery JavaScripot loop though RadioButtonList 4 25
.NET 2008 VB and C# 6 27
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

776 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