While exporting report error message is coming in Report Story

[satnaik18]

Hi Team,

While exporting the report and when click on Scope- All, error message are coming.

Error Message 1: Custom cells and client calculations won't be exported. Hidden rows and columns will be exported.

Error Message 2: Zero and null suppression (in charts and in table columns) will be ignored and those values will be exported with the rest of the data.

Can you please provide your inputs why this messages are coming.

Regards,

Satish Naik

[olusola88 · Accepted solution]

The messages you're encountering in SAP SuccessFactors Report Center during export (especially when Scope = All is selected) are informational warnings.

• Custom cells and client calculations won't be exported. Hidden rows and columns will be exported.

Cause & Explanation:

• Custom cells: These include calculated fields added manually in the report layout (outside of the underlying query or schema).

• Client calculations: These are totals or custom aggregates computed at the report viewer level, not from the query result.

• Hidden rows/columns: Even if some rows/columns are hidden in the UI (for presentation), they will be included in the export when exporting with Scope = All.

Behavior:

SAP exports only raw query data, not dynamic visual manipulations or custom formatting done on the interface.

• Zero and null suppression (in charts and in table columns) will be ignored and those values will be exported with the rest of the data.

Cause & Explanation:

• This means if you’ve suppressed 0 or null values (e.g., to hide empty rows in the UI), these will still be included in the exported file when exporting the full data.

• The export process bypasses UI suppression rules and retrieves everything from the underlying data.

Expected Behavior:

SuccessFactors exports complete dataset, including nulls and zeros, to preserve data integrity—especially for downstream use like Excel analysis.

Summary

• Do not treat these messages as errors – they are informational alerts.
• If you want to avoid exporting hidden rows/columns or suppressed values:

  • Use Scope: What I See instead of All.

I hope this helps.