February 17, 2015 at 10:02 am
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?
February 18, 2015 at 3:15 pm
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","")
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply