1. How To ..... for User Defined Reports Setup
1.1. Setup the User Defined Reports

Enter System Setup/General Setup/User Defined Reports Setup Module   

The following screen will appear:
 
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. 
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:
 

 

If the following error appears when attempting to access the Custom Report.  Make sure that the ODBC for Crystal Reports is setup correctly.  For further detail see Article #3012 . 



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

1. Crystal Reports must not be designed using "live" ManEx DBFS tables. Data will be corrupted in ManEx if the 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).  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.
 
"Mark as Completed RoadMap Section B Item 1-h"   
 
1.2. Setup the ODBC for Crystal Reports
 Check setting for an ODBC data source, which is usually found under:
      Start > Programs > Administrative Tools> Data Sources(ODBC), or 
      Start > Settings > Control Panel > Data Sources (ODBC).
 
 If you cannot find it under either of these locations you may want to go to the "Start" and do a search:
 
 
 
 
To download and run the    drivers click here, 

 
Enter the "System DSN" tab:
 
 
 
Click “Add” and you will see the New Data Source wizard, select “Microsoft Visual FoxPro Driver”, and click “Finish”
 
 
 
ODBC Visual FoxPro Setup pops up. Enter a name and description. The Database type should be “Visual FoxPro database (.DBC), and you should select “Manex.DBC” in server Manex DBFS folder.
 
 
 
Depress OK, the setup process is complete and the new file should display in the ODBC Data Source Administrator/System DSN. 
 
 
 
 
  • If the end machine is setup as a 64 Bit machine and it is not making available the VFP ODBC drivers for you to select from, Download and install odbcad32.exe on the 64 bit machine. The VFP ODBC drivers should now be available to select from. Make sure that the drivers are configured to match the report as it was originally designed. The same reports should now work on both 32 bit and 64 bit machines.
  • The VFP ODBC Driver can be installed under 64-bit Windows but 64-bit applications cannot access VFP ODBC driver because it comes only in 32-bit version. For 32-bit applications under 64-bit Windows there's ODBC Data Source Administrator for the 32-bit ODBC drivers. Download and install odbcad32.exe

 
1.3. Custom Crystal Reports Created by Manex
The following Crystal Reports have been designed by ManEx.  These Crystal Reports are 'AS IS"  and any desired modifications would be up to the individuals.  These are some examples on how we intended the CR's to report data.
1.3.1. WO Shortage Report
Select the WO Shortage Report - the following screen will appear:
 
 
Select the WO Status - Closed, Rework Firm, or Standard
 
 
Select the WO Number  _ the Work Order Number and Product Number will appear:
 
 
Depress OK and the following Report will be displayed:
 
 
 
 
1.3.2. WO Update by Customer Report
Select the WO Update by Customer Report - the following screen will appear;
 
 
Select the Part Source and Customer by highlighting your selection and pressing the ">" to select all press the ">>"
 
Depress OK and the followng Report will be displayed to the screen:
 
 
 
1.3.3. WO Schedule & WIP by Customer Report
Select the WO Schedule & WIP by Customer Report

The first screen that will appear is the Enter Value Screen, select How you want to Orient the WO Status on the Shop Floor
 
 
 
 
Select Horizontal and depress OK - the report will display the following information:
 
 
 
 
 
Select Verticle and depress OK - the report will display the following information: