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 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: 1299