Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to show group in Main rpt according to sub report group

Dear all,

I have created two sub reports which calculates different total jobs, I then added both of them into my main report by using a shared var formula.

The total of both reports is working fine however all the Reason Codes are being shown instead of showing only those which are matched with both sub reports (report is Grouped by Reason Code in all three reports Main-Subreport1-sub report 2).

For example in the main report it says

Reason Code:

1

2

3

4

5

6

7......

Where as in sub report the group reason code might be only 1,4 and 7.

What I am trying to do is to show only specific reason codes in the main report which are given in both sub reports.

Is it possible to select (or use a formula) which selects only exact match reason codes and displays it?

Please note: The main report has only Reason Code table and does not have any other filtration. All the filtration for reporting happens at the sub report level.

Many thanks

Regards

Jehanzeb

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question