looking for 3 last test result

LAU JUEN LIANG

March 25, 2019 08:45

Answered

Hi JetReport,

I would like to filter one of my table's data for example, for material M001 the Lab Testing date is 01/01/19, 01/02/19. 15/02/19, 28/02/19, 01/03/19.
I would like the jet report to able to help me filter and get the last 3 Testing date which will show 15/02/19,28/02/19 and 01/03/19.

Any idea how to do the filtering?

Date Votes

1 comment

0

Harry Lewis March 25, 2019 14:08

Hello -

The easiest way to accomplish this wold be to use a Grouping Report which lists your material number and then the last three testing dates for that specific material number.

Something like this:

Comment actions Permalink

Please sign in to leave a comment.