Converting Desktop Reports

Custom reports created for Lucity Desktop will NOT work in the Web application as is. To convert a report from a standard Lucity report to a Web report, complete the following steps:

1. Make a copy of the Desktop report and rename it.

   Example: Desktop report WOSumGrProb.rpt would be copied and renamed WOSumGrProbWeb.rpt for use in Lucity Web.

2. Open the new Web report in Crystal Reports.
3. Go to Database>>Set Datasource Location.
   • SQL Server Clients select OLE DB (ADO)>>Make New Connection.
   • Oracle Clients select Oracle Server.

   

4. If SQL Server is selected, the system will prompt the user to select a provider. Use the Microsoft OLE DB Provider for SQL Server, as shown below.

   

5. Next, enter the Connection Information.
   • For SQL Server, include the SQL Server Name, User ID, Password, and Database. The Database is specific to the report database with which it was created, such as GBAWork or GBAEquip.

   

   • For Oracle, include the Service, User ID, and Password.

   

   Once the connection has been created, individually (manually) map every table from the report, one table at a time.

   

6. To do this, click on a table in the top box (Current Data Source) and click the same table in the bottom box (Replace with). Then, click Update.  Repeat these steps for each table, even those listed under Subreports.  Note: "Properties" is not a table to be updated.

   

   After the report is converted for Lucity Web use, it must be loaded into the application.

7. In Lucity Web, open the module to which to add the report.
8. Click the on the toolbar.
9. To add a new report, click the Add button . The following dialog appears:

   

10. Enter the Report Name and Report Description.
11. In the Subdirectory that Report will be stored in field, enter the name of the folder to which you want to upload the report file.

    Note: Reports are automatically uploaded to the location specified in the Lucity Administration Tool's Path where Reports are stored setting, which may be found in the System > Settings > Documents tab.

    Note: If the folder name that the user enters does not exist, the system will create a folder with that name within the folder to which the reports are uploaded.

12. Under Choose File to Upload, click ... and select the .rpt file you would like to upload to the web server.

    Note: The name of the .rpt file being uploaded cannot match any other .rpt files.

13. Assign the report to a Group (optional).
14. Click Save.
    • When editing a report, the Save button is replaced with an Update button.