Seagate Crystal Reports ReadMe

This ReadMe file includes a variety of topics regarding installation, upgrading, and other information that supplements the User's Guide.

  Click the topic of interest from the following list for further information:

What's New in 7 Index

Quick Start

Installation Topics Index

Configuration and Setup Topics Index

Seagate Software International Office Directory

Differences in parameter fields between 16 and 32-bit

Exporting to Excel 8 format

Converting date-time fields

Display problems at 256 colors

32-bit Native Informix Driver Notes

Native SQL Server driver Notes

Date Format issues in foreign language versions

Unsupported UFL's

Stored Procedures from previous versions

Group-By reports and saved data

Charting in 16-bit

Exporting maps in 16-bit

Borland Database Engine

OLAP Mapping has been disabled

Reporting on Metacube data

New Unicode types not supported

Informix database driver

Built-in SQL Expressions

Note to Developers: New API Calls

Note to Developers: Obsolete API Calls

Using DBGrid with the SQL Module

Missing Crystal Report Engine Class Library Structures

Working with secured Access databases

IntelliMouse

Btrieve Microkernel Setup

Online Help Distributed DLLs

Changes to the Crystal Report Automation Server (CPEAUT)

Exporting to HTML

Release Notes

The Crystal Report Designer Component

Crystal Query Issues

The Crystal Smart Viewer/Java Bean

Known Issues with Seagate Crystal Reports 7

Known Crystal Web Server Issues

Delphi 32-bit VCL's Help File

Visual FoxPro ODBC driver


Differences in parameter fields between 16 and 32-bit

The following parameter field functionality is not available in 16-bit Seagate Crystal Reports:

•	Edit masking

•	DateTime Picker

•	Min and Mix values for a particular type

Nevertheless, 32-bit reports do not conflict with 16-bit reports when you set these parameter fields.

  ReadMe Index


Exporting to Excel 8 format

You can now export your reports to Excel 8 format. However, you should note that Seagate Crystal Reports does not support exporting graphics and OLE objects to that format. You can export large amounts of data without graphics to Excel 8 format.

  ReadMe Index


Converting date-time fields

This version of Seagate Crystal Reports now supports date-time fields. There is no longer a need to convert date-time fields to string or date fields. Should you find it necessary, however, to convert date-time fields to string or date fields, proceed with caution. Unexpected results may occur.

  ReadMe Index


Display problems at 256 colors

It is recommended that you set your display to more than 256 colors before designing and viewing reports that contain cross-tabs, OLE objects, etc. This will prevent many minor display problems that might otherwise be inconvenient. For example, at 256 colors you may not always be able to see the gray, selected area of a cross-tab. Setting the display to more than 256 colors will quickly remedy this problem.

  ReadMe Index


32-bit Native Informix Driver Notes

In order to use the 32-bit Native Informix Driver (P2SIFMX.DLL), you will need to set up the ISQLT09A.DLL Informix support library. You can set up this library by installing the Informix 7.3 client on NT, or by installing the Informix IConnect 2.01.TC1 client for Windows 9.x.

  ReadMe Index


Native SQL Server driver Notes

The Native SQL Server driver does not support the new Unicode types nvarchar and nchar, which are in SQL Server 7. To support these types, you must use P2SODBC.DLL or P2SOLEDB.DLL. This will only work for 32-bit Seagate Crystal Reports, since the new Unicode types are only supported by ODBC 3.7 and greater. &&&

  ReadMe Index


Date Format issues in foreign language versions

Seagate Crystal Reports offers a calendar type option when formatting date fields. This option is only available if you are running an operating system that supports a calendar type other than Gregorian. For example, Crystal Reports running on a Japanese operating system may have the option of using a Japanese or Gregorian calendar. A report created on a Japanese operating system using a Japanese calendar type and opened on an English operating system will be formatted using the Gregorian (English) calendar. However, the original calendar type setting will be saved, thus if the report is opened again on the Japanese operating system it will have retained the original Japanese calendar type setting.

  ReadMe Index


Unsupported UFL's

The following UFL's and their related functions are not included and will not be supported in Seagate Crystal Reports 7:

•	U*5STORE

•	U*5TOTAL

  ReadMe Index


Stored Procedures from previous versions

In order to save the IsNullable information for a stored procedure from a report created in a previous version of Seagate Crystal Reports you must open the report and use the Verify Database command before saving the report again.

  ReadMe Index


Group-By reports and saved data

If you try to open a report that utilizes the Group-by feature in Seagate Crystal Reports and has saved data where there is no database dll present the data saved with the original report will be discarded.

  ReadMe Index


Charting in 16-bit

There is a limitation to charting in 16-bit environments that will allow a maximum of twenty values to be displayed.

  ReadMe Index


Exporting maps in 16-bit

Exporting a report with a map in 16-bit environments is unsupported and will cause the program  to crash.

  ReadMe Index


Borland Database Engine

The Borland Database Engine is no longer installed by default. Version 3 of the engine can be installed by doing a custom installation and enabling the Database Access\Borland Database Engine\BDE Engine Files option.

  ReadMe Index


OLAP Mapping has been disabled

Mapping on OLAP data is disabled and not available in Seagate Crystal Reports 7.

  ReadMe Index


Reporting on Metacube data

In order for the Metacube OLAP Report and Metacube Standard Report to work you must have Metacube version 4.02 installed.

	Metacube is not supported on Windows 95.
  ReadMe Index


New Unicode types not supported

Seagate Crystal Reports' native SQL Server driver will not be able to support the new Unicode types nvarchar and nchar included with SQL Server 7.

  ReadMe Index


Informix database driver

Currently Seagate Crystal Reports only ships a 32-bit native Informix database driver.

For Seagate Crystal Reports 6.0, the native Informix database driver (P2SIFMX.DLL) is directly dependent on the file ISQLT07C.DLL.  The Informix 7.2 & 7.3 client installs this DLL.  If you are using Informix 7.1 you must upgrade to the Informix 7.2 client or higher to be able to use the Native Informix 32-bit driver. Otherwise, you can use ODBC to connect to the database.

For Seagate Crystal Reports 7, the native Informix database driver (P2SIFMX.DLL) is directly dependent on the file ISQLT09A.DLL.  The Informix 7.3 client installs this DLL.

If you are using Informix 7.2 you must upgrade to the Informix 7.3 client or higher to be able to use the Native Informix 32-bit driver from Seagate Crystal Reports. This version of the native driver provides support for the Unix platform and Windows platforms.  It also supports new features that are included in Informix 7.3 (i.e. new functions and types).

If you cannot upgrade your version of the client then an older version of P2SIFMX.DLL can be downloaded from our ftp site at:

ftp://ftp.img.seagatesoftware.com/pub/crystal/general

The file to download is NATVIFMX.ZIP.  Once this file is unzipped, the native driver (P2SIFMX.DLL) needs to be placed in the \WINDOWS\CRYSTAL or WINNT\CRYSTAL directory.  Otherwise, you can connect to the database via ODBC.

  ReadMe Index


Built-in SQL Expressions

For more information regarding built-in SQL Expressions, please see the following reference material appropriate to your data source:

•	ODBC SQL Expressions: Refer to Microsoft ODBC SDK 3.0 for a complete and detailed list of all Scalar Functions.

•	Native SQL Expressions: Data source specific, please refer to individual database Server Online documentation (i.e. Informix Answers Online, SQL Server Books Online…)

  ReadMe Index


Note to Developers: New API Calls

New Calls

PEGetReportOptions	PESetReportOptions	PEGetNSQLExpressions
PEGetNthSQLExpression	PEGetSQLExpression	PESetSQLExpression
PECheckSQLExpression	PEGetNParameterDefaultValues	PEGetNthParameterDefaultValue
PESetNthParameterDefaultValue	PEAddParameterDefaultValue	PEDeleteNthParameterDefaultValue
PEGetParameterMinMaxValue	PESetParameterMinMaxValue	PEGetParameterValueInfo
PESetParameterValueInfo	PEGetNParameterCurrentValues	PEGetNthParameterCurrentValue
PEAddParameterCurrentValue	PEGetNParameterCurrentRanges	PEGetNthParameterCurrentRange
PEAddParameterCurrentRange	PEGetNthParameterType	PEClearParameterCurrentValuesAndRanges
PEVerifyDatabase	PESetFieldMappingType	PEGetFieldMappingType
PEGetSectionHeight	PESetSectionHeight	PEGetAllowPromptDialog
PESetAllowPromptDialog
New Structures

PEReportOptions	PEParameterValueInfo	PEMouseClickEventInfo
PEReportFieldMappingInfo	PEFieldMappingEventInfo
Modified Structures

PESubreportInfo	PEParameterFieldInfo	PEPrintOptions
PEEnableEventInfo


Note to Developers: Obsolete API Calls

The following calls are now obsolete.  They will still work for older applications, however there have been a number of major enhancements to Parameter Fields (e.g. default values, multiple values, value ranges, etc.)  For all new applications use the Replacement Calls.

Obsolete calls

These calls are obsolete and are no longer included in the header files:

Obsolete Call	Replacement Call
PEGetNthParamInfo	PEGetParameterValueInfo
PEGetNthParam	PEGetNthParameterField
PEGetNParams	PEGetNParameterFields
PESetNthParam	PESetNthParameterField
PEParameterInfo	PEParameterFieldInfo
PEGetMinimumSectionHeight
PESetMinimumSectionHeight
  ReadMe Index


Using DBGrid with the SQL Module

The Crystal SQL Designer included with Seagate Crystal Reports makes use of the DBGrid control from Apex software. For more information on the grid control, contact Apex Software at www.apexsc.com.

  ReadMe Index


Missing Crystal Report Engine Class Library Structures

Documentation for several new Crystal Report Engine Class Library Structure is missing from Developer's Help. For the list and complete documentation of these missing structures please see Missing CRPEP Structures.

  ReadMe Index


Working with secured Access databases

In order for Seagate Crystal Reports to work with secured Access databases, you have to point the program to the Access SYSTEM.MDA file or, if you're working with Access 95, to the SYSTEM.MDW file.

32-bit systems

When working with 32-bit systems, you need the following Registry setting:

Access

\\HKEY_LOCAL_MACHINE\Software\Seagate Software\Jet\3.0\Engines\Jet\SystemDB = < the path of SYSTEM.MDA >

Access 95

\\HKEY_LOCAL_MACHINE\Software\Seagate Software\Jet\3.0\Engines\Jet\SystemDB = < the path of SYSTEM.MDW >

16-bit systems

When working with 16-bit systems, you need the following entry in the CRW.INI file:

[Options]
SystemDB = < the path of SYSTEM.MDA >

Seagate Crystal Reports installs two utilities in the CRW directory that you can use to make these changes:

•	For upgrading the Registry (32-bit systems), use SYSDB32.EXE.

•	For upgrading the CRW.INI file (16-bit systems), use SYSDB16.EXE.

  ReadMe Index


IntelliMouse

•	By simply moving the wheel rotation up or down, you can scroll up and down the page as if you were using the scroll bars.

•	By pressing the Ctrl key and the wheel rotation on the IntelliMouse, you can zoom in and out on your reports.

•	By pressing the Shift key and the wheel rotation on the IntelliMouse while the cursor is over an area that allows drill down, the program will go to the drill down tab.

