Converting Desktop Reports

Custom Reports that have been created for the desktop version of Lucity 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:

Note: Reports must be posted to the web server in the \Reports directory in order to be available online. There you'll see sub-directories for \Equip\ and \Work\. Reports should be placed in the appropriate sub-directories.

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

   

3. If you are using SQL Server you will then be prompted to select a provider. Use the Microsoft OLE DB Provider for SQL Server as shown below.

   

4. Next, enter the Connection information.
   • For SQL Server, include the SQL Server Name, User ID, Password, and Database.

   

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

   

5. Once you create a connection you will need to individually (manually) map every table from the report one at a time.