Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rklaytonmb
Partner - Creator
Partner - Creator

SAP Report Connector Result Does Not Show All Report Columns

Hi everybody,

I am using sap connetor to extract information from a custom report in SAP, but when executing instructions via script, although no error occurs, not all columns of the report are shown in the result of the statement

Script and result

SCRIPT.png

The interesting thing is that when using the Data tab all the columns are shown

DATA TAB.png

5 Replies
balabhaskarqlik

May be:

Initially Try to load with minimum no.of records in some columns and check the data.

Tomas_Sommergyll
Employee
Employee

Hi,

Have you tried using the check box "Auto Detect Column Width" (as can be seen above in your snippet) or even defining the columns manually?

Br

Tomas

rklaytonmb
Partner - Creator
Partner - Creator
Author

Tomas, thanks for the feedback.


I've never been able to use this option, nothing happens when I dial

rklaytonmb
Partner - Creator
Partner - Creator
Author

Dear Bhaskar

I ran with a minimum number of records, only 11 lines including header and line separation, and yet not all columns are displayed

rklaytonmb
Partner - Creator
Partner - Creator
Author

Gentlemen,


all tests performed so far had been run in quality environment, out of curiosity I performed the same procedure in production environment and ALL report colums were presented as expected


I will check with the SAP experts what the difference is between the two environments, but for now I will use the production environment to continue the activity


thank you all for the answers posted