•	For more information on IntelliMouse cursors, search for Cursors in Seagate Crystal Reports online Help.

  ReadMe Index


Btrieve Microkernel Setup

During installation of Seagate Crystal Reports, Btrieve Microkernel components and related files are installed to a separate directory \CRW\BTI (16-bit) or \CRW\BTI32 (32-bit). In order to setup the Btrieve Microkernel, run the setup (DBSETUP.EXE) program from the appropriate directory. After the setup program has run once, you will be able to access DBSETUP.EXE from the File/Program manager.

  ReadMe Index


Online Help Distributed DLLs

The following files have been distributed with this online Help system in order to run the Internet access functions and set the Internet browser or navigator to be used.

File	Description
SETBROWS.EXE	Executable that allows users to specify the browse path for an Internet browser or navigator.
INETWH16.DLL	Registered by INETWIZX.EXE, adds the functionality for adding Internet access to 16-bit Help systems.
INETWH32.DLL	Registered by INETWIZX.EXE, adds the functionality for adding Internet access to 32-bit Help systems.
  ReadMe Index


Changes to the Crystal Report Automation Server (CPEAUT)

The Crystal Report Automation Server has had some last-minute changes. The changes were made to make the Crystal Report Automation Server synchronized with the Crystal Report Engine. The changes are as follows:

•	The read-only property, GroupName, has been added to the PageGenerator. This is required by the Crystal Report Automation Server to communicate properly with the Crystal Report Engine. It allows drill down on graphs to bring up the drill down tab (with its title) while processing of the drill down is still occurring.

•	MatchLogOnInfo has been added as a write-only property to the GlobalOptions. It has been added to control security of multiple users.

•	DLLName has been deleted from the DatabaseTable.SetLogOnInfo method.

•	There is an optional parameter added to Application.OpenReport, call OpenMethod of typed CROpenReportMethod.  This corresponds to PEOpenPrintJobWithInfo.

•	crNavy has been added to CRColor for the 32-bit Application.

  ReadMe Index


Exporting to HTML

Providing support for the Internet and corporate intranets becomes more important with every passing day. Seagate Crystal Reports recognizes this importance and provides World Wide Web support. Although incorporated as an export format, HTML represents a whole new export destination for your reports as well.

By exporting your reports in HTML format, Seagate Crystal Reports provides you with a new option for rapid, convenient distribution of important company data. Once exported, your reports are accessible with many of the most popular web browsers including Netscape and Microsoft Internet Explorer.

1	With the report you want to export active, click the Export button on the standard toolbar. The Export dialog box appears.

2	From the Format drop-down box, select one of the HTML formats listed.

•	If Netscape 2.x (or earlier) or Internet Explorer 1.x is your browser, select HTML 3.2 (Standard) format.

•	If you are using Internet Explorer 2.0 (or later) or Netscape 3.0 (or later) choose HTML 3.2 (Extended) format. This format will create output containing bgcolor HTML tags approximating section background color and object adornments in the report. Choose this option if you are uncertain.

•	The World Wide Web Standards Organization has replaced its HTML 3.0 (Draft) specification with its HTML 3.2 (Standard). However, if you require this form of output, choose the HTML 3.0 (Draft) format.

3	Select a destination from the Destination drop-down box such as a disk file, an e-mail address, Microsoft Exchange, or Lotus Notes. The rest of this section assumes you select Disk file to store the HTML document in a directory on a web server.

4	Click OK. The Export To Directory dialog box appears. When exported to HTML format, a report may make more than one HTML file. For this reason, the program asks you for the name of a directory to export the report to, and uses default names for the HTML files. The initial HTML page will be saved as DEFAULT.HTM. This is the file you open if you want to view your report through your web browser.

5	Select an existing directory, or create a new directory for the report.

6	Click OK. The program exports the report to HTML format.

  ReadMe Index


Release Notes

DEVELOPR.HLP (32-bit)

The following information is incorrect.

"Subreports cannot be modified at runtime through the ActiveX control but they can be modified using direct calls to the Report Engine API.  If you want to modify subreports at runtime, you will not be able to use the ActiveX control with your application; you will have to create a Custom Print Link using the Report Engine API."

Correction:  Subreports CAN BE modified at runtime through the ActiveX control for Crystal Reports version 6.0.

Where is this information documented?

1	Click on the developer.hlp file or Seagate Crystal Reports Developer's Help option from the program group.

2	From the Contents tab, click on Crystal ActiveX Control option.

3	Click on the ActiveX Control Properties Index option.

4	Click on the  <<  button on the toolbar.

DEVELOPR.HLP (32-bit)

The developer.hlp implies properties available for the VBX in 32bit, which is incorrect. There aren't any properties for the VBX for 32bit platforms.

Where is this information documented?

The First location of this information is:

1	Click on the developer.hlp file or Seagate Crystal Reports Developer's Help option from the program group.

2	From the Contents tab, click on the Crystal Custom Control option.

The Section Code(32-bit) option should not exist, as the VBX is not available in 32bit.

The second location of this information is:

1	Click on the developer.hlp file or Seagate Crystal Reports Developer's Help option from the program group.

2	From the Contents tab, click on the Crystal Custom Control option.

3	Click on the Overview options.

The Section Code(32-bit) option should not exist, as the VBX is not available in 32bit.

FYI:

•	Error messages prompting for missing files in 32bit Crystal Reports prompt for the 16bit filename instead of the 32bit filenames.

•	If you are distributing reports which use MSVCRT40.DLL (for example, 32-bit distribution for Access 7/8 using DAO 3.5) you will need to be manually included in the Distribution Expert for the client machine if the client machine does not have VB5 or Access 7/8 on their machines. The version of the MSVCRT40.DLL determines whether the MSVCRIT.DLL is required or not (for example, version 4.20.6172 requires that DLL).

DEVELOPR.HLP (32-bit)

The following information in the developer.hlp file is INCORRECT.

"If your Rowset contains only a single field, you can use a one dimensional array instead of two dimensional. The single dimension indicates the number of rows or records in your Rowset."

Correction: If you wish to add to your Rowset one record at a time, you can use a one dimensional array instead of a two dimensional array.  The single dimension would represent the number of fields to be added to the Rowset.

FYI:

•	Using the Crystal Data Object, the row is added twice. This occurs only on a single dimensional array.

•	Please watch the Seagate Software web page: www.seagatesoftware.com, for any updates to this issue.

•	When using the WindowState property in the VCL with Delphi 3, the "wsminimized" and "wsnormal" both produce a normal window.

•	When using "PeOutputToWindow"  With Delphi 3, the "WS_Minimized" and "WS_Normal" (See note below) are both "Normal".

	There is no "WS_NORMAL" in the help and it won't accept it in the call, you simply use "0" instead which is the same as "Normal."
•	In Crystal Reports 32bit, there are no PG Editor templates installed in the GALLERY directory.

For more information on the latest release notes, please visit the Tech Support area on our website at http://www. seagatesoftware.com/crystalreports/techsupp/

Please contact Tech Support at 604-669-8379 for further information.

  ReadMe Index


The Crystal Report Designer Component

Report Design Component (Object Model)

•	The CRAXDRT Object Model does not read Parameters from a Stored Procedure.

•	In VB5, the Section Format event does not get fired when a report variable is declared as Dim Report As CRAXDRT.Report.

•	Many object model properties are returning wrong (different) values.  There are many properties in the RDC's object model that are returning a value of '-1' as TRUE, instead of 1.

•	The ProgID for the Crystal Report Designer Component is CrystalRuntime.Application.7. This is the ID that must be used to create and instance of the Application Object using the CreateObject function.

Report Design Component (Designer)

•	When connecting to Btrieve using the native driver, the tables are present but fields do not appear.

•	When a report is imported but the database drivers are missing, a database error is given every time the user goes to or returns from run mode.

•	When a report is designed from an Access database with Access security turned on, the session remains open into runtime.

•	The Report Design Component does not support Crystal Dictionaries and Queries as data sources.

•	Currently it is only possible to add Data Environment commands in the expert; it is not possible to add Data Environment commands through the designer.

Report Design Component (Viewer)

•	When the toolbar buttons get set to false, Display Toolbar gets set to false.  When the buttons get set to true they do not display.

•	When an error message is produced the viewer seems to stop Form Activate and Deactivate events from firing.

  ReadMe Index


Crystal Query Issues

•	Crystal Query does not support OLAP or cross-tab reports in this version of Seagate Crystal Reports. You will not be able to use cross-tabs or OLAP grids in Crystal Query.

•	Crystal Query server requires the Microsoft Java Virtual Machine. This component is available in Microsoft Internet Explorer 4.01 and the Java SDK.

•	Crystal Query client display is optimal on screen resolutions of 1024x768. If you are using 640x480 the query client may not show all sections by default, especially when loaded in a browser. To increase what is shown you can hide sections or increase the resolution on your machine.

  ReadMe Index


The Crystal Smart Viewer/Java Bean

•	The Crystal Smart Viewer/JavaBean has problems being instantiated via the Beans.Instantiate method.  It is recommended that you use the New operator:

com.seagatesoftware.img.ReportViewerBean myBean = new ReportViewerBean ().

•	If you are using Microsoft Internet Explorer 4.0 or 4.01 you must have the latest JVM from Microsoft installed in order to use the Crystal Smart Viewer/JavaBean.

•	The JavaViewerBean will not instantiate properly when using the ClassLoader, for example:

ClassLoader cl = Class.forName("com.seagatesoftware.img.ReportViewer.ReportViewerBean").getClassLoader();

ReportViewerBean bean = (com.seagatesoftware.img.ReportViewer.ReportViewerBean)instantiate( cl, "com.seagatesoftware.img.ReportViewer.ReportViewerBean");

Instead use:

ReportViewerBean bean = new ReportViewerBean();

•	When using the JavaViewerBean with IE4, the JVM must be version 3.01 or later.

  ReadMe Index


Known Issues with Seagate Crystal Reports 7

•	Cross-Tabs cannot exceed 65,534 rows.

•	Use Indexes for Speed must be off if you are linking tables on date or date/time fields.

•	If the Zoom Control is at 100% the preview window will show blank for cross-tabs that are greater than 42 pages wide.  View at 75% to see data.

•	OLE objects can appear smaller when exported to Rich Text Format (RTF).

•	Setting "Keep Group Together" on in a multi-column report will not keep groups within columns - it only affects reports by keeping groups on the same page (when possible).

•	Group Tree will generate "blank" if it is enabled for a report with no groups.

•	Scatter Graphs do not support "labels" (the on change of value) beside each "dot", but do support showing the X, Y coordinates beside each "dot".

•	Background patterns and double lines are not supported for box objects.

•	Unable to drill down on a detail graph.

•	Conditional Page Footers 'take up space' on the report page when previewing or printing.

•	Curve Fit and Stat lines on graphs take on the colour of the series they are representing.  They cannot be customized.

•	The File | Report Options and File | Options | Reporting option to Convert Date-Time Field to Date-Time only works through ODBC, not through the native drivers.

•	Text Objects are rasterized to the printer based on font metrics from the driver and screen resolution, while all other report fields (font related) are rasterized to the printer based only on font metrics.  This will result in text objects displaying slightly different than other font related fields on a report (this was the same in version 6.0).

•	Subreports do not export to Character-Separated, Data Interchange, or Comma-Separated formats.

•	Background colouring of sections is not supported in any exported format.

