Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Receiving error trying to access a Crystal Report???

Posted on 2013-11-01
12
Medium Priority
?
250 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
[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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 101

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 101

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 101

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

636 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