SAP Knowledge Base Article - Public

2440361 - "Generate" button is grayed out in edit mode for Multi Dataset Ad Hoc / Table Report

Symptom

  • "Generate" button is grayed out in edit mode for Multi Dataset Ad Hoc Report
  • Unable to Generate Multi Dataset Ad Hoc Report Online
  • How to generate Multi Dataset Ad Hoc report online?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

  • Ad Hoc Reporting: Multi Dataset reports
  • Report Center: Report - Table > Multi Dataset Ad Hoc Report

Reproducing the Issue

  1. Create a Multi Dataset Ad Hoc Report
  2. Edit the report
  3. Generate button is grayed out

Multidata set Ad Hoc 2.png

Cause

This is expected behavior as per product design.

Resolution

  • Multi Dataset reports are designed to export XLS / XLSX Workbooks with one or more worksheets.
  • Hence it CAN ONLYE BE run offline and exported to Excel format.
  • If there is any BIRT template associated with the Multi Dataset Ad Hoc Report, the export behaviour could be changed depending on the BIRT template's design
  • Please find the attached guide as well for more information.

Multi Data Set Ad Hoc 1.png

Keywords

Multi, Dataset, Report, reports, Ad, Hoc, Report, table, Center, greyed, disabled, unable, to, not, working, issue, error, Generate, button, online, run , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Suite all versions

Attachments

Cross Domain and Multi Data Set Reporting.ppt