Solved

Receiving error trying to access a Crystal Report???

Posted on 2013-11-01
12
243 Views
Last Modified: 2013-11-09
I just created a setup package for a VS 2012 application. It's the first one I've ever done. The changes I made to this application was to include a report that prints barcode labels. This was a new report and not a modified one. Anyway, when I tried to access the report to print the labels, the following Error dialog popped up. See attached Screenshot. I don't know if this has something to do with the setup package. I'm guessing it does, since I was able to successfully test this on my local development machine. The install was on another PC altogether.
Screenshot.jpg
0
Comment
Question by:BlakeMcKenna
  • 7
  • 3
  • 2
12 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39617502
What sort of data connection did you use in the report? Did you reconfigure it with correct connection before launching?
0
 

Author Comment

by:BlakeMcKenna
ID: 39617524
I don't understand...I'm sure it has to do with something I did or didn't do because all the other reports work as they should. I created a DataConnection within the CR itself and not within the VB.Net app. Although, there is a SelectionFormula that is established within the application code.
0
 

Author Comment

by:BlakeMcKenna
ID: 39617553
As far as the connection I used it was OLE DB (ADO) using the "Microsoft OLE DB Provider For SQL Server". Why and where would I reconfigure the Data Connection?
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39617645
Is the connection still valid from the computer that you are opening the report on?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39617693
Did the application run reports before you changed it?

What version of Crystal are you using?
Is it the one that comes with VS2012?

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 39617800
The version of CR is 11...we're not using the one that came with VS 2012. The application and it's reports were running fine before my changes. We're running SQL Server 2008 across the network. As far as the DB Connection, I don't know why it wouldn't be valid plus I don't know I would change the Connection to the report. None of the other reports need anything like that...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39617828
DO all reports have a problem or just the new one?

DO all reports use the same database connection?

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 39617846
All other reports are fine. They are all using the same connection. I have a feeling now after looking at it a little closer that it might be trying to access a printer that's name is invalid. It actually retrieves the printer name from the DB and uses that to assign the Label Report to. If that name isn't in the list of printers that the workstation is attached to, then that might be the issue.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39617911
WHen you create the report, make sure you have the default printer set to one the workstation could use on the network

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 39617977
Ok, here is what I'm seeing and it's confusing. The printer name that is assigned to the Label Report during design time is one thing. The target printer name is different. When I copy manually the Label Report over to the target machine, I try to open the report, however, their is a CR version conflict. My development machine has a new version of CR than the target machine, which prevents me from saving any changes.
0
 

Accepted Solution

by:
BlakeMcKenna earned 0 total points
ID: 39621557
I finally figured this problem out. After debugging it further, it was trying to print from an Invalid Printer Name.
0
 

Author Closing Comment

by:BlakeMcKenna
ID: 39635424
I finally figured it out...
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 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