19 comments

  1. Thanks. Very helpful.

    byron Beantwoorden

  2. what if X and Y are the same?

    eric Beantwoorden

  3. got it, the parameter default values need to be from a different data set then the query itself

    eric Beantwoorden

  4. My query is:
    SELECT HumanResources.vEmployee.LastName, HumanResources.vEmployee.JobTitle, HumanResources.vEmployee.CountryRegionName,
    HumanResources.Employee.HireDate
    FROM HumanResources.Employee INNER JOIN
    HumanResources.vEmployee ON HumanResources.Employee.EmployeeID = HumanResources.vEmployee.EmployeeID
    WHERE (HumanResources.vEmployee.JobTitle IN (@JobTitles))

    Basically I want to see a dropdown box with the list of JobTitles so I can filter based on the selected values. So what i did was, in “Report Parameters” I checked “Multi-value” and under Available Values I chose JobTitle…. but I am still having the same error,,,, does anyone know what i have to do?

    iggydarsa at gmail dot com Beantwoorden

  5. Was very useful…
    Simple + concise answer …
    Thanks

    Santosh Mahajan Beantwoorden

  6. nice was useful ty

    pedro abrahan Beantwoorden

  7. I have the same problem of iggydarsa someone can ahelp me?

    iggydarsa Beantwoorden

  8. Thank you very much. You just saved me a lot of time and effort! 🙂

    Ryan Beantwoorden

  9. Thanks! Just what I needed!

    JoelB Beantwoorden

  10. your answer really helped me

    thanku Beantwoorden

  11. Excelente!!

    Mister Beantwoorden

  12. Definitely helpful. Thanks.

    Marcos Beantwoorden

  13. Perfect, thanks!

    essgee Beantwoorden

  14. very helpful, thanks !

    Goran D Beantwoorden

  15. Thank you.

    Gil Beantwoorden

  16. This didn’t help at all.
    I have the second parameter based on a query of data – completely different from the first parameter which is based on non-query values. Is there any other solution?

    Keith H. Beantwoorden

  17. Thanks, very helpful.

    Joaquin Beantwoorden

  18. Hi,
    If you same problem error. you can use the another data set (Ex:field name: accountname, accountid)
    assign the values to the first data set parameter which you created inside the parameter.

    Open the parameter tab go for text datatype — choose the multiple allow option.keep as visible button and click for available option .. inside the available option select the get the values from a query — select Dataset2
    Value field: accountname,label feild:accountname..ok.

    you get the parameter as all the account names …

    Gengiti.Sainathyadav Beantwoorden

  19. thanks a lot for your help

    Amruta Beantwoorden