Print Preview for reports (Crystal Reports) fails in Vanatge 8.00.808

Vista/Vantage 8
1

image

Print Preview, for Reports, using Crystal Reports, brings up this screen and will not proceed.

2

Do these reports use ODBC?

There are two versions of ODBC32 setup program on 64 bit clients.

image

The shortcut in the Admin Tools points to “C:\Windows\System32\odbcad32.exe”

You might need to config the ODBC on the Client with the odbcad32.exe that is located in the “C:\Windows\SysWOW64” directory

3

Looks similar to our Vantage 6.1
Database: mfgsys (or your actual database name. mfgsys was Vantage default)
Password: sysprogress (same as user)

4

Now I am getting this !

image
image.jpg464×1025 134 KB

5

What happens when you click OK? Are these tied to a BAQ report in Vantage? Or are you trying to create a live connection to the DB from Crystal?

6

Mike - The ODBC setup only applies if the Crystal Report is either ODBC based, or uses sub-report that uses ODBC.

  1. Do you get this for all reports (as in cannot print anything)?

  2. If for just one specific report
    a. Does it print okay on other machines or for other users?
    b. Do other styles of the report print okay

  3. What type of report is it?
    a. Built-in and original V8 style
    b. Built-in but customized style
    c. BAQ report
    d. External report

7

All reports on this machine fail.
The same reports do work on other machines.
It is a Crystal Report.
A connection from Crystal must be made to the DB to update the report I’m sure.

8

I am thinking the Vantage folders were just copied (not installed) on this machine.
Vantage works fine.
I do not think there was actually an install done on this machine.
I had to hack in some registry settings just to get the ODBC page
to be filled out.

9

It almost sounds to me like your Crystal Runtime is the wrong version or needs to be reinstalled.

Also, if this is Version 6 - I seem to remember clearing out your local Cache folder helped us in many cases.

Just a thought.

DaveO

10

When I select Test connection on another machine, it asks me for a password, and then connects successfully.
When I select Test connection on this machine, it does not even ask me for a password.

The version of Crystal Reports Runtime matches what is installed on another working machine.
I un-installed and re-installed it. No difference…

11

Export the ODBC registry entries from a machine that works (and is the same OS as the machine that doesn’t), and import them into the non-working machines registry.

STANDARD “MESSING WITH YOUR REGISTRY …” WARNING GOES HERE

12

image
image.jpg700×874 181 KB

I did these three areas in the past day.

It still does not work.

13

Looking through the files on the Vantage Server, I found the “docs folder”.
It had a file that finally told me how to install the software by running “netsetup”.
This ran just fine, and not the Print Preview works just fine.

Thanks for all the input !

Your interest in satisfying the internal needs  
of the staff here at Dynamic Tool Corporation
is greatly appreciated. The high quality of the
work completed here, requires the full co-
operation and dedication of all employees and
suppliers. Such dedication, yields a company 
strong in its abilities to satisfy the needs 
  of......
  the  U.S.A.  ....
  the  Earth ...
  the  Solar System ...
  the  Milky Way Galaxy ...
   and
  the Universe as a whole.
      ________________________