“Pixel Perfect” Financial Statements inside SAP ERP? Yes, with Crystal Reports
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.
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
Hi Juan - first you must be on enhancement package 5
If you are not, this will not work
Could you please check?
Regards,
Tammy
Hi Tammy,
I am on EHP6 FOR SAP ERP 6.0. Should this be enough?
Thank you
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
Hi Juan, I am having the same problem with Crystal Reports. Could you tell me if you Have found the solution?
I would submit an OSS support message on this
I haven't seen these errors
Regards,
Tammy
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)
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?
Did you configure the Crystal Reports option in the IMG? That needs to be turned on for you to see it.
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
Can I be able to access this crystal report from SAP Business Objects Launchpad (SAPBI 4.1) ?
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.
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
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
Thanks appreciate the feedback.