Crystal Reports 9

Install the Crystal Report Server and configure it in RAS mode (or the equivalent) for Civic Platform to run Crystal Reports. Also configure the server allow anonymous access to the reports. Civic Platform enables the security parameters and user access to reports.

Installing the server installs an ASP page to the ISS Web Server, which enables linking the Crystal Reports Server with Civic Platform. This ASP page passes the log in information and parameters to the Crystal Enterprise Server when a user launches a report from Civic Platform.

  1. Get the files from C:\Accela\av.deploy\dist\reportadapter\crystal\cr9 (the C:\Accela portion of the navigation path varies depending on the installation directory). The av.deploy\dist\reportadapter portion must always be present for the installation folder.
  2. Copy the files to the reports directory. Example: E:\MyReports\
  3. Open Crystal Report RAS Configuration.
  4. Specify the Report File as the Crystal Report root.
  5. Open ISS Administration console and create a virtual directory under node Default Website with alias myreports.
  6. Click Next and specify the website directory as the actual content directory. Example: E:\MyReports
  7. After specifying the actual directory, click OK. Click Next, and then click Finish.
  8. Enter http://localhost/myreports/adapter/FileDirectory.asp?env=<aasite>&agency=<your agency> in the browser where <aasite> is your Civic Platform environment (example: supp) and <your agency> is your Civic Platform agency name (example: NOLA).
  9. Open the ODBC console then set up an ODBC connection.
  10. Open the Windows Registry and find the Data Source Name in ODBC.INI. Set the password in the ODBC.INI file.
  11. Open the file XReport.asp in the Adapter folder, then update the database connection credentials.


    Note: The Crystal Report Service Adapter has two folder names in the asp files. To change these folder names, make sure to also change them in FileDirectory.asp and XReport.asp.
    • myreports - The virtual directory is the hard coded website alias in ISS.
    • reports