sql server reporting services:
Is it possible to parameterize a value within an expression in SRS 2000 report?

I would like the 10 in the expression below to be a user selectable parameter.

=iif(Fields!LastHeartbeat.Value < dateadd("n", -10, Now()), "Red", "Black")

Regards,

Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
mailto:pete.zerger@gmail.com

In report designer, from the Layout tab, select Report-->Report
Parameters. Click Add, set your parm name and prompt (e.g. Time) and
set the Data Type to INT. Change your expression to
=iif( Fields!LastHeartbeat.Value < dateadd("n", -
Parameters!Time.Value , Now()), "Red", "Black")
and you should be good to go.

Hello toolman,

That did the trick. Thanks very much.

Regards,

Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
mailto:pete.zerger@gmail.com


[quoted text, click to view]