Skip to Content

Yes you can run pixel perfect reports inside SAP using Crystal Reports.  This is something to consider for financial statements, for those that are not already in your SAP BW system, for example.

First you will need to follow the steps inside this blog (being on enhancement package 5).

Then configure your financial statement version via OB58 transaction inside ECC/ERP

/wp-content/uploads/2012/06/1fig_109703.jpg

Run the financial statement report in ALV mode so you can see the data – here I am using transaction S_ALR_87012284:

/wp-content/uploads/2012/06/10fig_109713.jpg

Note the first column hierarchy level – this will be needed for formatting Crystal Reports

/wp-content/uploads/2012/06/3fig_109705.jpg

Change the layout to Crystal Reports

Export the report to Crystal

/wp-content/uploads/2012/06/4fig_109706.jpg

Open up Crystal Reports 2011 (you will need a Crystal Reports Designer license)

/wp-content/uploads/2012/06/5fig_109707.jpg

The field names in Field Explorer took some getting used to.  TLEVEL is the hierarchy level while REPVAL is the dollar amount

I put in some formulas to control the fonts and the underlines:

/wp-content/uploads/2012/06/6fig_109708.jpg

The formula above displays if level is less than 4 then bold the font

/wp-content/uploads/2012/06/7fig_109709.jpg

If level equals 3 then underline

After making formatting changes, save the report in Crystal and import inside SAP:

/wp-content/uploads/2012/06/8fig_109710.jpg

Sample final output:

/wp-content/uploads/2012/06/9fig_109711.jpg

You can save this to a variant so it the report will automatically run in Crystal Reports, inside your ECC / ERP system.

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Juan Carlos Lazaro

    Hi Tammy,

    I am trying to follow the steps you mention in this post, but I cannot the Crystal Reports option in the View menu.

    I have gone through all the steps in the different posts, but I am not able to use Crystal as the output of the ALV.

    Do you know if I am missing something?

    Thanks in advance

    (0) 
    1. Tammy Powlas Post author

      Hi Juan – first you must be on enhancement package 5

      If you are not, this will not work

      Could you please check?

      Regards,

      Tammy

      (0) 
        1. Yury Murashka

          Thank you, Tammy!

          Could you let me know the result.

          The information that I have posted is the result of executing test report SALV_BOQT_CHECK_CRYSTAL.

          Also when running the WebDynpo test report SALV_WD_DEMO_EXTENDED and picking up Crystal Reports in ALV , I am getting the following SAP ACF Trace:

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|m_control is NULL|

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|Second roundtrip backend ignores error case! Calling methods!|HRESULT=-2147467259(Unspecified error)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|Firing SAPError|

          ERRO|20121114144744|WD020C_224|CAcfControl::InvokeActiveX|Invoke of setstreamfailed|HRESULT=-2147352567(Exception occurred.)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144744|WD020C_224|CAcfControl::InvokeActiveX|Invoke of setstreamfailed|HRESULT=-2147352567(Exception occurred.)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|m_control is NULL|

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|getCrystalInterface|HRESULT=-2147467259(Unspecified error)

          ERRO|20121114144744|WD020C_224|CAcfControl::InvokeActiveX|Invoke of setstreamfailed|HRESULT=-2147352567(Exception occurred.)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|m_control is NULL|

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|getCrystalInterface|HRESULT=-2147467259(Unspecified error)

          ERRO|20121114144744|WD020C_224|CAcfControl::InvokeActiveX|Invoke of process_streamfailed|HRESULT=-2147352567(Exception occurred.)

          ERRO|20121114144744|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144745|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144745|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          ERRO|20121114144745|WD020C_224|CCrystalActiveX::|CoCreateInstance with {2F848BE4-8329-4C09-8613-FC9DFF55C10F}|HRESULT=-2147221164(Class not registered)

          (0) 
  2. Yury Murashka

    Hello ,

    I am having the same problem as Juan.

    I am on the Netweaver 7.3. I have done the Configuration, as it needs to be done. I have also run the BCALV_TEST_FULLSCREEN_STATUS report to see if that was a problem of my application.

    But unfortunatelly the Crystal Reports option is disabled in my ALV View…. 🙁

    Please help!

    Could you please answer if you have found the problem?

    (0) 
      1. Yury Murashka

        I sure did everything according to this document

        https://websmp202.sap-ag.de/~sapidb/011000358700000592462010E.

        After executing report SALV_BOQT_CHECK_CRYSTAL I got following information:

        ——————————————————————————————————————————————————————————————-

        Summary:

        CR Adapter installed                     –             CrystalReportViewer.dll

        WD: CR enabled                           X

        WD: ACF installed                        -(?)          SAPAcf.dll

        SAP GUI: CR enabled                      X

        SAP GUI: control installed               -(?)          SAPCrystal.dll

        ——————————————————————————————————————————————————————————————-

        Details:

        WD:

        Central Switch Enabled (IMG):            X             cl_salv_wd_admin=>get_value( ‘CR_ENABLE’ )

        GUI:

        Central Switch Enabled (IMG):            X             cl_salv_gzt_admin=>get_flag( cl_salv_gzt_admin=>c_param-cr_enabled )

        GUI_PARAMS – Bridge:                     (undefined)   cl_alv_z_params=>get_parameter( … )

        GUI_PARAMS – Suppress Install Check:     –             cl_alv_z_params=>get_parameter( … )

        GUI Control – Version (assembly):        0.0.0.0       cl_gui_crystalviewer=>version_check( … )

        => Params API – Bridge enabled:          X             cl_alv_z_params=>is_bridge_enabled( )

        => Params API – CR enabled               X             cl_alv_z_params=>is_crystal_enabled( )

        => Params API – CR Installed:            –             cl_alv_z_params=>is_crystal_installed( )

        => Internal API – CR active (menu):      X             cl_alv_check_third_party=>is_active( … )

        BO_PARAMS:

        CR switch for sy-uname:                                cl_salv_boq_params=>get_parameter( param_name = … )

        CR switch user independent:                            cl_salv_boq_params=>get_parameter( user = space param_name = … )

        => Params API – Hard Enabled:            –             cl_salv_boq_params=>is_crystal_enabled_hard( )

        => Params API – Hard Disabled:           –             cl_salv_boq_params=>is_crystal_disabled_hard( )

        Crystal client dll versions

        File                                     Version       Path

        CrystalReportGenerator.dll                             C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\Embedded_Analytics\

        CrystalReportViewer.dll                                C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\Embedded_Analytics\

        SAPCrystal.dll                                         C:\Program Files\Common Files\SAP SHARED\

        SAPAcf.dll                                             C:\Program Files\Common Files\SAP SHARED\

        Ios_Acf.dll                                            C:\Program Files\Common Files\SAP SHARED\

        Registry

        Value                                    Key                                                                           Data

        Assembly                                 SOFTWARE\Classes\CLSID\{2F848BE4-8329-4C09-8613-FC9DFF55C10F}\InprocServer32

        PrintJobLimit                            SOFTWARE\Business Objects\Suite 12.0\Report Application Server\InprocServer

        PrintJobLimit                            SOFTWARE\Business Objects\Suite 12.0\Report Application Server\Server

        Release/system/client/user               731/NW1/800/YVAINILOVICH

        (0) 
    1. Tammy Powlas Post author

      No, this is only inside SAP.  You could export the Crystal Report, save data with SAP and then upload to the BI launchpad, but then the report is no longer “real-time”.  The ABAP ALV is a data source.

      (0) 

Leave a Reply