0

filter 7 days and 28 days data

Hi JetReport!

Here is my question. I got a "age" column for my raw data, which record the data is for 7days or 28days.

Item No.  Age   Quantity
A               7         100
A               7         200
A             28         200
A             28         100
A             28         150
B             7           100
B             7           50
B             7           75
C             28         100
C             28         100
C             28         50
D             7           20
D             28         30

Anyway for me to write a jetreport filter, to filter out the data which contain "7 days and 28 days", in the example, will show the row data A and D only.Because A and D containt both 7 days and 28 days result.

If there's no 7 days results,  or if there's no 28 Days data ignore the data. 

Anyway to write the filter????

       

12 comments

Please sign in to leave a comment.