How do I create a report in Crystal Reports that is portable to any Sage CRE application or data folder?

Solution Properties

Solution ID:

222924450019972

Last Modified Date:

Thu Mar 23 19:05:46 UTC 2023

Taxonomy Path:

Category//Reporting//Printing

Author:

sageadmin

How do I create a report in Crystal Reports that is portable to any Sage CRE application or data folder?

Description

Cause

Resolution

Tip: The DSN you use to create the report must exist on all workstations that will generate or print the report.

Set up an ODBC data source name (DSN) in standard description mode. For information on how to create a DSN, select the link below.
In Crystal Reports, create the report with the DSN that you set up.
In Crystal Reports, add a @tsDesignMode formula with a value of "SDesc" to the report. For more information about the tsDesignMode formula, select the link below.

DocLink: How do I set up an ODBC User DSN for Accounting and Management data?
DocLink: How do I use the @tsDesignMode formula on Crystal reports?
DocLink: How do I use an ODBC data source name (DSN) for my Sage 300 Construction and Real Estate data in a Crystal report?

Defect ID

Steps to duplicate

Related Articles