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.