Crystal Reports Server Embedded 2008 V2 and V3

This section provides you with the information on how to configure the Crystal Reports Server Embedded 2008 V2 (or V3). This section also includes configuration steps for IIS 7 and ODBC, so that you can integrate Crystal Report Server Embedded 2008 V2 (or V3) with Civic Platform.

Topics

Configure Report Adapter

In the Crystal Report Service Adapter, a virtual directory, myreports, and a folder, reports, exist by default in the ASP files. The names are not case sensitive, so MyReports is the same as myreports.

  • myreports: A default virtual directory in IIS. You can change the name to whatever you prefer. Make sure you also change the name in the FileDirectory.asp and the XReport.aspx.cs.

  • reports: A default folder under the virtual directory myreports. This folder preserves the source report data. You can change the name to whatever you prefer. Make sure you also replace the existing name with the preferred one in the FileDirectory.asp and the XReport.aspx.cs.

To configure Report Adapter

  1. Get the cr2008_embedded_v2&v3.zip file from Accela Customer Support.

    You can call Customer Support at (888) 7-ACCELA, ext. 5 or (888) 722-2352 ext. 5. Customer Support is available Monday though Friday from 6:00 AM to 6:00 PM Pacific Daylight/Standard Time. You can also go to the Success Community website for assistance.

  2. Unzip the file and copy the contents into the virtual directory where that stores reports. For example, 
    D:\MyReports
    .

  3. Open the Central Configuration Manager after navigating to Start > All programs > BusinessObjects XI 3.1 > Crystal Reports Server Embedded 2008 and then do the following:

    1. Locate the Report Application Server 12 and then click Stop.

    2. Click Properties to pop up the Report Application Server 12 Properties window.

    3. Click the Parameters tab.

    4. Select Server from the Option Type drop-down list.

    5. Click Browse in the Report Directory section to select the virtual directory. In this example, it is 
      D:\MyReports
      .

    6. Click OK to save the changes and close the pop-up window.

    7. Click Start.

IIS7 Configuration

To configure IIS7

  1. Add ASP support, Basic Authentication, and Windows Authentication for IIS 7. To do this, follow the sub-steps below:

    1. Click Start > Control Panel > Programs > Turn Windows features on or off.

    2. In the Service Manager pop-up window, click Rolesfrom the list in the Connections panel.

    3. Click Add Role Services on the right hand side of the screen to add ASP and, if needed, Basic and Windows Authentications, to the Role Service list.

  2. Change the Advanced Settings for the Application Pool, DefaultAppPool.

    1. Start Internet Information Services (IIS) Manager console.

    2. Click Application Pools from the Connections panel and select DefaultAppPool from the Application Pools list.

    3. Click Advanced Settings link from the right hand side of the console.

    4. Set Enable 32-Bit applications to True.

    5. Set the Managed Pipeline Mode to Classic.

  3. Add Application for myreports.

    1. Start Internet Information Services (IIS) Manager console.

    2. Right-click Default Website and select Add Application from the pop-up menu.

    3. In the Add Application pop-up window, do the following:

      1. Select DefaultAppPool in the Application pool.
      2. Fill an application alias in the Alias field. Example: MyReports
      3. Select the virtual directory that created for storing reports in the Physical path. Example: D:\MyReports
    4. Click OK.
  4. Test the report adapter.
    1. Enter this URL into the address bar of an IE browser: http://localhost/MyReports/adapter/FileDirectory.asp


    2. Enter this URL into the address bar of an IE browser: http://localhost/myreports/adapter/XReport.aspx?reportName=/TEST/ACCELA/test.rpt

      Civic Platform displays The report executed successfully in the web browser.

      Note: If the test fails, try copying C:\Program Files\BusinessObjects\common\4.0\crystalreportviewers12 to C:\Inetpub\wwwroot\aspnet_client\system_web\2_0_50727\crystalreportviewers12, then run the test again.

ODBC Configuration

If using the 64-bit versions of Windows, as Report Commander runs as a 32-bit application, configure the 32-bit ODBC driver and DSN. To configure the alias as 32-bit DSN, run C:window\sysWOW64\odbcad32.exe to start the 32-bit ODBC Data Source Administrator, and add the DSN there for your Oracle or MSSQL.

Topics

Oracle

  1. Configure a connection between your machine and Oracle server. Follow the sub-steps below.
    1. Run the Oracle Net Configuration.
    2. Select Local Net Service Name Configuration and click Next.
    3. Select Add and click Next.
    4. Enter the Service Name. Service Name is the global database name for your database. Click Next.
    5. Select TCP as the Communication Protocol and click Next.
    6. Enter the Host Name. The default port (1521) is generally the correct value. If your DBA has configured Oracle to use a different port, use that instead. Click Next.

    7. If you see a message indicating the test was successful, click Next. Otherwise, click Back and consult with your DBA about the port value you should use.

    8. Enter the Net Service Name. Net Service Name is the name you give for this connection. Click Next to finish the connection configuration.

  2. Create an ODBC connection to your Oracle server.

    1. Start the ODBC Data Source Administrator.

    2. Click System DSN tab, and then click Add.

    3. On the Driver Select screen, choose the appropriate driver for your database.

    4. When you have chosen your driver, specify the Data Source Name - the name for the ODBC connection. Choose the TNS Service Name from the drop-down list. Specify the default User ID to use for the connection. Click Test Connection.

    5. If the connection is successful, you are ready to use the ODBC name for the connection to the Oracle server.