•	When exported, "Underlay Following Sections" is only supported in: RTF, Word, Text, Paginated Text, HTML, Excel, Character-Separated, Crystal Reports and Comma-Separated formats.

•	Exporting to Word, Excel, HTML and Text treat the report as a large, single-page document.

•	Exporting to Excel 5 or earlier is limited to 16,384 rows.

•	You cannot graph on WhilePrintingRecord formulas.

•	You cannot graph on Running Totals.

•	Exporting a report with a map in 16-bit environments is unsupported and will cause the program  to crash.

•	There is a limitation to charting in 16-bit environments that will allow a maximum of twenty values to be displayed.

•	If you try to open a report that utilizes the Group-by feature in Seagate Crystal Reports and has saved data where there is no database dll present the data saved with the original report will be discarded.

  ReadMe Index


Known Crystal Web Server Issues

•	HTML search begins searching on the next page (the page following the one you begin the search on) and it is a forward search.

•	Firewalls might prevent the ActiveX and Java viewers from being downloaded to the local browser.

•	Searching from HTML interface (includes HTML frame and page) is only a forward search beginning on the next page.

•	You should always go through the Web Configuration Utility (WEBCONF.EXE) to change setting of the ReportServer.

•	A bug with Microsoft's Internet Explorer 3.02 prevents Java applets from loading properly when the system is set to True Color (Windows platforms only).

•	Some web servers do not support spaces in directories (e.g. Oracle Application Server 4.0 and Lotus Domino). In those cases you will have to specify the physical directory using the DOS naming convention. For example:

—	/viewer: C:\Progra~1\Seagat~1\Viewers\

—	/scrreports: C:\Progra~1\Seagat~1\reports\

—	/scrsamples: C:\Progra~1\Seagat~1\Crysta~1\sample

  ReadMe Index


Delphi 32-bit VCL's Help File

The Delphi 32-bit VCL help file is not fully completed. The VCL Help file included with Seagate Crystal Reports is partially finished. There is a notice on the title page of the Help file indicating this.  The completed Help file will be available for download on the web site in a few  weeks. It will be called 7VCLHelp.exe.

  ReadMe Index


Visual FoxPro ODBC driver

There is an option in the Setup for a Visual FoxPro ODBC datasource which is called "Fetch Data in Background".  This is checked on by default, and should be turned off in order for the datasource to work properly with SCR. "Fetch Data in Background" is a multi-threading feature, which does not work properly with SCR.  If this option is left on, a Report can give different data every time it is refreshed.

  ReadMe Index


Installation Topics Index

  Click the topic of interest from the following list for further information:

Installation Requirements (16-bit version)

Installation Requirements (32-bit version)

Installing Seagate Crystal Reports

Installing on a network workstation

Upgrading from a previous version


Installation Requirements (16-bit version)

The 16-bit version of the program has the following installation requirements:

•	Microsoft Windows 3.1 or higher

•	Minimum RAM: 16 MB (32 MB for Windows NT 3.51 or higher)

•	Minimum hard drive space required: 10 MB

•	Maximum hard drive space required:

—	75 MB for the Standard Edition

—	108 MB for the Professional Edition

  Installation Requirements (32-bit version)

  Installing Seagate Crystal Reports

  Installing on a network workstation


Installation Requirements (32-bit version)
Installation Requirements - 32-bit version

The 32-bit version of the program has the following installation requirements:

•	Microsoft Windows 95, Windows 98 or Microsoft Windows NT 3.51 or higher

•	Minimum RAM: 16 MB (32 MB for Windows NT)

•	Recommended RAM: 32 MB

•	Minimum hard drive space required: 24 MB

•	Maximum hard drive space required:

—	90 MB for the Standard Edition

—	148 MB for the Professional Edition

If your system does not meet these requirements, the program may not run correctly.

  Installation Requirements (16-bit version)

  Installing Seagate Crystal Reports

  Installing on a network workstation


Installing Seagate Crystal Reports

Insert the CD or diskette into the appropriate disk drive.

Windows 3.1 or NT 3.51

1	Choose the Run command from the File Menu.

2	When the Run dialog box appears, type:

x:\setup

«x represents the appropriate drive letter.»

For example, if the CD is in drive D:, type:

D:\setup

3	Click OK or press Enter to activate the installation program. The Installation dialog box appears.

4	Follow the directions on the screen to set up the program.

During the installation procedure, you can choose a Typical or Custom installation.

•	If you select Typical, the program will be installed with the most common options.

•	If you select Custom, you will be given the opportunity to select which program files are installed to the hard drive.

Windows 95, Windows 98or NT 4.0

1	Choose Run from the Start Menu.

2	When the Run dialog box appears, type:

x:\setup

«x represents the appropriate drive letter.»

For example, if the CD is in drive D:, type:

D:\setup

3	Click OK or press Enter to activate the installation program. The Installation dialog box appears.

4	Follow the directions on the screen to set up the program.

During the installation procedure, you can choose a Typical or Custom installation.

•	If you select Typical, the program will be installed with the most common options.

•	If you select Custom, you will be given the opportunity to select which program files are installed on your hard drive.

  Installation Requirements (16-bit version)

  Installation Requirements (32-bit version)

  Installing on a network workstation


Installing on a network workstation

To run Seagate Crystal Reports from a server you will need to install it to the server and then run a workstation setup application on each workstation that will run Seagate Crystal Reports.

The workstation setup application is installed in the \CRW16\CLIENT16 (16-bit) or \Program Files\Seagate Software\Crystal Reports\Client32 (32-bit) directory on the network drive.

To install on the server:

1	Choose a Custom install.

2	When the Custom Installation Options dialog box appears, verify that the Workstation Setup option is checked.

To set up a workstation:

1	From the Program Manager, choose Run from the File Menu (Windows 3.x or NT 3.51), or choose Run from the Start Menu (Windows 95 and 98 or NT 4.0). The Run dialog box appears.

2	In the Run dialog box, highlight the network drive and directory in which the Workstation Setup resides and run the SETUP.EXE application.

3	Follow the directions on the screen to set up your workstation.

  Installation Requirements (16-bit version)

  Installation Requirements (32-bit version)


Upgrading from a previous version

If you are upgrading from a previous version, the installation routine ensures that there will be no conflict between different versions of the program running on the same machine. When the setup application finds a previous version of the program on a system, it:

•	installs the program to the specified directory,

•	installs the new CRPE.DLL into the \WINDOWS\SYSTEM directory,

•	renames DLLs installed by the previous version in the WINDOWS\CRYSTAL directory, with *.OLD extensions (if, for some reason, you need to use the older versions of the files later on, you only need to rename them back to a *.DLL extension),

•	installs the PD*.DLLs and UX*.DLLs (16-bit) or the P2*.DLLs and U2*.DLLs (32-bit), and several other DLL files required by the program into the WINDOWS\CRYSTAL and WINDOWS\SYSTEM directory and changes their extensions from *.DLL to *.OLD, and

•	installs any common third party DLLs such as CTL3DV2.DLL or WBTRCALL.DLL to the WINDOWS\SYSTEM directory.

  Installation Requirements (16-bit version)

  Installation Requirements (32-bit version)

  Installing Seagate Crystal Reports


Configuration and Setup Topics Index

  Click the topic of interest from the following list for further information:

Btrieve page size too small

Configuring the Query Server

  Seagate Crystal Reports ReadMe


Btrieve page size too small

During installation, Seagate Crystal Reports adds the following entry in BTI.INI:

[Btrieve Client]
options=/m:38 /p:1024 /f:16 /l:20

The p is the parameter for page size, and, in certain situations, it may not be large enough.  You can change this setting to a maximum of 4096.

To correct the problem

When using Btrieve files, if you get a message that the page size is not large enough, increase this parameter in the BTI.INI file using the Windows Notepad or another ASCII text editor.

For additional information on modifying BTI.INI files, please refer to the documentation that came with Btrieve.

  Configuration, and Setup Topics Index


Configuring the Query Server

	The Query Server requires and operating system with DCOM support and Microsoft Java Virtual Machine. This component is available in Microsoft Internet Explorer 4.01 and the Java SDK.

You will need to configure the Query Server, particularly the Query client auto-setup.  Please see #5 below for information regarding how to configure the auto-setup and the rest of this document for general configuration issues.

1	Choose the Options command from the File menu. The Query Server Options dialog box appears.

2	In the User connection timeout check box, enter the number of minutes you want the server to wait before timing out on an operation.

3	Toggle the In-proc Server check box on if you want the Query Server to use one process for all its operations. The server will use multiple threads. If this check box is toggled off, the server will use multiple processes, with each process using a single thread.

4	Toggle the Asynchronous SQL check box on if you want the SQL that is passed to the database server to be asynchronous. If the SQL is asynchronous, you will be able to interrupt a request for data from the server, if needed. This is the recommended setting. If this check box is toggled off, the SQL will be synchronous, and you will not be able to cancel a request to the server.

5	There are two Auto Setup Program Location sections, and each has two text boxes. You can use these text boxes to specify the file paths to the query client install .exe files on the server machine. When you log on to the Query Server, and you don't have Crystal Query installed, your machine will get the install file path that you specify here from the server, and will run the executable files to install Crystal Query. The default file paths appear in these text boxes automatically, but you will still need to replace the <sharename> in each file path with the name of a valid share on the server machine. Then check the rest of the file path to make certain it is correct.

—	The Auto-Setup Program Location (Query Client Only) section allows you to specify the file paths for installing only Crystal Query.

—	The Auto-Setup Program Location (Query Client and Swing) section allows you to specify the file paths for installing both Crystal Query and the Swing.exe file, which installs the accompanying Swing classes.

6	Click the Default Client Options to set the options for the Crystal Query Tool. The Default Client Options dialog box appears.

7	In the Max DB Records text box, set the maximum number of records that you want the query to read from the database. You can also set this option within Crystal Query.

8	In the Browse Records text box, enter the number of values that should appear when you browse a field in Crystal Query. You can also set this option within Crystal Query. for more details.

9	In the Rowset Batch text box, enter the number of records you want returned in one batch from the server. You can also set this option within Crystal Query.

10	Toggle the Auto Refresh check box on to enable Crystal Query's Auto Refresh feature. This feature will automatically refresh the data in the result set whenever you modify the result set. If this check box is toggled off, Crystal Query will only refresh the data when you choose the Refresh command from the View menu of Crystal Query. You can also set this option within Crystal Query

11	Toggle the Server Side Grouping check box on if you want Crystal Query to perform the grouping on the server. Performing the grouping on the server saves time and memory.

12	Toggle the Save Data with Document check box on if you want to save the data with your ad hoc reports. When you save the data with a report, and you later open that report, the report will open with the data. If you toggle this check box off and you do not save the data with your report, you will need to refresh to get new data from the database the next time you open the report.

13	Use the Report Style drop-down list to select a report format style for your report.

14	Toggle the Allow editing links check box on if you want to be able to edit the links you establish between database tables. If this check box is toggled off, you will not be able to edit the links. You can link tables in the Table section of the Query Tab.

15	You can toggle the following check boxes on to show the corresponding elements of the Crystal Query Tool. If any of the check boxes are toggled off, the corresponding elements will be hidden. You can also set these options within Crystal Query, using the Query Tab toolbar or theView menu.

—	Toggle the Show link panel check box on or off to show or hide the Table section of the Query Tab.

