SAP Knowledge Base Article - Public

3013709 - Sorting is not Working in the Report Journal

Symptom

When you click sorting in the report Journal, it's not working as expected.

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Search and open report Journal.
  4. Enter all the necessary values in the selections.
  5. Click Apply.
  6. In the report, click sorting for the column Posting Date which is located in the second column.

You will see that the documents are not sorted ascendingly or descendingly.

Cause

The behavior here is corret, the analysis pattern is internally based on a grid but not a table.

  1. All columns are sorted from left to right.
  2. The second column can only be sorted considering the order of the first column.

Resolution

In order to sort by your desired column, you can move the column to the first row.

Keywords

Journal; Sorting; 凭证日记账;排序. , KBA , SRD-FIN-ANA , Analytics Content , How To

Product

SAP Business ByDesign all versions