MS SQL Server

  1. Start the ODBC Data Source Administrator.
  2. Click System DSN tab, and then click Add.
  3. On the Driver Selection screen, select the appropriate driver for your database, and click Finish.

    A message displays asking you to choose which database server to connect to.

  4. Enter a name for the new connection, enter a short description, and select your SQL server from the drop-down list. Click Next.
  5. Provide valid user credentials. Click Next.
  6. Select the database to use for this connection. You can also decide to use the default database for the user account you are using to connect to the database. Click Next.
  7. Unselect the Change the language of SQL Server system messages to option, then click Finish.
  8. Click Test Data Source.

Configure the Crystal Reports Database Connection

Open the XReport.aspx.cs file in the /adapter folder from the cr2008_embedded_v2&v3.zip package. Enter the username and password that for the Oracle or SQL database connection configuration. The following image shows the code snippet.



Crystal Report Authentication Configuration

You can implement the authentication feature to open the Crystal Report.

Topics

Anonymous Access

To allow anonymous users to access crystal report

  1. Start the Internet Information Services (IIS) Manager, and click the Crystal Report website in the Connections panel.

  2. Click Authentication in the Security section. The Authentication list displays.

  3. Right-click the Anonymous Authentication item and select “Enable” from the pop-up menu.

  4. Access V360 Administration > Report Manager > Settings > Report Services.

  5. Open an existing report service or create a new one. Ensure you carefully enter the following information correctly in the Report Service Form:

    Report Name List URL: http://< Crystal Report server IP address>/myreports/adapter/FieldDirectory.asp
    Report Service URL: http://<Crystal Report server IP address>/myreports/adapter/XReport.aspx
    Report Service Type: Select Crystal Report.
    Authentication Method: Select Not Requited.


  6. Associate a report to the Report Service. Make sure the selected report service from the Process Servicedrop-down list is the one you created or edited in the previous step.

  7. Click the Parameters secondary tab to set up the data filters. When user tries to access the report, the data filters display in the pop-up window for the users to enter values sent to the report.

  8. Click Preview to preview the associated report.

Basic Authentication

You can set up Basic Authentication for your Crystal Report server.

To set up Basic Authentication

  1. Start the Internet Information Services (IIS) Manager, and expand the Crystal Report website and then click the adapter folder in the Connections panel.

  2. Click Authentication in the Security section. The Authentication list displays.

  3. Right-click the Basic Authentication item and select Enable.

  4. Click the Crystal Report website in the Connections panel, and then click IIS Manager Permissions from the Security section.

  5. Click Allow Useron the right hand side and add user that has permission to access the crystal reports.

  6. Access V360 Administration > Report Manager > Settings > Report Services.

  7. Open an existing report service or create a new one. Ensure that you enter the following information correctly in the Report Service Form:

    Report Name List URL http://< Crystal Report server IP address>/myreports/adapter/FieldDirectory.asp
    Report Service URL http://<Crystal Report server IP address>/myreports/adapter/XReport.aspx
    Report Service Type Select Crystal Report.
    Authentication Method Select Basic Authentication.
    User Name and Password the login name and the password of the Crystal Report Server.


  8. Associate a report to the Report Service. Set the Output Format. Make sure the selected report service from the Process Service drop-down list is the one you created or edited in the previous step.

  9. For non-default format, you must configure parameter if the report has defined parameters. Click the Parameters secondary tab to set up the data filters. When user tries to access the report, the data filters display in the pop-up window for the users to enter values sent to the report.

  10. Click Preview. The Authentication window displays as shown below. Enter your user name and password to display the associated report.

NT Authentication

You can set up NT Authentication for your Crystal Report Server.

To set up NT Authentication

  1. Start the Internet Information Services (IIS) Manager, and click the Crystal Report website in the Connections panel.

  2. Click Authentication in the Security section.

    The Authentication list displays.

  3. Right-click the Windows Authentication item and select Enable.

  4. Access V360 Administration > Report Manager > Settings > Report Services.

  5. Open an existing report service or create a new one. Ensure that you enter the following information correctly in the Report Service Form:

    Report Name List URL http://< Crystal Report server IP address>/myreports/adapter/FieldDirectory.asp
    Report Service URL http://<Crystal Report server IP address>/myreports/adapter/XReport.aspx
    Report Service Type Select Crystal Report.
    Authentication Method Select NT Authentication.
    User Name and Password Specify the domain account.


  6. Associate a report to the Report Service. Set the Output Format. Make sure the selected report service from the Process Servicedrop-down list is the one you created or edited in the previous step.

  7. For non-default format, you must configure a parameter if the report has defined parameters. Click the Parameters secondary tab to set up the data filters. When a user tries to access the report, the data filters display in the pop-up window for the users to enter values sent to the report.

  8. Click Preview. If the client user and the crystal report server are in the same domain, the report displays as shown below.



Troubleshooting - Invalid Export DLL or Export Format

If you experiences this error, “Invalid export DLL or export format," when exporting report, you can fix the issue by modifying the PATH environment variable for the computer.

  • If you are running Crystal Reports Server on a 32-bit computer, add the following to the end of the PATH variable value:

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

  • If you are running Crystal Reports Server on a 64-bit computer, add the following instead:

; C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

Restart your machine after editing the path variable so that the edits can take effect.