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

Prerequisites

Crystal Reports Server 2008 V1 Minimum Software Requirements

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.

  • Windows 2000 or Windows 2003.
  • .NET 2.0 (dotnetfx2.exe). Download from Microsoft. Verify that the .NET framework resides on your machine by navigating to Add/Remove Windows Components > Application Server > ASP.NET.


  • .NET 2.0 SP1 (NetFx20SP1_x86.exe).
  • Internet Information Services (IIS) 6.0.

Figure: ASP.NET Version 2.0 Support



Install Crystal Reports Server 2008 V1

  1. Run the file /BusinessObjects/setup.exe.
  2. Navigate to the URL 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 then 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 the Server Intelligence Agent and click Next.
  6. Select an application server configuration option and then click Next.
  7. Go to the Configure Tomcat page. Use the default port number.
  8. Click Next to start the installation.

Configure Crystal Reports Server 2008 V1

  1. Get the report adapter files. Example: The default file path is C:\Accela\av.deploy\dist\reportadaptor\crystal\cr2008. The C:\Accela portion of the navigation path varies depending on your installation directory. The av.deploy\dist\reportadapter portion must be present in the folder selected for the installation.
  2. Copy the files to a reports directory. Example: E:\MyReports
  3. Go to Start > All Programs > Crystal Reports Server 2008 > Crystal Reports Server 2008 and select Java InfoView.
  4. On the Crystal Reports Server 2008 Login page, enter your credentials, then click Log In.
  5. Create a new folder under Public Folders (example: TEST). Then, create a new folder in the TEST folder (example: ACCELA).


  6. Add a report to Crystal Reports Server 2008, using Crystal Developer or Crystal Report Server 2008 Java InfoView.
  7. Add the report by using Crystal Developer.
  8. Open the report test.rpt in the folder cr2008\testreport using Crystal Developer.
  9. Save the report to the created folder.
  10. In Java InfoView, add the report test.rpt in the cr2008\testreport folder to Crystal Reports Server 2008.
  11. Look up Crystal Reports in the Crystal Reports Server 2008 V1 Java InfoView.
  12. Open the IIS Administration Console.
  13. Create a virtual directory under the Default Website node. Use the alias myreports.
  14. Click Next.
  15. Specify the website directory for the content. Example: E:\MyReports\
  16. Click OK.
  17. Click Next.
  18. Click Finish.
  19. Ensure the web application MyReports uses the ASP.NET version 2.0.
  20. Ensure that the web application myreports properties has an Application name.
  21. Select a value from the Execute permissions drop-down list (any value except None).
  22. Go to IIS Manager > Websites > Default Website > aspnet_client > system_web.
  23. 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 the installation directory (example: C:\Program Files\Business Objects\Common\4.0\crystalreportviewers12) to folder 2_0_50727.
  24. Go to E:\MyReports\adapter.
  25. Open FileDirectory.aspx.cs, then update the Enterprise login credentials.


  26. Open XReport.aspx.cs, then update the Enterprise login credentials.


  27. Enter this URL in a browser's address field, but with your environment name (TEST) and agency name (ACCELA):

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

  28. Enter this URL in a browser's address field, but use your IP address and the navigation path to your report (example: /TEST/ACCELA/test.rpt).

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

Integrate Crystal Reports Server 2008 V1 with Report Manager

When integrating a report service with Report Manager, the Environment and Agency field values must match the folder structure in the Enterprise system.

Figure: Report Manager Report Service Configuration



Configure Open Database Connectivity

  1. Open up the ODBC console and set up an ODBC connection.
  2. On the ODBC Setup Console, open up the Windows Registry.
  3. Find the Data Source Name in HKEY_LOCAL_MACHINE/ODBC/ODBC.INI.
  4. Set the Password.