ManEx does not provide training on the use of Crystal Reports software.  It is not our product.  To arrange for training, call Seagate Software at 1-800-877-2340.

If you do not have anyone on your staff who can do the reports and you want an outside designer, there are independent software consultants who do this type of work.  In the Silicon Valley area, one of these consultants is Wisdom Technology. The number is 408-997-7165.  The contact’s name is Bob Shatzer.

ManEx can provide you or your designer with the database information for the reports you are trying to create. We will charge you phone support hours your company purchased for the time we spend.

This module will allow each end workstation the ability to view(desktop only) any custom Crystal Report that has been compiled in .rpt format and loaded into the "User Defined Report Setup" screen.  ManEx includes the Crystal Reports viewer so custom reports created in Crystal Reports can be controlled and distributed through the software, WITHOUT having to have any Crystal Report software loaded on that machine. 

For Manexcloud custom reports users can create custom Quick View reports. See article here. Article 5816 For full report options on Manexcloud you can use Stimulsoft software  Once setup you can configure to work with SQLManex Configure Stimulsoft To Work With SQL Data

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. 

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.

Enter the SQLSYSSETTING.EXE (within the ManEx root directory) This action will then prompt the user for a password
The following screen will be displayed, enter the General Setup/User Defined Reports Setup Module

The following screen will be displayed:

 

To add a new report, depress the Add button.
Select the appropriate section from the pull down.
Select the appropriate department/screen from the pull down.
Enter the path for the file source.  Or to browse, depress the button to the right. A browse window will appear: Select the Directory by depressing the down arrow next to the Look In: field. Select the file name. Depress the OK button
The File Source will be defaulted in:.
Enter in the report title.
Enter the Description.
Depress the Save button.  Now you can continue to add more reports or exit this screen.

 

When you visit the applicable module, the report you created will appear in the Reports Selection window, as illustrated:

 

 

 

PRECAUTIONS WHEN USING CRYSTAL REPORTS AND CRYSTAL REPORT DESIGNER WITH THE MANEX DATABASE

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).  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.