SAP Knowledge Base Article - Public

2627623 - Query is not specified for List Report component - Online Report Designer / Canvas Report

Symptom

  • The message "Query is not specified for List Report component" is shown running a report in ORD
  • You transferred a report that is working in the source instance, but in the target instance it is not

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

Reproducing the Issue

Scenario 1: Query was not saved

  1. Go to Online Report Designer
  2. Create a new report
  3. Drag and drop a List Report component to the canvas
    drag component.png
  4. Do not add or edit the query of this component (i.e. the component will be empty)
  5. Click Preview/Run the report
  6. query is not.png

Scenario 2: Report transferring

  1. Transfer the report that is working in the source instance (e.g. Production) to a target instance (e.g. Test)
  2. Run the report in the test instance and see the error message "Query is not specified for List Report component"
  3. Edit the report
  4. Check that the component is empty, as if no query was available in the report
    no query.png

Cause

Scenario 1: The component inside the report has no query (i.e. it is empty)
Potential causes:

  • The report and the page were created but a component was never added
  • A component was added, but a query was never designed in it or was not saved properly
  • The report page had a component but it was deleted (accidentally or on purpose)

Scenario 2: Advanced Reporting was not working when the report was transferred

Resolution

Scenario 1: If you add a report component to the canvas but you do not edit or add a query to it, the report will be blank and this message is expected to be displayed.
To solve the issue please do as follows:

  1. Select the component
  2. On the left side click 'Edit Query'
  3. Add an existing query or create a new one

Also, the first time you create a query in a report component, you need to click on Return after saving the query and then clicking OK in the report component. This will attach the new query to the component. If you don't click on Return, even if you save the query, it will not get attached to the component and you will lose the query.

Please note that this extra step is only required the first time you are creating the query.

Scenario 2: Create a simple query in Advanced Reporting to check if it is working. If not, raise a ticket asking to fix the Advanced Reporting tool. Once this is fixed, please transfer the report again.

Keywords

ORD, Online, Report, Designer, Center, error, query, not specified, component, Canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-RCT , Report Centre , How To

Product

SAP SuccessFactors HXM Suite all versions