Home Forums Reporting Services Reporting Services URl for Textbox RE: URl for Textbox

  • February 18, 2015 at 3:15 pm

    #1778494

    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","")