ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon General Setup
DrillDown Icon General Setup Introduction
DrillDown Icon Number System
DrillDown Icon Calendar Setup
DrillDown Icon Administrative Departments
DrillDown Icon Designate a PDF directory
DrillDown Icon Payment Terms
DrillDown Icon Sales Tax Authority Table
DrillDown Icon Standard Foot Notes
DrillDown Icon User Defined Reports Setup
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon System Appearance
DrillDown Icon Sales
DrillDown Icon Production
DrillDown Icon Material
DrillDown Icon FAQs
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Fields & Definitions for User Defined Reports Setup

 

 

1. Crystal Reports must NOT be designed using "live" MANEX DBFS tables. Data will be corrupted in MANEX if any of the tables used for the design are accessed and changed while the design is in progress.  To use Crystal Report Designer, create a copy of the DBFS and use the copy to design the report. 

2. MANEX has no reason to believe that running a previously designed Crystal Report using live MANEX files will cause any problems. It does not matter if the report was designed using Crystal Report Designer or written as a custom executable.

 

3. However, when using Crystal Report Designer or running a pre-existing Crystal Report, the user's workstation should be using   "absolute NOT    "relative"   paths to the DBFS files in use     (ie. X:\Manex\DBFS\xyz.dbf   NOT   \\Manex\DBFS\xyz.dbf),   where “X” is the   absolute    drive letter. Therefore, workstations setup with shortcuts to MANEX using relative addressing (for security reasons*) shouldn't be used to run Crystal Reports.

* Normally MANEX suggests that users use the MANEX shortcuts with relative addressing (not mapped to the server) to keep users from accessing the MANEX Server files in Windows Explorer.

4. If you accidentally corrupt the MANEX DBFS files using Crystal Report Designer or relative addressing, get all users off of MANEX and reindex TWICE.  The first time clears the incorrect End of File table and the second time writes a corrected index.

So in conclusion, as long as you don't design on the live database and you use "absolute" mapping to the server, using Crystal Reports to look at the live data after the report is designed should not be a problem.

  

Article ID: 3670