Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Reports VB.net

Posted on 2009-04-08
6
Medium Priority
?
337 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
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 process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses

715 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