Show TOC

Function documentationConfigure Crystal Reports

 

You use this function to configure crystal reports to enable MII Connector which connects various MII queries through the Crystal Reports (Designer).

For more information on crystal reports, see the SAP Help Portal at http://help.sap.comInformation published on SAP site at Start of the navigation path Analytics Next navigation step Business Intelligence Next navigation step Crystal Reports (Designer). End of the navigation path

Prerequisites

  • You have installed SAP Crystal Reports 2011.

  • You have downloaded CRMIIConnector.jar to your local system from Start of the navigation path Content Development Next navigation step Tools and Archives End of the navigation path.

Activities

To configure the crystal report to MII Connector, do the following:

  1. Copy CRMIIConnector.jar to <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external.

  2. Goto <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java. Browse and open CRConfig.xml in a text editor.

    Include the path <CR_Install_Dir>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\CRMIIConnector.jar in the <Classpath> tag..

  3. Choose Start of the navigation path Start Next navigation step Crystal Reports 2011 End of the navigation path.

  4. Choose Start of the navigation path File Next navigation step New Next navigation step Blank Report End of the navigation path.

    The Database Expert screen appears.

  5. Choose Start of the navigation path Create New Connection Next navigation step JDBC (JNDI) End of the navigation path.

    The JDBC (JNDI) screen appears.

  6. Enter the following:

    • Connection URL: jdbc:sapxmii://<MIIServername>:<standard http port>/

      When the https connection is enabled, you must enter the https port of an MII server and include an additional parameter ?ssl=true. You must also import the server certificate available in your local system to jvm.

      To download the server certificate to your local system do the following:

      1. Open current MII instance in IE browser.

      2. Choose Start of the navigation path Security Report Next navigation step View Certificates Next navigation step Install Certificate. End of the navigation path to start the wizard.

      3. From the Certificate Import Wizard screen, choose Next.

      4. Choose Place all certificates in the following store and Browse.

        The Select Certificate Store appears.

      5. Select Other People from the list.

      6. Choose Next and Finish.

      7. On the IE, choose Start of the navigation path Tools Next navigation step Internet Options Next navigation step Content Next navigation step Certificates Next navigation step Other People. End of the navigation path

      8. Select the certificate and choose Export.

        A Certificate Export Wizard appears.

      9. Choose Next.

      10. Select the default export file format (.cer).

      11. Choose Next and browse to the location where you want to save.

      12. Enter a name, choose Next and Finish.

      To import the server certificate to JVM, call the following command in the windows command prompt:

      <CR_install_Dir>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jdk\jre6\bin\keytool.exe -import -trustcacerts -file C:\\MII\\servercertificate.cer -keystore <CR_install_Dir>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jdk\jre6\lib\security\cacerts -alias aliasname

    • Database Classname: com.sap.xmii.bobj.crystal.jdbc.CRMIIConnector

  7. Choose Next.

    The Connection Information screen appears.

  8. Enter the credentials in the following fields:

    • UserID

    • Password

    For details on SSL connections, see Start of the navigation path http://hep.sap.comInformation published on SAP site Next navigation step NetWeaver Next navigation step SAP NetWeaver Composition Environment Next navigation step SAP NetWeaver Composition Environment 7.2 Next navigation step SAP Library Next navigation step Administrator's Guide Next navigation step Configuration of SAP NetWeaver CE Next navigation step Configuration Tasks after Your System Landscape Is Set Up Next navigation step Configuring Security Next navigation step Configuring Network and Transport Layer Security Next navigation step Configuring the Use of SSL on the AS Java Next navigation step Configuring the SSL Key Pair and Trusted X.509 Certificates End of the navigation path.

  9. Choose Finish.

    The connection is added to MyConnections.

Note Note

<CR_Install_Dir> represents the directory where crystal reports are installed.

End of the note.