Show TOC

Function documentationConfigure Crystal Reports Locate this document in the navigation structure

 

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.com at   Analytics   Business Intelligence   Crystal Reports (Designer).  

Prerequisites

  • You have installed SAP Crystal Reports 2011.

  • You have downloaded CRMIIConnector.jar to your local system from   Content Development   Tools and Archives  .

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   Crystal Reports 2011  .

  4. Choose   File   New   Blank Report  .

    The Database Expert screen appears.

  5. Choose   Create New Connection   JDBC (JNDI)  .

    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   Security Report   View Certificates   Install Certificate.   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   Tools   Internet Options   Content   Certificates   Other People.  

      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   http://hep.sap.com   NetWeaver   SAP NetWeaver Composition Environment   SAP NetWeaver Composition Environment 7.2   SAP Library   Administrator's Guide   Configuration of SAP NetWeaver CE   Configuration Tasks after Your System Landscape Is Set Up   Configuring Security   Configuring Network and Transport Layer Security   Configuring the Use of SSL on the AS Java   Configuring the SSL Key Pair and Trusted X.509 Certificates  .

  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.