Skip to Content

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

Show Specific Groups Based on Record Criteria

SAP 14 / 2010

I am trying to make a report that will only return the Group if its records meet some sort of criteria.

So using my data below, and if the Job requires a variable called Criteria (this variable can be static and does not have to be a parameter), how do I get my Report to only return the Approriate Groups.

Example 1

Grouping = Job

Criteria: Saw, Tape Measure.

Returned Groups:

Job 1

Job 4

Example 2

Grouping = Job

Criteria: Screw Driver, Hammer

Returned Groups:

Job 1

Job 3

Example 2

Grouping = Job

Criteria: Pliers, Wrench

Returned Groups:

Job 2

Sample Database Table Looks Like This:

JOB_NUMBERTOOLS_REQUIRED
Job 1Hammer
Job 1Saw
Job 1Tape Measure
Job 1Screw Driver
Job 2Pliers
Job 2Wrench
Job 2Hammer
Job 3Screw Driver
Job 3Tape Measure
Job 3Hammer
Job 4Pliers
Job 4Saw
Job 4Tape Measure
Job 4Hammer
Former Member

Helpful Answer

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