Solved

Crystal Reports VB.net

Posted on 2009-04-08
6
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

734 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