Solved

Receiving error trying to access a Crystal Report???

Posted on 2013-11-01
12
241 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 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

18 Experts available now in Live!

Get 1:1 Help Now