Crystal Reports/Crystal Viewer and VB.NET

Tech-Archive recommends: Speed Up your PC by fixing your registry

Before posting my problem, here is some background (information that I
think might be requested if I don't include it).

The Machines:
* Production (+CR9 Redistributable Runtime Stuff [Crystal
Viewer?])
* Development (+Crystal Reports)

Software in Use:
* Windows XP
* Visual Studio 2003
* SQL Server
* VB.NET
* Crystal Reports 9 (Developer)

The Report:
* Stored on a networked drive, accessible via Development and
Production machines.
* Connects via ODBC (ODBC available on both machines, exactly the
same) to the SQL Server database
* Takes 2 parameters
* Works _great_ in the Crystal Report Designer (on the Development
machine)
* Works _great_ in VB.NET+Crystal Viewer (on the Development
machine)
* Does _NOT_ work in VB.NET+Crystal Viewer on Production Machine
(produces the dreaded 'rowset' error)

VB.NET:
* A form that has a CrystalReportViewer.
* Loads the specified report, passes 2 parameters
* The report (should) appears w/ a print dialog.

The Problem:
The problem is that I am not sure what the heck is wrong. The report
works great on the development machine when ran directly within
Crystal Report Designer *or* called by the VB.NET.app within Crystal
Viewer.

However, once I deploy the VB.NET app to the Production machine and
try to run the application I *always* receive the following error,
"failed to open a rowset" exactly twice. After clicking 'Ok' the
CrystalReportViewer remains opened but blank, until closed manually.


Things I Know:
I know both Development and Production computers can reference the
report correctly (and in the exact same manner)
I know the ODBC connection is working (on both computers) because I
can use it manually/otherwise.
I know the Production box has the required CR9 Redistributable Runtime
Stuff [Crystal Viewer?] files because if I uninstall it the VB.NET
applications errors immediately.
I know the Report is correct because I have had Crystal Reports verify
the database.


Well, I don't know what other information might be helpful. I hope
I've included enough background information to help diagnose the
problem.

.

Relevant Pages

  • Re: HELP! Data source wont change
    ... > Report object to a RPT file ... > ' Use the rangeInfo enumerated constants to include lower bound and ... >>application as a Crystal Reports design component. ... >>to my production environment, the report, when run, will display data ...
    (microsoft.public.vb.crystal)
  • HELP! Data source wont change
    ... I'm using Crystal Reports 9 and VB 6. ... that contains the Crystal Reports viewer to view the report. ... environment and then run the application, ... to my production environment, the report, when run, will display data ...
    (microsoft.public.vb.crystal)
  • Re: Liar Liar Pants On Fire Dept: Moller
    ... I think it's kinda funny that the best you can find in the report ... supports my position (that no one could verify that Iraq had actually ... production facilities were destroyed. ...
    (alt.politics)
  • Re: Help with table structure for manufacturing production counts
    ... I currently receive a weekly report from the plant managers that gives Model numbers, quantity built, and how many have each various options (ie: color, glass doors, casters, compressor hp, voltage etc). ... The buyers in the purchasing department use the data from this report to help them keep track of inventory of their purchased components and predict what they need to buy in the upcoming weeks. ... I began to set up a table to use to house the data that comes from the weekly production reports ...
    (microsoft.public.access.gettingstarted)
  • Re: B-17s flew missions over wartime Europe
    ... accuracy report gives the average bombing height for 8th Air Force ... expected circular error was 570 feet at 10,000 feet, 830 feet ... and loss of production, then later in the month the same thing for USAAF ... the USSBS has tables and graphs of German ...
    (rec.aviation.military)