SAP Knowledge Base Article - Public

2618994 - How to Open Large Reports on SAP Business ByDesign Excel Add-In

Symptom

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).

Environment

SAP Business ByDesign; SAP Business ByDesign Excel Add-In

Reproducing the Issue

  1. Open Excel.
  2. Click on Log On button on SAP Business ByDesign Add-In ribbon.
  3. Click on Insert Report.
  4. Select your report on the list.
  5. You receive an error message.

Cause

The Business ByDesign Excel Add-In are not able to open large reports in one single list.

Resolution

To open large reports on Excel you need to use the option Paging. This option split the reports on pages.

  1. Open Excel
  2. Click on Log On button on SAP Business ByDesign Add-In ribbon
  3. Click on Insert Report
  4. Select the check box Paging in the Insert Report screen

Paging_Excel_AddIn_1.jpg

 

Paging_Excel_AddIn_2.jpg

Keywords

SAP Business ByDesign Excel Add-In; Large Reports , KBA , SRD-CC-OIN-XL , Excel Integration , How To

Product

SAP Business ByDesign all versions