I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the given ID using CAML.
Can anyone tell me how can I do this ?
ID RequestType Status Date
1 AAA Open 12/11/2012 10:10
1 BBB OnHold 12/11/2012 10:20
1 BBB Resume 12/11/2012 10:30
1 BBB OnHold 12/11/2012 10:40
1 BBB Resume 12/11/2012 10:50
I need to read the data in the following order, onHold and Resume.