—	Toggle the Show rowset panel check box on or off to show or hide the result set.

—	Toggle the Show long field name check box on or off to show (or not show) the full field names for fields in the Query Tab.

—	Toggle the Show Query Explorer check box on or off to show or hide the Query Explorer.

—	Toggle the Group content view check box on or off to show or hide the group content view on the Query Tab.

16	You can toggle the Need verifying logon check box on to specify that Crystal Query will require a user to enter logon parameters for logging on to the server.

17	Click OK. The program returns you to the Query Server Options dialog box.

18	Now click the Local Manager Options button to specify the file paths for the local directories. When you click this button, the Local Directory Manager Options dialog box appears.

19	Use the Root Directory for Connection Objects text box to specify the file path where Crystal Query will find the connection objects.

20	Use the Root Directory for Documents text box to specify the file path where the Crystal Query will find the report templates.

21	Click OK. The program returns you to the Query Server Options dialog box.

22	Click OK. You will need to restart the Query Server before the new options can take effect.

How to set the help file location

On the Crystal Query Server Options screen there is an option called Help File Location.  This specifies the URL to the query help files. If you have a webserver on the query server machine this will default to:

http://machine/ssquery/docs/

Otherwise it will be a URL to

http://www.seagatesoftware.com/prod-bi-techsupp/Query_Help/default.htm

This is Seagate Software's Query Help website. Any updates to the help files can be downloaded from this location.


Quick Start

If you are an experienced Windows user who wants to get right into the program, follow these steps to set up a report for the first time.

1	In Windows 3.1 and NT 3.51, start the program by double-clicking the Seagate Crystal Reports icon in the Program Manager.

•	In Windows 95, Windows 98 and NT 4.0, click Start, then select Seagate Crystal Reports from the Seagate Crystal Reports program folder.

2	Click the New button on the Standard toolbar. The Report Gallery appears.

3	To build the report:

•	select one of the eight Experts,

•	click Another Report to use a template, or

•	click Custom to build a custom report. If you click Custom, the Report Gallery expands, and you can then select a Report Type and Data Type for a custom report.

4	If you choose Custom and select:

•	Data File, the Choose Database File dialog box appears. Select the first database you want to activate for the report.

•	SQL/ODBC, the Log On Server dialog box appears. Highlight the data source you want, click OK, and when the Choose SQL Table dialog box appears, highlight the first table you want to use.

•	Dictionary, the File Open dialog box appears. Highlight the  you want to use for the report.

The Design Tab appears with Report Header, Page Header, Details, Page Footer, and Report Footer areas. A report is created by inserting and formatting items in each of these areas.

	To use additional database tables for your report and match them up on a record-by-record basis, click the Link Expert button on the supplementary toolbar and then select the table(s) and set up the links in the Visual Linking Expert when it appears.
5	Each of the default report areas contains a single section. To add additional sections, click the Section Expert button on the Standard toolbar and use the Section Expert to add the desired sections.

Once you have added sections to an area, you can move, merge, and delete them in the Section Expert.

6	To toggle the grid on and off, choose the Options command on the File Menu and make your changes in the Options dialog box when it appears.

7	If you are working with the grid off and you want to use snap-to guidelines for positioning objects, click the top or left ruler wherever you want guidelines to appear.

•	Drag a field to a guideline until it snaps to the guideline.

•	Drag the guideline arrow to move the guideline (and any objects that are snapped to it).

•	Drag the guideline arrow away from the ruler to remove the guideline.

8	If the Insert Fields dialog box is not visible, click the Insert Fields button on the Standard toolbar. The Insert Fields dialog box appears with the Database Tab active, and displays a list of the fields in the active database table(s). To speed the entry of multiple fields, the box remains on-screen until you click Close. This dialog box can be moved to a new location or resized, if you wish.

9	Select the field(s) you want to appear on the report. You can select and place them one at a time, or you can use the Shift-click combination to select a number of contiguous fields, or the Ctrl-click combination to select fields from the list at random. Drag and drop is also active. Place the fields in the Details section where you want them to appear.

10	When you place multiple fields, they will appear in the same order that they appear in the Insert Fields dialog box. The program marks the position of each field with a rectangular frame. The characters in the frame indicate whether the field is text (xxx...), number (555...), currency ($555...), date (12/31/99), time (00:00:00), dateTime (12/31/99 00:00:00), or Boolean (T/F).

	You can see the actual field names and field types by toggling the Show Field Names check box on in the Options dialog box (Layout Tab).
	The program automatically places field titles in the Page Header section unless you have toggled the Insert Detail Field Titles check box off in the Options dialog box (Layout Tab).
	If additional Details sections are added to your report, please note that field titles will only be placed in the Page Header section for fields in the Details A (the original) section of your report.
11	Once the objects are in place, you may want to adjust the report sections somewhat. To do this, right-click the shaded area to the left of the section ruler and use the shortcut menu that appears.

•	To expand a section to accommodate an additional line, choose the Insert Line command.

•	To have the program automatically align the objects in the section horizontally, choose the Arrange Lines command.

•	To reduce the size of a section to eliminate unnecessary white space above and below objects, choose the Fit Section command.

12	To create a report title, you must first enter the title in the Document Properties dialog box. Choose the Summary Info command from the File Menu. Enter a title in the Title text box of the Document Properties dialog box. Click OK.

13	Choose the Report Title command from the Insert|Special Fields Menu. A rectangular placement frame appears when you move the cursor over your report. Click once in the Report Header (RH) section to place the report title. The report title field contains the text that you typed in the Title text box of the Document Properties dialog box.

14	To see how the results will print, click the Print Preview button on the Standard toolbar.

To speed processing time while building a report, you can preview the report using only a small subset of the available data. To do this, choose the Preview Sample command from the File|Print Menu.

In either case, the program takes you to the Preview Tab. You can fine-tune a report in the Preview Tab while viewing the results as actual report data. You can also close the Preview Tab and continue working on the report in the Design Tab.

15	If you want to:

•	format a field,

•	change the placement or width of a field, or

•	insert a subtotal or grand total,click the field to select it. Handles appear on the top, bottom, and sides of each selected field.

	To apply formatting only under certain conditions, click Conditional Formula next to the formatting property in the Format Editor, and create a formula that defines those conditions.
	Many of the font and formatting options are available on the formatting toolbar.
16	To create a formula that makes data calculations or comparisons, click the Insert Fields button on the Standard toolbar. When the Insert Fields dialog box appears, click the Formula Tab to activate it.

17	Click New. The Formula Name dialog box appears. Enter a name for the formula and click OK. The Formula Editor appears.

18	Enter the formula in the Formula Editor. Enter fields, operators, and functions by selecting them from their respective scroll lists or by typing them in. You can check the formula syntax by clicking Check.

19	When you are finished editing, click Close to return to the Insert Fields dialog box. Click Insert to place the formula just like you would a database field.

20	To insert a subreport (a report within a report), click the Insert Subreport button on the Supplementary toolbar and choose an existing report to import as a subreport or use the Create Report Expert to create a new subreport.

•	If you want the records in a subreport to match up with the records in a primary report, click the Link Tab of the Insert Subreport dialog box and specify the link in the Subreport Links dialog box when it appears.

21	To insert a cross-tab object in a report, click the Insert Cross-Tab button on the Supplementary toolbar and set up the cross-tab in the Cross-Tab dialog box when it appears.

22	To create a parameter field (a field that prompts you for a value whenever you retrieve data for a report), click the Insert Fields button on the Standard toolbar, then click the Parameter Tab in the Insert Fields dialog box when it appears. Click New to set up a parameter field. Once created, you can insert the parameter field in a report like a database field or select it from the Fields list in the Formula Editor.

Parameter fields can be used in reports (as title or label prompts), in selection formulas (as selection criteria prompts), and in formulas (for a variety of purposes including specifying sort fields).

23	To add a chart, click the Insert Chart button on the Standard toolbar.

24	To insert a spreadsheet, picture, or other OLE object that you can edit from within Seagate Crystal Reports using the tools from the object's native application, choose the Object command from the Insert menu.

25	To change the record sort order, click the Sort Order button on the Standard toolbar. The Record Sort Order dialog box appears. Select the field(s) you want to use for sorting the report data and the sort direction.

To limit the report to specific records (for example, the records of California customers who have year-to-date sales greater than $10,000), click the first field on which you want your selection to be based and then click the Select Records button on the Standard toolbar. When the Select Expert appears, set up the record selection criteria.

26	To print the report, click the Print button on the Standard toolbar.

That's it! It is that easy to build a report.


What's New in 7 Index

  Click the topic of interest from the following list for further information:

Current Product Info

New Crystal Query provides greater power and speed

Report Designer Component

Map Expert helps identify trends

Enhanced charting capabilities help you analyze data

Enhanced cross-tab features make cross-tab reports more powerful than ever

Server-side processing saves time and memory

Running totals - one field is all you need

Document Import Tool converts old text reports

Entering SQL expressions directly helps you create reports faster

Highlighting Expert makes formatting faster and easier

Field Mapping provides more database control

Enhanced Formula Editor makes creating formulas easy

Enhanced exporting capabilities

New and better parameter fields provide greater flexibility

On-Demand subreports increase report organization

Internet Resources for Seagate Crystal Reports Technical Support


Current Product Info

For the latest samples, files, updates, and technical documents on Seagate Crystal Reports 7, please visit:

http://www.seagatesoftware.com/crystalreports/techsupp

  What's New in 7 Index


New Crystal Query provides greater power and speed

With an easy-to-use interface and web-enabled design capabilities, Seagate Crystal Reports new Crystal Query  allows you to quickly design and preview ad hoc reports. The Query Designer gives you the basic formatting and charting capabilities of Seagate Crystal Reports, but does not burden you with the more advanced features. Plus, the tool uses page-on-demand technology. Now you can create ad hoc reports quickly and easily, letting the program do most of the work for you. The Crystal Query Designer is a 100% Java client.

  What's New in 7 Index


Report Designer Component

Seagate Crystal Reports now includes the Report Designer Component, a powerful ActiveX designer for Visual Basic. The Report Designer Component allows you to design reports using all of the advanced reporting features of Seagate Crystal Reports all within the Visual Basic development environment. The Report Designer Component also provides a complete object model, allowing you to design custom interfaces for user input that controls report data.

  What's New in 7 Index


Map Expert helps identify trends

This version of Seagate Crystal Reports provides a new Map Expert that allows you to insert geographic maps into your reports. A map is a powerful analysis tool. You can map on summary fields, subtotal fields, and cross-tab summaries, then drill down on the map to view organized sets of data (such as sales by state). Seagate Crystal Reports provides four map layouts and five map types. The program also offers a new view called the Analyzer Tab, which allows you to set the properties for an individual instance of a map, independently of the rest of the report. This new mapping feature makes it easier than ever to identify trends in data.

  What's New in 7 Index


Enhanced charting capabilities help you analyze data

The Chart Expert is now much more powerful, providing maximum charting flexibility by offering 11 chart types and 47 chart templates (as well as, an editor for creating custom charts). Now you can create Bubble charts, Radar charts, and XYZ Scatter charts, among others. The program also offers a new view called the Analyzer Tab, which allows you to set the properties for an individual instance of a chart, independently of the rest of the report. This new charting feature makes it easier than ever to organize and analyze data.

  What's New in 7 Index


