topic Re: SAP Report Connector Result Does Not Show All Report Columns in QlikView

SAP Report Connector Result Does Not Show All Report Columns

rklaytonmb — Mon, 26 Jan 2026 21:26:37 GMT

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

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

Re: SAP Report Connector Result Does Not Show All Report Columns

BalaBhaskar_Qlik — Wed, 04 Jul 2018 08:25:12 GMT

May be:

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

Re: SAP Report Connector Result Does Not Show All Report Columns

Tomas_Sommergyll — Wed, 04 Jul 2018 13:01:32 GMT

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?

Tomas

Re: SAP Report Connector Result Does Not Show All Report Columns

rklaytonmb — Wed, 04 Jul 2018 14:07:59 GMT

Tomas, thanks for the feedback.

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

Re: SAP Report Connector Result Does Not Show All Report Columns

rklaytonmb — Wed, 04 Jul 2018 17:17:52 GMT

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

Re: SAP Report Connector Result Does Not Show All Report Columns

rklaytonmb — Thu, 05 Jul 2018 13:57:56 GMT

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