Installing Crystal Reports Server 2008 V1

If your agency uses Crystal Reports Server 2008 V1 for writing custom reports, complete the steps described in this section.

Topics

Installation Prerequisites

Table 1 describes the minimum software requirements necessary to install Crystal Reports Server 2008 V1.

After your system meets the minimum software requirements, verify that the .NET framework is present and verify the ASP.NET Version 2.0 support path.

Figure 1 illustrates how to verify the presence of the .NET framework. Figure 2 displays the support path for ASP.NET Version 2.0.

Table 1. Crystal Reports Server 2008 V1 Software Requirements
Windows 2000 or Windows 2003
.NET 2.0 (dotnetfx2.exe). You can download .NET 2.0 from Microsoft's download page. You can verify that the .NET framework resides on your machine by navigating to Add/Remove Windows Components > Application Server > ASP.NET.Figure 1 displays how to verify that the .NET framework is present.
.NET 2.0 SP1 (NetFx20SP1_x86.exe)
Internet Information Services (IIS) 6.0

Figure: Application Server Subcomponents



Figure: ASP.NET Version 2.0 Support



Installing Crystal Reports Server 2008 V1

To install the Crystal Reports Server

  1. Run the file /BusinessObjects/setup.exe.

  2. Navigate to the URL below and access the appropriate Crystal Reports Server 2008 V1 Installation Resource: http://www.sdn.sap.com/irj/boc/crystalreports-server.

  3. Select the language for the Setup program.

  4. Select an option for the database server install type and click Next.

    Install MySQL Database Server Select this option want to install MySQL, for example if you do not have a database server.
    Use an existing database server Select this option if you want to use an existing database server.
  5. Configure your Server Intelligence Agent and click Next.

  6. Select an application server configuration option and then click Next.

  7. Navigate to the Configure Tomcat page. Use the default port number.

  8. Click Next to start the installation.

Configuring Crystal Reports Server 2008 V1

After you install Crystal Reports Server 2008 V1, you must complete the necessary configuration steps described below.

To configure Crystal Reports Server 2008 V1

  1. Get the report adapter files. For example, the default file path is C:\Accela\av.deploy\dist\reportadaptor\crystal\cr2008. If you have trouble locating this file, note that the C:\Accela portion of the navigation path varies depending on your installation directory. The av.deploy\dist\reportadapter must always exist in whatever folder you selected for the installation.

  2. Copy the files to a directory where you store reports, such as E:\MyReports.

  3. Navigate to Start > All Programs > Crystal Reports Server 2008 > Crystal Reports Server 2008 and choose Java InfoView.

  4. On the Crystal Reports Server 2008 Login page, enter your user name and password.

  5. Click Log In to log in to the Crystal Reports 2008 system.

  6. Create a new folder, such as TEST, under Public Folders. Then, create a new folder, such as ACCELA, in the TEST folder.

    Crystal Reports Server 2008 V1 Java Infoview Document list.



  7. Add a report to Crystal Reports Server 2008. You can add a report using Crystal Developer or Crystal Report Server 2008 Java InfoView.

  8. Add the report by using Crystal Developer.

  9. Open the report
    test.rpt
    in the folder cr2008\testreport using Crystal Developer.
  10. Save the report to the folder you created.

  11. In Java InfoView, add the report
    test.rpt
    in the cr2008\testreport folder to Crystal Reports Server 2008.
  12. Look up Crystal Reports in the Crystal Reports Server 2008 V1 Java InfoView.

  13. Open the IIS Administration Console.

  14. Create a virtual directory under the Default Website node. Use the alias myreports.

  15. Click Next.

  16. Specify the website directory for the content, such as E:\MyReports\

  17. Click OK.

  18. Click Next.

  19. Click Finish.

  20. Ensure the web application MyReports uses the ASP.NET version 2.0.

  21. Ensure that the web application myreports properties has an Application name.

  22. Select a value from the Execute permissions drop-down list. Choose any value but “None.”

  23. Navigate to IIS Manager > Expand Websites > Expand Default Website > Expand aspnet_client > system_web.

  24. Explore the folders listed under aspnet_client. If the folder crystalreportviewers12 does not appear in any of the folders, copy the entire crystalreportviewer12 folder from C:\Program Files\Business Objects\Common\4.0\crystalreportviewers12 (Installation directory) to folder 2_0_50727.

  25. Navigate to E:\MyReports\adapter.

  26. Open the FileDirectory.aspx.cs.

  27. Update the Enterprise login info.

  28. Open up XReport.aspx.cs, update the Enterprise login info, the DB User ID\password as shown in the image below.

    FileDirectory.aspx.cs



    XReport.aspx.cs



  29. Enter the following URL in your browser’s address field, but substitute your environment name and your agency name. For example, where env=TEST, change TEST to your environment name, and where agency=ACCELA change ACCELA to your agency name.

    http://10.50.70.127/myreports/adapter/FileDirectory.aspx?env=TEST&agency=ACCELA

    An XML image displays the Report Name XML segment.

  30. Enter the following URL in your browser’s address field, but substitute your IP address and the navigation path to your report. For example, where 10.50.70.127, change this to your IP address, and where /TEST/ACCELA/test.rpt, use your report data.

    http://10.50.70.127/myreports/adapter/XReport.aspx?reportName=/TEST/ACCELA/test.rpt

    The Report Name XML Segment displays.

Integrating Crystal Reports Server 2008 V1 with Report Manager

You can integrate a Crystal Reports Server 2008 V1 report service with Report Manager. When you integrate a report service with Report Manager, the Environment and Agency field values must match the folder structure in the Enterprise system.

See Figure 3 which displays the Environment and Agency fields on the Report Service Form.

Figure: Report Manager Report Service Configuration



Configuring Open Database Connectivity

After you install, configure, and integrate Crystal Reports Server 2008 V1, you must complete the necessary Open Database Connectivity (ODBC) configuration.

To configure ODBC

  1. Open up the ODBC console and set up an ODBC connection.

    The ODBC Setup Console displays.

  2. Open up the Windows Registry.

  3. Find the Data Source Name in HKEY_LOCAL_MACHINE/ODBC/ODBC.INI.

  4. Set the Password.

    The Windows Registry displays.