Enhanced cross-tab features make cross-tab reports more powerful than ever

Many advanced options have been added to cross-tabs in this version. With these advanced options, you can:

•	Suppress empty rows and columns,

•	Suppress subtotals and grand totals,

•	Split wide cross-tabs over page breaks and repeat the row labels,

•	Specify separate background colors for row and column grand totals,

•	Conditionally format the contents of individual cross-tab cells, and

•	Specify order grouping for rows and columns.

  What's New in 7 Index


Server-side processing saves time and memory

You can now choose to have the program perform its grouping on the server. In this event, Seagate Crystal Reports pushes as much of the report processing as possible to the server. The benefits of this functionality include:

•	less time connected to the server,

•	less memory needed to process the report on your computer, and

•	lower transfer time from the server to the client.

In short, server-side processing is the newest feature in quick, expedient reporting.

  What's New in 7 Index


Running totals - one field is all you need

You no longer need to bother with cumbersome running total formulas: Seagate Crystal Reports offers an easy-to-use dialog box for creating running totals quickly. The program will take care of all the formulas, all you need to do is tell it which field to total, when to total it, and when to reset. Then simply place the running total on the report and you're set to go.

  What's New in 7 Index


Document Import Tool converts old text reports

Have you ever wished you could use Seagate Crystal Reports formatting and grouping abilities in old text reports? Well, now you can. With the Document Import Tool, Seagate Crystal Reports offers a powerful new reporting functionality. By simply highlighting the various sections of a report and then compiling, you can easily convert a plain ASCII text report to  Seagate Crystal Reports.

With this new tool, you can:

•	convert old ASCII text reports into Seagate Crystal Reports,

•	map the report fields to the original database, and then

•	generate the report whenever you want, from within Seagate Crystal Reports.

Now you can use Seagate Crystal Reports for all your reporting needs.

  What's New in 7 Index


Entering SQL expressions directly helps you create reports faster

SQL expressions are a means of querying databases for specific data. These requests are written in Structured Query Language (SQL). Seagate Crystal Reports lets you enter SQL expressions directly from the Insert Fields dialog box. From there, the program provides an editor much like the Formula Editor, allowing you to create new SQL expressions quickly and easily. Then you can insert the SQL expressions into a report just like database fields.

  What's New in 7 Index


Highlighting Expert makes formatting faster and easier

With the Highlighting Expert, Seagate Crystal Reports offers powerful highlighting functionality that allows you to quickly apply conditional formatting to currency and number fields. From just one dialog box, you can apply:

•	font color,

•	background color, and

•	border style.

You can also specify multiple sets of formatting specifications, each one dependent on a separate condition.

  What's New in 7 Index


Field Mapping provides more database control

Seagate Crystal Reports provides a dialog box for mapping altered database fields. If the database is edited or changed, and causes errors in a report, you no longer need to delete and replace the affected fields. Now, you can remap them. This lets you get your reports up and running again in a very short amount of time.

The program will automatically generate the Map Fields dialog box when you need it.

  What's New in 7 Index


Enhanced Formula Editor makes creating formulas easy

The Formula Editor has been updated to include advanced features, including bookmarks (which allow you to navigate through long formulas), search and replace (also useful for long formulas), and the ability to edit more than one formula before closing the editor. Plus, you can rearrange the elements of the Formula Editor so that you can work more efficiently. In short, the Formula Editor has an entirely new look, allowing for faster manipulation of your formulas.

  What's New in 7 Index


Enhanced exporting capabilities

This version of Seagate Crystal Reports allows you to export reports to applications, such as MS Word and MS Excel. When a report is exported to an application, Seagate Crystal Reports saves the report as a temporary file and will automatically open it in the appropriate application. This new feature extends the range of reporting capabilities.

  What's New in 7 Index


New and better parameter fields provide greater flexibility

Seagate Crystal Reports includes new functionality that lets you create even more powerful parameter fields than before. With multiple default prompting values, you can allow for a wide range of options when entering parameter values. With range limiting, you can specify a minimum/maximum range for parameter values. With edit masks, you can limit the values entered to certain characters.

  What's New in 7 Index


On-Demand subreports increase report organization

Seagate Crystal Reports now allows you to create on-demand subreports, where the subreport data remains hidden until the user requests it. The subreport is represented on the report by an object frame, but the actual data remains hidden until the user drills-down on the frame. This way, the user will not be burdened with extraneous data. The user can choose when and if they want to drill down and view the subreport. This feature can be especially useful if you want to include several subreports in the same primary report, but you don't want all the data displayed at once. In this case, you can specify that the subreports are on-demand so that only an object frame will appear for each subreport. This makes the subreports much more manageable.

  What's New in 7 Index


Internet Resources for Seagate Crystal Reports Technical Support

Extensive Technical Resources are available to Seagate Crystal Report Users through our Web site as follows:

•	The Seagate Crystal Reports Product Page can be accessed through:

http://www.seagatesoftware.com/CrystalReports

•	The Seagate Crystal Reports Technical Support Page can be accessed through:

http://www.seagatesoftware.com/crystalreports/techsupp/

•	The Seagate Crystal Reports Knowledge Base can be accessed through:

http://www.seagatesoftware.com/prod-bi-techsupp/homepage/Knowledge_Base_Home.asp

•	The Seagate Technical Support FAQ (Frequently Asked Questions) can be accessed thorough:

http://www.seagatesoftware.com/prod-bi-techsupp/Whitepapers/FAQ_Index.asp

•	Technical Papers covering a large number of issues specific to Seagate Crystal Reports can be accessed through:

http://www.seagatesoftware.com/prod-bi-techsupp/Whitepapers/SCR_Technical_Papers_Index.asp

•	Subscriptions to the Seagate Crystal Reports Technical Newsletter can  be attained through:

http://maillist.seagatesoftware.com/subscribe.asp?ddProduct=

•	Technical Support questions can be submitted through:

http://webacd.seagatesoftware.com/

  What's New in 7 Index


Seagate Software International Office Directory

North/South American Head Office

Canada

USA and Latin America

USA and Latin America

Asia/Pacific Offices

Australia

Hong Kong

Japan

Singapore

Europe/Middle East/Africa Offices

United Kingdom - EMEA and Northern European Head Office

Netherlands

Scotland

Sweden

Germany - Central European Head Office

Switzerland

France - Southern European Head Office

Italy

Spain

South Africa Regional Office (Southern & Central Africa)

Middle East Regional Office (ME & Northern Africa)


North/South American Head Office


Canada

Seagate Software, Inc.

840 Cambie Street

Vancouver, BC V6B 4J2

Canada

Sales

Telephone: 604-681-3435

Toll-Free: 1-800-877-2340

Fax: 604-681-2934

E-Mail:sales@img.seagatesoftware.com

Product Support

Phone: 604-669-8379

Fax: 604-681-7163

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Mailing Address: Please refer to the address of the Seagate Software office nearest you.

Product Registration

Seagate Crystal Reports Web Registration: http://www.seagatesoftware.com/crystalreports/register

Fax: 604-681-5147

Mailing Address: Please see addresses listed on the registration card included in your package.


USA and Latin America


USA and Latin America

Seagate Software, Inc.

Suite 270 – 510 Thornall Street

Edison, NJ 08837

USA

Sales

Telephone: 732-321-6500

Fax: 732-321-6504

Product Support

Please see the Product Support section listed under Canada

Product Registration

Please see the Product Registration section listed under Canada


Asia/Pacific Offices


Australia

Seagate Software Pty Ltd

Level 9, 52 Alfred Street

Milsons Point

Sydney,  NSW  2061

Australia

Sales

Telephone: +61 2 9955 4088

Sales  +1-800-647-006

Fax: +61 2 9955 7682

Product Support

Please see the Product Support section listed under Canada

Product Registration

Fax: +61 2 9955 7692

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Canada.


Hong Kong

Seagate Software (HK)

20/F 83 Wanchai Road

Wanchai

Hong Kong

Sales

Telephone: +852 2575 2576

Fax: +852 2893 2727

Product Support

Please see the Product Support section listed under Canada

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Canada.


Japan

Seagate Software KK

Bridgestone Bldg. 2F

2-13-12 Hirakawa-cho,

Chiyoda-Ku,

Tokyo 102-0093

Sales

Telephone: +81.3. 5226. 3601

Fax: +81. 3 .5226 .3606

E-Mail: sales_jp@img.seagatesoftware.com

Product Support

Fax support: +81.3.5226.3605

Support E-Mail: support_jp@img.seagatesoftware.com

Product Registration

Fax Registration: +81.3.5226.3605

Seagate Crystal Reports Web Registration: http://www.seagatesoftware.com/crystalreports/register

Seagate Crystal Info Web Registration: http://www.seagatesoftware.com/crystalinfo/register


Singapore

Seagate Software IMG

14 Science Park Drive

03-02 The Maxwell

Singapore Science Park

Singapore 118226

Sales

Telephone: +65 777 0533

Fax: +65 777 8786

Product Support

Please see the Product Support section listed under Canada

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Canada.


Europe/Middle East/Africa Offices


United Kingdom - EMEA and Northern European Head Office

Seagate Software

The Broadwalk

54 The Broadway

Ealing, London

W5 5JN

UK

Sales

Telephone: +44  (0) 181 566 2330

Fax: +44 (0) 181 231 0600

Product Support

Country	Telephone	Language
UK	+44 (0) 181 231 0638	English
Austria	+ 43 (0) 1 79 5672 85	German
Switzerland	+ 41 (0) 1 800 9134	German
Switzerland	+ 41 (0) 1 800 9130	French
Belgium	+ 32 (0) 2 713 12 35	French
Netherlands	+ 31 (0) 20 346 9201	English
Ireland	+ 353 (0) 1 407 30 30	English
Sweden	+ 46 (0) 85 87 711 45	English
Fax: +44 (0) 181 231 0600 (English, German, French)

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Product Registration

Fax: + 44 (0) 181 231 0649

Seagate Crystal Reports Web Registration: http://www.seagatesoftware.com/crystalreports/register

Mailing Address: Please see addresses listed on the registration card included in your package.


Scotland

Seagate Software IMG

Ascada House

Garbett Road

Kirkton Campus

Livingston, West Lothian

EH54 7DL

Scotland

Sales

Telephone: +44 (0) 1506 410444

Fax: +44 (0) 1506 414994

Product Support

Please see the Product Support section listed under Northern European Head Office

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Northern Europe.


Sweden

Seagate Software

Kanalvagen 10C

194 61 Upplands Vasby

Sweden

Sales

Telephone: +46 8 590 04150

Fax: +46 8 590 04110

Product Support

Mailing Address: please see addresses listed on the registration card included in your package.

Product Registration

Please see the Product Registration section listed under Northern European Head Office.

On-line registrations: please see the product registration section listed under Northern Europe.


Netherlands

Seagate Software

Hojel City Center

Gebouw D, 4e etage

Graadt can Roggenweg 328

Postbox 19127

3501 DC Utrecht

The Netherlands

Sales

Telephone: +31 30 298 2124

Fax: +31 30 298 2125

Product Support

Please see the Product Support section listed under Northern European Head Office

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Northern Europe.


Germany - Central European Head Office

Seagate Software GmbH

2nd Floor

Frankfurter Strasse 21-25

D-65760 Eschborn

Germany

