Hello,
I have a report of processes which either go into a Log table or an Error log table. They also have start / finish datetimes and a timespan value. So I want to report the process elapsed time or the error condition, depending on which table the process finished up in.
I then compare the elapsed time to the timespan and then show either a red flag (errored) green flag(worked within timespan) or yellow flag(worked but ran over allotted time) depending on what happened.
Is this possible?
I think it would be easy for me to get the info I want into a dataset using .net code but how do you link that in with SSRS?
Any help appreciated,
Thanks.
Try putting something like this into the background color property of the textbox you want to highlight:
=Switch(Fields!Error.Value = 1, "Red", Fields!timespan.Value > [AllottedTimeValue] , "Yellow", Fields!timespan.Value <= [AllottedTimeValue], "Green")
Hope this helps.
Jarret
sql
No comments:
Post a Comment