URl for Textbox

  • 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?

  • 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