Can a report show results via image

[bharlow]

If I have a report that returns results for below goal, meets goal or exceeds goal is there a way to show the results as an image?

For example...

My report currently says

Store Period 1 Period 2 Period 3
100 B C A

where A=exceeds goal, B=meets goal, C=below goal

I would like the report to show a Red Circle for C, a Black Circle for B, and a Gold Star for A.

Any help would be greatly appreciated.

 

[ArtMiles]

You could go to the Format menu and select Conditional formatting from the disgn view of the report.

Art

 

[scalextric59]

If you don't mind using a rectangle/square, you can change its back color on Detail_Format based on your codes.