Question... I am wondering if anyone knows how to use an indicator in SSRS to determine the "red,yellow,green" from a value in the same report only run on a different day...? In other words... I have a report that is executed every day with a "total" value say 150,000. Is it possible to have an indicator that would show if the value is above, the same, or below the value from yesterday? I'm thinking if its possible it may have to be written as a VB script?

Any thoughts?