Hi I basically want to return all of the ticketid's that have a reportdate that was changed

ie...

TICKETID, REPORTDATE

a,17/04/15

a,17/04/15

a,19/02/14

b,12/02/15

b,12/02/15

b,12/02/15

c,01/01/15

c,01/02/15

should return

a,17/04/15

a,19/02/14

c,01/01/15

c,01/02/15

Kinda like the PREVIOUS() function in srss... example was to highlight the...

*bump* 🙂

preacha (4/13/2015)

---

Hi I'm trying to apply this to an SSRS report I am working on, which compares dates from previous rows. I previously just used LAG/LEAD but rows aren't...

Any ideas guys?

Hi I'm trying to apply this to an SSRS report I am working on, which compares dates from previous rows. I previously just used LAG/LEAD but rows aren't showing as...