sharonsql2013 (2/17/2015)
I am trying to open a URL from a text box. It gives me an error to use an aggregate function...Here is the URL
IIF(Fields!Dept.value = "HR", "Http...",Nothing)
Can't use an aggregate function - First , because i need it to compare to all the values.
Since this text box is in the header , it doesn't allow me use a tablix too.
What other options do I have?
Is the Dept value a parameter that the user can choose on the report?
Example:
=IIF(Parameters!Dept.Value = "HR","http://www.travelguard.com","")