B
Barb
I am putting together a top management report by printing a view, for example
a Gantt chart, which includes various performance measures that I have
inserted (EVA measures, variances, percent complete, etc.). I would like to
be able to have it automatically color code the measures to easily indicate
to readers whether the performance is on the right track or not - for
example, print Variance at Completion (&[VAC]) in green if it is positive and
greater than 10% more than expected, in red if it is negative and more than
10% less than expected and in yellow if it is in between. I could simply
change the font on the report to corrspond to the actual values, but I am
trying to design a report that others could use effortlessly. Is there some
way to code this in? Any help would be appreciated.
a Gantt chart, which includes various performance measures that I have
inserted (EVA measures, variances, percent complete, etc.). I would like to
be able to have it automatically color code the measures to easily indicate
to readers whether the performance is on the right track or not - for
example, print Variance at Completion (&[VAC]) in green if it is positive and
greater than 10% more than expected, in red if it is negative and more than
10% less than expected and in yellow if it is in between. I could simply
change the font on the report to corrspond to the actual values, but I am
trying to design a report that others could use effortlessly. Is there some
way to code this in? Any help would be appreciated.