Identifying multiple changes

[okh310]

I am creating a "schedule changes" report which flags any changes between last week's schedule and the current week's schedule.

I am creating a change flag for each column then creating a big if then statement to display the type of change.  So for example:

If ([date change flag]='Y') then ('Date Change')
else if ([Task Name Change flag]='Y') then ('Task Name Change')
else if ([WBS change flag]='Y') then ('WBS Change")
else ('Other Change')

The issue is if there are multiple changes, the if then statement will only pick up one.  I want to show "Date Change, Task Name Change, WBS Change" in the "type of change" column.  Anyone have any ideas on how to implement this?

Thanks!

[bdbits]

You could do that with repeaters.
See http://www.cognoise.com/index.php/topic,23693.0.html.