Sales

Telephone: +49 (0) 6196 9559 0

Fax: +49 (0) 6196 9559 10

Product Support

Telephone: +49 (0) 699 509 6180

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Product Registration

Fax: +49 (0) 6995 09 6182

Seagate Crystal Reports Web Registration: http://www.seagatesoftware.com/crystalreports/register

Mailing Address: Please refer to the addresses listed on the registration card included in your package.


Switzerland

Seagate Software GmbH

World Trade Center

PO Box 112

Leutschenbachstrasse 95

CH-8050 Zurich

Switzerland

Sales

Telephone: +41 1 308 3922

Fax: +41 1 308 3500

Product Support

Please see the Product Support section listed under Central European Head Office

Product Registration

Fax: +49 (0) 6995 09 6182

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Central Europe.


France - Southern European Head Office

Seagate Software

62 bis, avenue Andre Morizet

F-92643 Boulogne Billancourt

Cedex

France

Sales

Telephone: +33  (0) 1 41 10 1600

Fax: +33 (0) 1 46 04 7419

Product Support

Telephone: +33 (0) 141 918630

Fax +44 (0) 181 231 0600

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Product Registration

Fax: ++ 33 (0) 1 41 91 86 27

Seagate Crystal Reports Web Registration: http://www.seagatesoftware.com/crystalreports/register

Mailing Address: Please refer to the addresses listed on the registration card included in your package.


Spain

Seagate Software IMG

Paseo de la Castellana 93 -4a

28046, Madrid

Spain

Sales

Telephone: +341 555 5198

Fax: +341 555 9957

Product Support

Please see the Product Support section listed under Southern European Head Office

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Southern Europe.


Italy

Seagate Software S.r.l.

Via Conservatorio 22

Milan 20122

Italy

Sales

Telephone: +39 02 7729 310

Fax: +39 02 7729 40

Product Support

Please see the Product Support section listed under Southern European Head Office

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Southern Europe.


South Africa Regional Office (Southern & Central Africa)

Seagate Software IMG Ltd

Lower Ground Floor

Block F, Pin Mill Farm

164 Katherine Street

Sandton

PO Box 786050

Sandton, 2146

Republic of South Africa

Sales

Telephone: +27 11 448 2080

Fax: +27 11 448 1960

Product Support

Run Locally in Johannesburg.

Telephone: +27 11 448 2080

Fax: +27 11 448 1960.  Contact: Ross Harrison

E-Mail: rossh@seagatesa.co.za

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Northern Europe.


Middle East Regional Office (ME & Northern Africa)

Seagate Software

PO Box 8687

Dubai

United Arab Emirates

Sales

Telephone: +971 4 523888

Fax: +971 4 519056

Product Support

Run Locally in Dubai.

Telephone: +971 4 523888 Contact : Katia Boueiri

Fax: +971 4 519056  Contact : Katia Boueiri

E-Mail: kboueiri@img.seagatesoftware.com

E-Mail: support@webacd.seagatesoftware.com (Available in English only)

Web browser: http://webacd.Seagatesoftware.com (Available in English only)

Product Registration

Mailing Address: please see addresses listed on the registration card included in your package.

On-line registrations: please see the product registration section listed under Northern Europe.


Missing CRPEP Structures

  Click the topic of interest from the list below for further information:

CRPEGroupOptions

CRPEGroupOptions:: CRPEGroupOptions

CRPEReportSummaryInfo

CRPEReportSummaryInfo:: CRPEReportSummaryInfo

CRPEDrillOnGroupEventInfo

CRPETrackCursorInfo

CRPEFieldValueInfo

CRPEDrillOnDetailEventInfo

CRPEStartEventInfo

CRPEStopEventInfo

CRPEGeneralPrintWindowEventInfo

CRPECloseButtonClickedEventInfo

CRPEGroupTreeButtonClickedEventInfo

CRPESearchButtonClickedEventInfo

CRPEShowGroupEventInfo

CRPEZoomLevelChangingEventInfo

CRPEJob::GetAreaFormatFormula

CRPEJob::GetGroupOptions

CRPEJob::GetReportSummaryInfo

CRPEJob:: GetSectionFormatFormula

CRPEJob:: GetTrackCursorInfo

CRPEJob:: SetAllowPrompDialog

CRPEJob:: SetAreaFormatFormula

CRPEJob::SetGroupOptions

CRPEJob::SetReportSummaryInfo

CRPEJob::SetSectionFormatFormula

CRPEJob:: SetTrackCursorInfo


CRPEGroupOptions

This structure contains information about several options available with report groups. This information is used by CRPEJob::GetGroupOptions to retrieve current options and by CRPEJob::SetGroupOptions to pass new options.

Data Members

m_StructSize	Specifies the size of the PEGroupOptions structure. You must initialize the member to be the size of whatever it is, for example, groupOptions.structSize = PEP_SIZEOF_GROUP_OPTIONS. When setting structSize, pass a PEP_GC_constant, or PEP_UNCHANGED for no change. When getting structSize, use PEP_GC_TYPEMASK and PEP_GC_CONDITIONMASK to decode the condition.
m_condition	Specifies a pointer to the condition setting for the selected group section (date and Boolean fields only).
m_sortDirection	Specifies the sort direction by using the following constants:
Constant	Value	Meaning
PEP_SF_DESCENDING	0	Sorts data in descending order (Z to A, 9 to 1).
PEP_SF_ASCENDING	1	Sorts data in ascending order (A to Z, 1 to 9).
PEP_SF_ORIGINAL	2	Sorts data in its original order (Group condition only).
PEP_SF_SPECIFIED	3	Sorts data in a specified order (Group condition only). Read only.
m_repeatGroupHeader	BOOL value, or PEP_UNCHANGED for no change.
m_keepGroupTogether	BOOL value, or PEP_UNCHANGED for no change.
m_topOrBottomNGroups	Use one of the following values, a PEP_GO_TBN_constant, or PEP_UNCHANGED (for no change):
Constant	Value	Meaning
PEP_GO_TBN_ALL_GROUPS_UNSORTED	0	There is no group sorting or Top/Bottom N for this level of grouping.
PEP_GO_TBN_ALL_GROUPS_SORTED	1	There is group sorting, but not Top/Bottom N.
PEP_GO_TBN_TOP_N_GROUPS	2	Top N groups will be selected.
PEP_GO_TBN_BOTTOM_N_GROUPS	3	Bottom N groups will be selected.
m_nTopOrBottomGroups	Number of groups to select.
m_discardOtherGroups	Determines whether the remaining groups are discarded or collected into an Others group.
m_fieldName	Specifies the field name of the group field.
m_topOrBottomNSortFieldName	Name of the summary field that the groups are ordered by. Remains empty for no change.
Remarks

•	Use PEP_UNCHANGED for no change.

•	If topOrBottomNGrous is PEP_GO_TBN_TOP_N_GROUPS or PEP_GO_TBN_BOTTOM_N_GROUPS, all the group sort fields related to this group will be deleted. A new group sort field will be added with the sort direction of descending or ascending. The group sort field will be sorted by specifying topOrBottomNSortFieldName if it is not empty. It will be sorted by the first group sort field name related to this group (before it is deleted) if topOrBottomNSortFieldName is empty.

Constructor	Description
CRPEGroupOptions::CRPEGroupOptions	Constructs a CRPEGroupOptions structure type


CRPEGroupOptions:: CRPEGroupOptions

Syntax

CRPEGroupOptions ()

For example

CRPEGroupOptions (short condition,

                      _TCHAR *fieldName,

                      short  sortDirection,

                      short  repeatGroupHeader,

                      short  keepGroupTogether,

                      short  topOrBottomNGroups,

                      _TCHAR *topOrBottomNSortFieldName,

                      short  nTopOrBottomGroups,

                      short  discardOtherGroups

                     )

Parameters

condition	Specifies a pointer to the condition setting for the selected group section (date and Boolean fields only). Assigns this value to the CRPEGroupOptions::m_condition.
sortDirection	Specifies the sort direction. Assigns a value to the CRPEGroupOptions::m_sortDirection, using one of the following constants:
Constant	Value	Meaning
PEP_SF_DESCENDING	0	Sorts data in descending order (Z to A, 9 to 1).
PEP_SF_ASCENDING	1	Sorts data in ascending order (A to Z, 1 to 9).
PEP_SF_ORIGINAL	2	Sorts data in its original order (Group condition only).
PEP_SF_SPECIFIED	3	Sorts data in a specified order (Group condition only). Read only.
repeatGroupHeader	BOOL value, or PEP_UNCHANGED for no change. Assigns this value to the CRPEGroupOptions::m_reapeatGroupHeader.
keepGroupTogether	BOOL value, or PEP_UNCHANGED for no change. Assigns this value to the CRPEGroupOptions::m_keepGroupTogether.
topOrBottomNGroups	Use one of the following values, a PEP_GO_TBN_constant, or PEP_UNCHANGED for no change (Assigns this value to the CRPEGroupOptions::m_topOrBottomNGroups.):
Constant	Value	Meaning
PEP_GO_TBN_ALL_GROUPS_UNSORTED	0	There is no group sorting or Top/Bottom N for this level of grouping.
PEP_GO_TBN_ALL_GROUPS_SORTED	1	There is group sorting, but not Top/Bottom N.
PEP_GO_TBN_TOP_N_GROUPS	2	Top N groups will be selected.
PEP_GO_TBN_BOTTOM_N_GROUPS	3	Bottom N groups will be selected.
nTopOrBottomGroups	Number of groups to select. Assigns this value to the CRPEGroupOptions::m_nTopOrBottomGroups.
discardOtherGroups	Determines whether the remaining groups are discarded or collected into an Others group. Assigns this value to the CRPEGroupOptions::m_discardOtherGroups.
fieldName	Specifies the field name of the group field. Assigns this value to the CRPEGroupOptions::m_fieldName.
topOrBottomNSortFieldName	Name of the summary field that the groups are ordered by. Remains empty for no change. Assigns this value to the CRPEGroupOptions::m_topOrBottomNSortFieldName.


CRPEReportSummaryInfo

This structure provides report summary information such as the report title, author, and comments. It corresponds to the report summary information in the Seagate Crystal Reports Designer. This structure is used by CRPEJob::GetReportSummaryInfo to get information about a specific parameter field, and it is used by CRPEJob::SetReportSummaryInfo to change a specific parameter field.

Data Members

m_StructSize	Specifies the size of the structure. You must initialize this member to be the size of whatever it is, for example, reportSummary.StructSize = PEP_SIZEOF_REPORT_SUMMARY_INFO
m_applicationName	Specifies an application name for the application using this report.
m_title	Specifies the title of the current report.
m_subject	Specifies the subject of the current report.
m_author	Specifies the author of the current report.
m_keywords	Specifies the keywords included for the current report.
m_comments	Specifies any comments for the current report.
m_reportTemplate	Specifies the report template for the current report.
Constructor

Constructor	Description
CRPEReportSummaryInfo::CRPEReportSummaryInfo	Constructs a CRPEReportSumamryInfo structure type


CRPEReportSummaryInfo:: CRPEReportSummaryInfo

Syntax

CRPEReportSummaryInfo ();

For example

CRPEReportSummaryInfo (_TCHAR *applicationName,
                           _TCHAR *title,
                           _TCHAR *subject,
                           _TCHAR *author,
                           _TCHAR *keywords,
                           _TCHAR *comments,
                           _TCHAR *reportTemplate
                          )

