Help with spacial report

[kacahco]

I have a table with the following columns:

ID AutoNumber, This is the primary key
Serie Text
Activity Text
Status Text
Duration Number

The table have the following data

ID,Serie,Activity,Status,Duration
1,DA,Cleaning,Working,3.1899414
2,DA,Cleaning,Working,0.8300781
3,DA,Cleaning,Working,3.8100586
4,DA,DD2101GXBTXXXI4009030IMODWL011,Working,3.9999
5,DA,DD2101GXBTXXXI4009030IMODWL011,Working,1.1700001
6,DA,DD2101GXBTXXXI4009030IMODWL011,Working,2.8301
7,DA,Cleaning,Working,0.39999962
8,DA,DD2101GXBTXXXI4009030IMODWL012,Working,2.7698994
9,DA,DD2101GXBTXXXI4009030IMODWL012,Working,5.2301006
10,DA,Cleaning,Working,0.39999962
11,DA,DD2101GXBTXXXI4009030IMODWL013,Working,1.5398998
12,DA,DD2101GXBTXXXI4009030IMODWL013,Working,6.4601
13,DA,Cleaning,Working,0.40000153
14,DA,DD2101GXBTXXXI4009030IMODWL014,Working,0.30989838
15,DA,DD2101GXBTXXXI4009030IMODWL014,Working,7.169998
16,DA,DD2101GXBTXXXI4009030IMODWL014,Working,0.52009964
17,DA,Cleaning,Working,6.6498985
18,DA,Cleaning,Working,0.83000183
19,DA,Cleaning,Working,0.35010147

I want to create a report that only return the following data:

ID,Serie,Activity,Status,Duration
3,DA,Cleaning,Working,3.8100586
6,DA,DD2101GXBTXXXI4009030IMODWL011,Working,2.8301
7,DA,Cleaning,Working,0.39999962
9,DA,DD2101GXBTXXXI4009030IMODWL012,Working,5.2301006
10,DA,Cleaning,Working,0.39999962
12,DA,DD2101GXBTXXXI4009030IMODWL013,Working,6.4601
13,DA,Cleaning,Working,0.40000153
16,DA,DD2101GXBTXXXI4009030IMODWL014,Working,0.52009964
19,DA,Cleaning,Working,0.35010147

In this example I take the last activity of the same consecutive activities. The ID 1, 2 and 3 have the same activity but I want only the last want (ID 3) and then ID 4, 5 and 6 with same activity and I want the last (ID 6). ID 7 don't have consecutive activity so need to appear in the report. Etc...
Any Idea?

 

[Mattster]

Based on the information you provided, use the sorting feature where you would sort first on
ID
and secondly on
Status
for the Status section create a footer and display the information you would like for that record in that section. Pretty sure this will work, but you will need both sorting sections in order to make this work.

 

[Mattster]

to access this, when you are in the report go
View > Sorting and Grouping