Solved

Receiving error trying to access a Crystal Report???

Posted on 2013-11-01
12
242 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

25 Experts available now in Live!

Get 1:1 Help Now