Hi, 

I have a db table which having details as follows. 

Batch Id  status 

1              Running 

1             Finished 

2             Running 

3             New

4            Finished 

Report definition result should be:

Batch Id    Status 

1                 Running 

2             Running  

3               New

4              Finished

We are using this RD result as a source in UI table grid. 

Remove duplicate rows option checked, it is not helpful. Basically if batch Id is single record then show same status and if batch Id has 2 rows one with running and one with finished then we should show only one row with running status. Thanks in advance.