【Report Rows】WEB Report : Designing per row - Supplement

# Introduction #
I wrote a [post](https://qiita.com/Miki_Yokohata/items/59cbf742fffbdabcd944) regarding **Report Rows** before, and showed how **Criteria A** works with the example.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/d6dde7d2-651d-03de-d317-1cab6d48e90f.png)

This time I will see how **Criteria B** works.
I also see just these three rows `Sales Revenue (Domestic)`, `Sales Revenue (Foreign)` and `Other Revenue` for `Current Month - Actual` column only this time.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/7ff02a9e-bb7c-c303-f17d-7cde6c9a5660.png)

# Criteria A #
Let’s review **Criteria A** again with those rows in the column.

Open the Report Rows definition.
**Criteria A** for `Sales Revenue (Domestic)` row has **<<3500003..400040**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/37f8132f-f065-4ba5-d8e6-10e7c08d9738.png)
**Criteria A** for `Sales Revenue (Foreign)` row has **<<400041..410030**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/682206b8-34f5-3859-8e8e-b13d386cff3c.png)
**Criteria A** for `Other Revenue` row has **<<410031..450040**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/ac465705-9d03-f295-6822-cf57dfb7f8d0.png)

As we know, this **Criteria A** is applied to the filter **G\L Account Code** in the sub queries defined in the published query with this Report Rows definition.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/e8fbb2da-4a2e-f219-4de4-4ad4623e482d.png)
In case of the sub query which retunrs **Current Month - Actual** figure, **Criteria A** is used like this.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/e9fa4146-f1b1-58d3-7bc8-6fc0a51e13e4.png)

# Criteria B #
Let's see **Criteria B** here with the same rows and the same column mentioned above.
**Criteria A** is applied to the filter **G\L Account Code** in the sub queries.
I apply **Criteria B** to the filter **Business Partner Code** in the sub queries.

**Criteria B** for `Sales Revenue (Domestic)` row has **<<C20000,C30000,C40000**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/7880856a-1f28-4a71-d747-6fbdd2f48580.png)
**Criteria B** for `Sales Revenue (Foreign)` row has **<<C50000,C60000,C70000**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/39f6b7c6-3859-04b3-5bbe-ab14398b4f05.png)
**Criteria B** for `Other Revenue` row has **C99999**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/7836529f-d2ef-6404-f5e4-3098fb01a6a8.png)

Then the sub query which returns **Current Month - Actual** figure, add `Business Partner Code` filter and set **{%CriteriaB}** so that the filter values defined in the Report Rows definition will be passed here.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/8b76cf03-23aa-0aaf-5ad8-42b0e91ee085.png)

# Verification #
View the report and confirm the values for those rows in the column.
They are filtered with Business Partner Code given as well.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/286d88c6-b797-3866-66c9-074dd0de7ab7.png)

It was like this without **Criteria B**
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/5920fbec-4ca2-047d-0c92-c212bb6666db.png)

# Conclusion #
This is how criteria A, B, and C are applied to subqueries that return values ​​for columns.