Connecting SAP Crystal Report 2011/2013 with SAP R/3 ECC 6.0

Hello everyone this is a simple guide, to inform who ever has again some issues, on

how to connect SAP Crystal Report (2011 or 2013) with SAP R/3 ECC 6.0.

Prerequisites:

– SAP GUI Logon (installed on your client machine)

– SAP Crystal Reports (installed on your client machine or you can download it with the link at the end of this document)

1) FIRST STEP

(check SAPLOGON.INI & CREATE CONNECTION)

1- check where is the  saplogon.ini (in my case: %appdata%\SAP\Common\saplogon.ini)

2- open the saplogon.ini with notepad and set the UTF format and than save it replacing the original one if it was not in UTF format

3- (within Windows OS) go to : control panel>system>advanced>environment variables>system variables and create a new system variable with name “SAPLOGON_INI_FILE” and path “C:\Users\….\AppData\Roaming\SAP\Common\saplogon.ini” (in my case) ;

4- open SAP Crystal Reports 2013 (in my case) > VIEW > Preferred Viewing Locale > (here I set the language of the SAP GUI Logon which I use, in my case was in english so I set English)

5- (within SAP Crystal Reports 2013) > FILE > Log On or Off Server… > Create New Connection > SAP Table, Cluster, or Function > (now it shows me all the different SAP Systems that are also in the SAP GUI Logon, choose one of the SAP ECC system you connect usually through the SAP GUI Logon, set the client, username, password and then finish)

6- now you have the connection set (but you may not see the data within tables  on Data Dictionary DD tables if you try to import a table and then right click on a field of the table and click on Browse Data it will show you an empty box, so follow the SECOND STEP)

2) SECOND STEP

(fix SAP GATEWAY issue to view your data within the tables)

1- go to your ECC SYSTEM with SAP GUI Logon and go to Transaction Code: RZ11 (faster than RZ10)

2- check for value: gw/acl_mode

3- it is set to 1 by default for SAP System 730, set this parameter to 0

4- now you are able to see your data in crystal report through the connection made before

Note that:

– RZ10     value isn’t changed after System restart

– RZ11     value is reseted after System restart

3) THIRD STEP and LAST STEP

– navigate through the connection you made using tables on Data Dictionary DD section

– import some tables

– create your reports

Note that:

– if you can’t see the tables you are interested in, right click on Data Dictionary DD > options > and under TABLE NAME LIKE put your table name like %vbak% for example (show all the tables with vbak statements), now right click on Data Dictionary DD > refresh;

Remember to reset this filter because it will always display results based on your last filter;

Download 30 Day Trial SAP Crystal Reports 2013: SAP Crystal Reports 2013 30-Day Evaluation

Official Product Tutorials for SAP Crystal Reports 2011/2013: Official Product Tutorials – SAP Crystal Reports 2011 / 2013

Learn SAP Crystal Report: http://help.sap.com/businessobject/product_guides/cr2011/en/xi4_cr_usergde_en.pdf

Hope this would be helpful!

Best regards,

Denis Mullaraj.