Joined: 07 Apr 2010
Location: United States
Online Status: Offline
Posts: 2
Topic: Select rows where data changes Posted: 07 Apr 2010 at 4:19am
I'm writing a report to track the changes (within a date range) to the department number to which employees are assigned. I want to group by empl id and select only the rows where the dept id changes from one row to the next(within each group). Is it possible to select only rows in a report where a certain field changes? If so, could someone please give me some suggestions on how to accomplish this? Thanks!
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 07 Apr 2010 at 4:38am
If you want to show both rows, you'll need to check the Suppress checkbox on the section and then take DBlank's answer one step further. Set the suppress formula to :
(next(field) <> field) or (previous(field) <> field)
This will "unsuppress" any rows that show the difference.
You may also have to consider adding some code to the formula above to ensure that you are not comparing the last record of one group with the first record of the next group.
My reports for example, use person_id=next(person_id)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