Parameters

applicationName	Specifies an application name for the application using this report. Assigns this value to the CRPESReportSummaryInfo::m_applicationName.
title	Specifies the title of the current report. Assigns this value to the CRPESReportSummaryInfo::m_title.
subject	Specifies the subject of the current report. Assigns this value to the CRPESReportSummaryInfo::m_subject.
author	Specifies the author of the current report. Assigns this value to the CRPESReportSummaryInfo::m_author.
keywords	Specifies the keywords included for the current report. Assigns this value to the CRPESReportSummaryInfo::m_keywords.
comments	Specifies any comments for the current report. Assigns this value to the CRPESReportSummaryInfo::m_comments.
reportTemplate	Specifies the report template for the current report. Assigns this value to the CRPESReportSummaryInfo::m_reportTemplate.


CRPEDrillOnGroupEventInfo

This structure specifies whether to drill on group information when PEP_DRILL_ON_GROUP_EVENT happens.

Data Members

m_StructSize	Specifies the size of the PEDrillOnGroupEventInfo structure. You must initialize this number to be the size of whatever it is, for example, drillOnGroupEventInfo.StructSize = PEP_SIZEOF_DRILL_ON_GROUP_EVENT_INFO.
m_drillType	Specifies the type of drill down that is used. Use one of the following:
Constant	Value	Meaning
PEP_DE_ON_GROUP	0	Drill-down on a group summary or subtotal.
PEP_DE_ON_GROUPTREE	1	Drill-down a Group Tree node.
PEP_DE_ON_GRAPH	2	Drill-down a group graph object.
PEP_DE_ON_MAP	3	Drill-down on a map region.
PEP_DE_ON_SUBREPORT	4	Drill-down on a subreport.
m_windowHandle	Points to an array of group name. The list specifies the group path of the selected group. Memory pointed by group list is freed after the callback function.
m_groupList	Pointer to an array of group names in the report when drilling on a group summary, a Group Tree, a graph, or a map. Pointer to a single element array containing the subreport name when drilling on a subreport. This memory is freed after the callback function is called.
m_groupLevel	The number of the group name in the group list.
Remarks

The groupList will be freed after the callback function. If you want to keep the groupList, make a copy of it.


CRPETrackCursorInfo

This structure specifies cursor information such as size and type. To get or set track cursor details in the preview window, use the CRPEJob::GetTrackCursorInfo or CRPEJob::SetTrackCursorInfo function calls.

Data Members

m_StructSize	You must initialize this member to be the size of whatever it is, for example trackCursor.StructSize = PEP_SIZEOF_TRACK_CURSOR_INFO.
m_groupAreaCursor:	Specifies the group area cursor. Pass PEP_UNCHANGED for no change, or use one of the following values:
Constant	Value	Meaning
PEP_TC_DEFAULT_CURSOR	0	Sets the default cursor to PEP_TC_ARROW_CURSOR.
PEP_TC_ARROW_CURSOR	1	Arrow cursor
PEP_TC_CROSS_CURSOR	2	Cross cursor
PEP_TC_IBEAM_CURSOR	3	I-beam cursor
PEP_TC_UPARROW_CURSOR	4	Arrow cursor pointing to the top of the screen.
PEP_TC_SIZEALL_CURSOR	5	32-bit only.
PEP_TC_SIZENWSE_CURSOR	6	Sizing cursor when resizing from the top, left-hand side of the screen to the bottom, right-hand side of the screen.
PEP_TC_SIZENESW_ CURSOR	7	Sizing cursor when resizing from the top, right-hand side of the screen to the bottom, left-hand side of the screen.
PEP_TC_SIZEWE_ CURSOR	8	Sizing cursor when resizing from the left side of the screen to the right side of the screen.
PEP_TC_SIZENS_ CURSOR	9	Sizing cursor when resizing from the top of the screen to the bottom of the screen.
PEP_TC_NO_ CURSOR	10	32-bit only.
PEP_TC_WAIT_ CURSOR	11	Wait (i.e., hourglass) cursor.
PEP_TC_APPSTARTING_ CURSOR	12	32-bit only.
PEP_TC_HELP_CURSOR	13	32-bit only.
PEP_TC_SIZE_CURSOR	14	16-bit only.
PEP_TC_ICON_CURSOR	15	16-bit only.
PEP_TC_MAGNIFY_ CURSOR	99	Magnifying glass cursor (used for drill-down).
m_groupAreaFieldCursor	Specifies the cursor for a memo, blob, database, summary, or formula field in the group area. See the list of cursor constants under groupAreaCursor.
m_detailAreaCursor	Specifies the cursor for the Details area. See the list of cursor constants under groupAreaCursor.
m_detailAreaFieldCursor	Specifies the cursor for a memo, blob, database, summary, or formula field in the Details area. See the list of cursor constants under groupAreaCursor.
m_graphCursor	Specifies the cursor for the group graph in the Report Header or Report Footer area. See the list of cursor constants under groupAreaCursor.
m_groupAreaCursorHandle	Reserved, do not use.
m_groupAreaFieldCursorHandle	Reserved, do not use.
m_detailAreaCursorHandle	Reserved, do not use.
m_detailAreaFieldCursorHandle	Reserved, do not use.
m_graphCursorHandle(0)	Reserved, do not use.
Remarks

•	By default, all the cursors are set to the constant PEP_TC_ARROW_CURSOR. If the canDrillDown option in PEWindowOptions is True, groupAreaCursor, groupAreaFieldCursor, and graphCursor will be PEP_TC_MAGNIFY_CURSOR.

•	Some cursors are 32-bit only and some are 16-bit only. If a cursor is not supported on a platform, the cursor will not be changed for the specified area.


CRPEFieldValueInfo

This structure specifies a field value in the fieldValueList of the CRPEDrillOnDetailEventInfo function call.

Data Members

m_StructSize	You must initialize the member to be the size of whatever it is, for example, fieldValueInfo.structSize = PEP_SIZEOF_FIELD_VALUE_INFO.
m_ignored	For 4 byte alignment. Ignore.
m_fieldName	Specifies the formula form of a field name.
m_fieldValue	Specifies the field value for the selected Details area for the field specified by the field name.
Remarks

A selected Details area corresponds to a database record.


CRPEDrillOnDetailEventInfo

This structure provides PEP_DRILL_ON_DETAIL_EVENT event information.

Data Members

m_StructSize	You must initialize this number to be the size of whatever it is, for example,drillOnDetailEventInfo.StructSize = PEP_SIZEOF_DRILL_ON_DETAIL_EVENT_INFO.
m_selectedFieldIndex	A 0 based index indicating which drill-down field wasselected. Contains -1 if no field is selected.
m_windowHandle	Frame window handle where the drill on detail event happens.
m_fieldValueList	Points to an array of PEFieldValue. Memory pointed by fieldValueList is freed after calling the callback function. Null-by default
m_nFieldValue	Number of field value in field value of list (i.e., if the value is listed second, the number would be 2).
Remarks

If the user clicks one of the fields in the Details section, selectedFieldIndex will point to the field index in fieldValueList. These fields have to be one of database field, group name field, summary field, formula field. Clicks on text object, graph, picture, ole, subreport, special var field, or database memo or blob field, selectedFieldIndex return -1.


CRPEStartEventInfo

This structure provides start event information when the callback function is called with event ID equal to PEP_START_EVENT.

Data Members

m_StructSize	You must initialize this member to be the size of whatever it is, for example startEvent.StructSize = PEP_SIZEOF_START_EVENT_INFO.
m_destination	Indicates the process destination as one of the following values:
Constant	Value	Meaning
PEP_TO_NOWHERE	0	No destination.
PEP_TO_WINDOW	1	Print to window.
PEP_TO_PRINTER	2	Print to printer.
PEP_TO_EXPORT	3	Export.
PEP_FROM_QUERY	4	From a query.


CRPEStopEventInfo

This structure provides stop event information when a callback function is called with an event ID equal to PEP_STOP_EVENT.

Data Members

m_StructSize	You must initialize this member to be the size of whatever it is, for example stopEvent.StructSize = PEP_SIZEOF_STOP_EVENT_INFO.
m_destination	Indicates the process destination as one of the following values:
Constant	Value	Meaning
PEP_TO_NOWHERE	0	No destination.
PEP_TO_WINDOW	1	Print to window.
PEP_TO_PRINTER	2	Print to printer.
PEP_TO_EXPORT	3	Export.
PEP_FROM_QUERY	4	From a query.
m_jobStatus	Indicates the current status of the job as one of the following values:
Constant	Value	Meaning
PEP_JOBNOTSTARTED	1	The job has not been started.
PEP_JOBINPROGRESS	2	The job is currently in progress.
PEP_JOBCOMPLETED	3	The job has completed successfully.
PEP_JOBFAILED	4	The job failed.
PEP_JOBCANCELLED	5	The job was cancelled by the user.
PEP_JOBHALTED	6	The report has exceeded the record or time governors.


CRPEGeneralPrintWindowEventInfo

This structure specifies general preview window event information.

Data Members

m_StructSize	You must initialize the member to be the size of whatever it is, for example, generalPrintWindowEventInfo.structSize = PEP_SIZEOF_GENERAL_PRINT_WINDOW_EVENT_INFO.
m_ignored	For 4 byte alignment. Ignore.
m_windowHandle	Frame window handle where the event happens.


CRPECloseButtonClickedEventInfo

This structure contains information about a close button clicked event. When the close button in a preview  window is clicked, a callback function will be called with EventId = PEP_CLOSE_BUTTON_CLICKED_EVENT. The fieldValueList will be released after the callback function. Make a copy of the field value list if you want to hold on to the field value information.

Data Members

m_StructSize	You must initialize this number to be the size of whatever it is, for example, closeButtonClickedEventInfo. StructSize = PEP_SIZEOF_CLOSE_BUTTON_CLICKED_EVENT_INFO
m_viewIndex	Specifies which view is going to be closed. Start from 0.
m_windowHandle	Specifies the frame window handle the button is on.


CRPEGroupTreeButtonClickedEventInfo

This structure provides information about the group tree button clicked event, when the callback function is called with the event ID equal to PEP_GROUP_TREE_BUTTON_CLICKED_EVENT.

Data Members

m_StructSize	You must initialize this member to be the size of the structure, for example: groupTreeButton.StructSize = PEP_SIZEOF_GROUP_TREE_BUTTON_CLICKED_EVENT_INFO.
m_visible	Indicates whether the group tree is shown or hidden.
m_windowHandle	Frame window handle where the event happens.


CRPESearchButtonClickedEventInfo

This structure returns information when a callback function is called with event ID equal to PEP_SEARCH_BUTTON_CLICKED_EVENT.

Data Members

m_StructSize	You must initialize this member to be the size of whatever it is, for example, searchButtonClicked.StructSize = PEP_SIZEOF_SEARCH_BUTTON_CLICKED_EVENT_INFO.
m_windowHandle	Frame window handle which the button is on.
m_searchString	Search string in search edit control.


CRPEShowGroupEventInfo

This structure provides show group event information when an event callback is called with event ID equal to PEP_SHOW_GROUP_EVENT.

Data Member

