“Pixel Perfect” Financial Statements inside SAP ERP? Yes, with Crystal Reports

Follow RSS feed Like

3 Likes 4,161 Views 15 Comments

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

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

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

Change the layout to Crystal Reports

Export the report to Crystal

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

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:

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

If level equals 3 then underline

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

Sample final output:

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

Alert Moderator

15 Comments

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

Juan Carlos Lazaro

October 2, 2012 at 8:11 am

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
- Like(0)
- Tammy Powlas Post author
  
  October 2, 2012 at 9:57 am
  
  Hi Juan - first you must be on enhancement package 5
  
  If you are not, this will not work
  
  Could you please check?
  
  Regards,
  
  Tammy
  - Like(0)
  - Juan Carlos Lazaro
    
    October 2, 2012 at 1:22 pm
    
    Hi Tammy,
    
    I am on EHP6 FOR SAP ERP 6.0. Should this be enough?
    
    Thank you
    Like(0)
    - Tammy Powlas Post author
      
      October 2, 2012 at 7:08 pm
      
      Hi Juan - I am not on ehp 6 but that should be enough
      
      Please follow the configuration steps in this document on Service Marketplace https://websmp202.sap-ag.de/~sapidb/011000358700000592462010E (starts on page 4) - you will need your Service Marketplace logon
      
      You need to configure the Crystal option inside ECC.
      
      Regards,
      
      Tammy
      
      Like(0)
- Yury Murashka
  
  November 13, 2012 at 2:03 pm
  
  Hi Juan, I am having the same problem with Crystal Reports. Could you tell me if you Have found the solution?
  - Like(0)
  - Tammy Powlas Post author
    
    November 13, 2012 at 6:17 pm
    
    I would submit an OSS support message on this
    
    I haven't seen these errors
    
    Regards,
    
    Tammy
    Like(0)
    - Yury Murashka
      
      November 14, 2012 at 8:42 am
      
      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)
      
      Like(0)
Yury Murashka

November 13, 2012 at 11:42 am

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?
- Like(0)
- Tammy Powlas Post author
  
  November 13, 2012 at 1:34 pm
  
  Did you configure the Crystal Reports option in the IMG? That needs to be turned on for you to see it.
  - Like(0)
  - Yury Murashka
    
    November 13, 2012 at 1:52 pm
    
    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
    Like(0)
Former Member

September 15, 2016 at 8:31 pm

Can I be able to access this crystal report from SAP Business Objects Launchpad (SAPBI 4.1) ?
- Like(0)
- Tammy Powlas Post author
  
  September 15, 2016 at 9:37 pm
  
  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.
  - Like(0)
Chris Bethune

March 6, 2018 at 2:32 pm

Hi Tammy,

Would you happen to recall (or know) how the Crystal Report would get updated following a structural change to the ALV in SAP? I am assuming this is a matter of downloading the RPT from SAP, refreshing via Database Expert, making any design tweaks needed similar to what is described here and then re-uploading to SAP? Do you happen to be aware of anything special needed?

Kind Regards,

Chris
- Like(0)
- Tammy Powlas Post author
  
  March 6, 2018 at 2:41 pm
  
  Hi Chris - I replied but the system wouldn't let me post; this is my fourth time trying to post.
  
  It depends on the change; we have upgraded from SP5 to SP8 and no issues with Crystal/ALV
  - Like(0)
Chris Bethune

March 6, 2018 at 8:26 pm

Thanks appreciate the feedback.
- Like(0)

“Pixel Perfect” Financial Statements inside SAP ERP? Yes, with Crystal Reports

Assigned tags

Related Blog Posts

Related Questions