Solved

Receiving error trying to access a Crystal Report???

Posted on 2013-11-01
12
244 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
Variable Event ? 3 36
Help with exporting to excel 4 35
How to duplicate form in Visual Studio 2015 2 57
Passing data between Forms 3 20
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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

808 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