TCR10

1

Trams Crystal Report Viewer

for Crystal Reports Version 10

Requirements

Pentium Dual Core or better

Windows 2003 or 2008

Windows Vista

without requiring the Crystal Reports software. This viewer includes the Crystal Reports runtime engine. The viewer

itself is a program that reads Crystal Report files and allows the user to log on to the ODBC Datasource associated

with those reports.

WARNING: This program installs files necessary to run reports built with Business Objects Crystal Reports

version 10 or lower. Installing this program on computers that have Business Objects Crystal Reports 10

already installed may invalidate the Business Objects Crystal Reports 10 installation.

SPECIAL NOTE IF YOU ARE REINSTALLING A Trams PRODUCT: The safest way to reinstall a Trams product

is to download and reinstall the product from

http://static.trams.com/tramslibrary/Releaseandupdatefiles/fullsetup.html

C:\program files\Trams\TCR10\TCR.exe

In addition, the setup program installs the Crystal runtime files on your local drive. You can install the program anywhere on

your computer; however, the installation creates a shortcut in the Trams for Windows folder of your Start Menu and a

shortcut on the Desktop.

NOTE: Do not change the default installation location if you wish to run the Trams Crystal Reports Viewer through Trams

Back Office.

Before you run TCR10 for the first time

TCR10 connects to the Trams database using Open DataBase Connectivity (ODBC). This must be setup correctly or

TCR10 will not function and will not display any reports.

Step 1: Copy your database path

2

Step 2: Open the ODBC Data Source Administrator Panel

For computer with a 32-bit version of Windows, the ODBC control panel (Odbcad32.exe) is accessed by going to Start /

Control Panel, opening Administrative Tools, and then opening Data Sources (ODBC)

For computers with a 64-bit version of Windows: There are two ODBC control panels, one for 32-bit and one for 64-

bit. In order to access the 32-bit version of the Odbcad32.exe file where the InterBase ODBC drivers are installed,

you have to access it thru the following path:

%systemdrive% \ Windows \ SysWoW64 \ Odbcad32.exe. For most computers, the path will be

C:\Windows\SysWoW64\Odbcad32.exe

Step 4: Configure the Trams ODBC Data Source

Click on the System DSN tab.

If you have an entry called TRAMS ODBC Datasource, click on it, and then click on Configure. If it is not there, Click on

Add. Choose either the Embarcadero or DataDirect ODBC for Interbase and then click Finish. In either case you will be on

the configuration screen next.

Further steps follow after the screen snaps. (The first shows the driver setup for Embarcadero, the second two show the

DataDirect driver setup).

3

7 operating system and you are at the database server. If you are at a workstation, leave what was pasted as is.

(If configuring the DataDirect driver, click the Advanced tab at this time.)

4

Verify that Dialect is set to 1, not 3, and that TRAMS_USER is listed in the Role box for both.

Verify that the “Application Using Threads” box is unchecked if using the DataDirect driver.

Click on Test or Test Connect to verify the connection to the database.

DSN verification. Verify that there are NO TRAMS ODBC Datasource listings under the User DSN or the File DSN tabs.

Also, verify that there is not more than one called TRAMS ODBC Datasource on the System DSN Tab. If there is,

highlight and delete all but one and then configure it following the steps above.

Program Operation

Downloadable Reports. To open a report with the viewer, push the “Browse” button (located to the right of the Report

Name field) to browse for your report file. Select your report file and press Open. There is a short pause as the viewer

reads the report file. Once the file is open, the viewer fills-in Report Name field with the correct path to the report.

To run the report, supply the correct User Name/Password and press View Report.

5

You are now prompted for any parameters defined with the report. The viewer logs into Interbase and runs the report.

6

The Crystal Viewer is not part of the Trams Crystal Report Viewer. It is generated whenever a report is run using the

Crystal Runtime files. The features, format and information it presents are part of the Crystal Reports application.

Trams Products and Services have no control over any aspect of this screen. Here is a listing of the tool bar buttons and

their functions.

During the time that the query is running, the viewer may appear idle. Even though you don't see an hourglass, the query

is running and selecting records from your database. The animated logo of the viewer will be active as records are