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!
You could do that with repeaters.
See http://www.cognoise.com/index.php/topic,23693.0.html (http://www.cognoise.com/index.php/topic,23693.0.html).