m_StructSize	You must initialize this member to be the size of whatever it is, for example showGroup.StructSize = PEP_SIZEOF_SHOW_GROUP_EVENT_INFO.
m_groupLevel	Number of items in groupList.
m_windowHandle	Frame window handle where the event happens.
m_groupList	Pointer to an array of group names describing the group path that the group area is going to navigate to. This pointer is freed after the callback function. Default value is Null.


CRPEZoomLevelChangingEventInfo

This structure gives information about the PEP_ZOOM_LEVEL_CHANGING_EVENT event.

Data Members

m_StructSize	You must initialize this member to the size of whatever it is, for example, zoomLevelChanging.StructSize = PEP_SIZEOF_ZOOM_LEVEL_CHANGNG_EVENT_INFO.
m_zoomLevel	The zoom level you wish to set the preview window at. This value can be a value from 25 to 400, indicating a magnification percentage, or it can be one of the following constants:
Constant	Value	Meaning
PEP_ZOOM_SIZE_FIT_ONE_SIDE	1	Fit One Side
PEP_ZOOM_SIZE_FIT_BOTH_SIDES	2	Fit Both Sides
m_windowHandle	Specifies the frame window handle where the event happens.


CRPEJob::GetAreaFormatFormula

Retrieves the text of a conditional area format formula as a string handle. Use this function in order to update the conditional area format formula and pass the changes back using CRPEJob::SetAreaFormatFormula.

Syntax

BOOL GetAreaFormatFormula(short areaCode,

                          short formulaName,

                          CString &formulaText);

Parameters

areaCode	Specifies the code for the report area for which you want to set formatting options. For information on area codes, see Working with section codes.
formulaName	Specifies the name of the formatting formula for which you want to supply a new string. Use one of the following constants:
Constant	Value	Meaning
PE_FFN_AREASECTION_ VISIBILITY	58	Area or section invisible.
PE_FFN_SHOW_AREA	59	Area is shown or hidden. When hidden, drill down is OK.
PE_FFN_NEW_PAGE_BEFORE	60	Start a new page before this area.
PE_FFN_NEW_PAGE_AFTER	61	Start a new page after this area.
PE_FFN_KEEP_TOGETHER	62	Keep area together.
PE_FFN_RESET_PAGE_N _AFTER	64	Reset page number after the area.
PE_FFN_PRINT_AT_BOTTOM_OF_PAGE	65	Print at bottom of the page.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob::GetGroupOptions

Retrieves the current setting for specified groups in your report.

Syntax

BOOL GetGroupOptions(short groupN,

                     CRPEGroupOptions *groupOptions);

Parameters

groupN	Specifies the group number. The first level group is 0.
groupOptions	Specifies the pointer to the CRPEGroupOptions structure.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob::GetReportSummaryInfo

Obtains summary information about the report such as the report title, author, and comments.

Syntax

BOOL GetReportSummaryInfo(CRPEReportSummaryInfo *summaryInfo);

 Parameters

summaryInfo	Specifies a pointer to PEReportSummaryInfo.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob:: GetSectionFormatFormula

Retrieves the text of a conditional section format formula as a string handle. Use this function in order to update the conditional section format formula and pass the changes back using CRPEJob::SetSectionFormatFormula.

Syntax

BOOL GetSectionFormatFormula(short areaCode,
                             short sectionCode,
                             short formulaName,
                             CString &formulaText);

Parameters

areaCode	Specifies the code for the report area for which you want to set formatting options. For information on area codes, see Working with section codes.
sectionCode	Specifies the code for the report section(s) for which you want to get section format information. See the table of section constants supplied in Working with section codes.
formulaName	Specifies the name of the section format formula.
Constant	Value	Meaning
PE_FFN_SECTION_VISIBILITY	58	Specifies that the area be visible. If not visible, drill down will be available.
PE_FFN_SHOW_AREA	59	Specifies that a new page will be printed before the section.
PE_FFN_NEW_PAGE_BEFORE	60	Specifies that a new page will be printed after the section.
PE_FFN_NEW_PAGE_AFTER	61	Specifies that the section will be kept together.
PE_FFN_KEEP_TOGETHER	62	Specifies that if the section is blank, it will not be printed.
PE_FFN_SUPPRESS_BLANK_ SECTION	63	Specifies that page numbering will reset after the section.
PE_FFN_RESET_PAGE_N_AFT7ER	64	Specifies that the section will be printed at the bottom of the page.
PE_FFN_PRINT_AT_BOTTOM_ OF_PAGE	65	Specifies that the section will overlay any sections following.
PE_FFN_UNDERLAY_SECTION	66	Specifies the background color of the section.
PE_FN_SECTION_BACK_COLOUR	67
formulaText	The Cstring object passed here is loaded with the specified formula text when CRPEJob::SetFormula completes successfully.
Return Value

•	TRUE (1) if the call is successful; FALSE (0) if the call fails.

Remarks

•	Not all formula names apply to all sections.

•	Use the value returned by textLength to allocate memory for a buffer. Use CRPEGetHandleString to fill the buffer with the actual text of the formula.


CRPEJob:: GetTrackCursorInfo

Track cursors can be specified for different report areas and report objects in the preview window. This function gets track cursor information for a specified job.

Syntax

BOOL GetTrackCursorInfo(CRPETrackCursorInfo *cursorInfo);

Parameters

cursorInfo	Specifies a pointer to the CRPETrackCursorInfo structure, that will be used for getting track cursor information.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob:: SetAllowPrompDialog

Used to specify whether prompting for parameter values is allowed during printing.

Syntax

BOOL CRPEJob::SetAllowPromptDialog(BOOL showPromptDialog);

Parameters

showPromptDialog	If TRUE then prompting is allowed.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob:: SetAreaFormatFormula

Changes the specified area format formula to the formula string you supply as a parameter. This function will only change the text of a formula which already exists in the report; you can not use it to add a formula.

When you give the user the ability to change the formula at print time, your link must include code to replace formulaString with a user-generated value.

Syntax

BOOL SetAreaFormatFormula(short areaCode,
                          short formulaName,
                          CString formulaText);

Parameters

areaCode	Specifies the code for the report area for which you want to set formatting options. For information on area codes, see Working with section codes.
formulaName	Specifies the name of the formatting formula for which you want to supply a new string. Use one of the following constants:
Constant	Value	Meaning
PE_FFN_SECTION_VISIBILITY	58	Specifies that the section be visible. If not visible, no drill down will be available.
PE_FFN_SHOW_AREA	59	Specifies that the area be visible. If not visible, drill down will be available.
PE_FFN_NEW_PAGE_BEFORE	60	Specifies that a new page will be printed before the section.
PE_FFN_NEW_PAGE_AFTER	61	Specifies that a new page will be printed after the section.
PE_FFN_KEEP_TOGETHER	62	Specifies that the section will be kept together.
PE_FFN_SUPPRESS_ BLANK_SECTION	63	Specifies that if the section is blank, it will not be printed.
PE_FFN_RESET_PAGE_ N_AFTER	64	Specifies that page numbering will reset after the section.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.

Remarks

•	The formulaName constant PEP_FFN_SECTION_VISIBILITY is supported for compatibility with earlier versions of Crystal Report Engine applications. This constant has the same value as PEP_FFN_AREASECTION_VISIBILITY. All new Crystal Report Engine applications should use PEP_FFN_AREASECTION_VISIBILITY.

•	This function should be called before CRPEStartPrintJob or the results may be inconsistent or unexpected.

•	Not all parameters apply to all areas.


CRPEJob::SetGroupOptions

Sets grouping options for the specified group.

Syntax

BOOL SetGroupOptions(short groupN,

                     CRPEGroupOptions *groupOptions);

Parameters

groupN	Specifies the group level number starting from 0.
groupOptions	Specifies a pointer to CRPEGroupOptions.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.

Remarks

•	This function should be called before CRPEStartPrintJob or the results may be inconsistent or unexpected.

•	If you are using CRPESetGroupOptions to set the top/bottom N sort field, all the group sort fields related to the group will be deleted and a new one specified by the group options will be added.


CRPEJob::SetReportSummaryInfo

The PESetReportSummaryInfo functions is used to set report summary information. Report summary information corresponds to the Summary Info dialog box in Seagate Crystal Reports.

Syntax

BOOL SetReportSummaryInfo(CRPEReportSummaryInfo *summaryInfo);

Parameters

summaryInfo	Specifies the pointer to CRPEReportSummaryInfo.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.


CRPEJob::SetSectionFormatFormula

Changes the specified section format formula to the formula string you supply as a parameter. This function will only change the text of a formula which already exists in the report; you can not use it to add a formula.

When you give the user the ability to change the formula at print time, your link must include code to replace formulaString with a user-generated value.

Syntax

BOOL SetSectionFormatFormula(short sectionCode,
                             short formulaName,
                             CString formulaText);

Parameters

sectionCode	Specifies the code for the report section(s) for which you want to set formatting options. See Working with section codes.
formulaName	Specifies the name of the formula for which you want to supply a new string. Use one of the following constants:
Constant	Value	Meaning
PE_FFN_SECTION_VISIBILITY	58	Specifies that the section be visible. If not visible, no drill down will be available.
PE_FFN_SHOW_AREA	59	Specifies that the area be visible. If not visible, drill down will be available.
PE_FFN_NEW_PAGE_BEFORE	60	Specifies that a new page will be printed before the section.
PE_FFN_NEW_PAGE_AFTER	61	Specifies that a new page will be printed after the section.
PE_FFN_KEEP_TOGETHER	62	Specifies that the section will be kept together.
PE_FFN_SUPPRESS_BLANK_ SECTION	63	Specifies that if the section is blank, it will not be printed.
PE_FFN_RESET_PAGE_N_AFTER	64	Specifies that page numbering will reset after the section.
PE_FFN_PRINT_AT_BOTTOM_OF_PAGE	65	Specifies that the section will be printed at the bottom of the page.
PE_FFN_UNDERLAY_SECTION	66	Specifies that the section will overlay any sections following.
PE_FFN_SECTION_BACK_COLOUR	67	Specifies the background color of the section.
formulaText	The Cstring object passed here is loaded with the specified formula text when CRPEJob::SetFormula completes successfully.

Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails or if there is an error in the new formula.

	If the formula name passed in does not exist, or it does not apply to the section, the program generates a PEPRR_BADFORMULANAME code. If there is an error in the formula, the program generates a PEPERR_BADFORMULATEXT code. See Report Engine Error Codes for further information
Remarks

•	This function should be called before CRStartPrintJob or the results may be inconsistent or unexpected.

•	Not all formula names can be applied to all sections.


CRPEJob:: SetTrackCursorInfo

Sets information for tracking the position of the mouse cursor over the preview window. This functions is only valid if the report was sent to a preview window (see CRPEOutputToWindow), and if events for the preview window have been enabled (see CRPEEnableEvent).

Syntax

BOOL SetTrackCursorInfo(CRPETrackCursorInfo *cursorInfo);

Parameters

cursorInfo	Specifies a pointer to CRTrackCursorInfo.
Return Value

TRUE (1) if the call is successful; FALSE (0) if the call fails.

Remarks

•	By default, all area's track cursors are arrow cursors. If the preview window contains a drill-down field (database field, summary, group name, group chart), the group area will use a magnify cursor. Group charts in other areas will also use the magnify cursor.

•	This function can be used to give the user visual feed back especially when tracking events.