You want to open large reports on Excel using the SAP Business ByDesign Add-In, however depending on the report size the Excel freeze or you receive an error message: The remote server returned an error (500).
SAP Business ByDesign; SAP Business ByDesign Excel Add-In
Reproducing the Issue
- Open Excel.
- Click on Log On button on SAP Business ByDesign Add-In ribbon.
- Click on Insert Report.
- Select your report on the list.
- You receive an error message.
The Business ByDesign Excel Add-In are not able to open large reports in one single list.
To open large reports on Excel you need to use the option Paging. This option split the reports on pages.
- Open Excel
- Click on Log On button on SAP Business ByDesign Add-In ribbon
- Click on Insert Report
- Select the check box Paging in the Insert Report screen
SAP Business ByDesign Excel Add-In; Large Reports , KBA , SRD-CC-OIN-XL , Excel Integration , How To