Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Using XML to pass Multi-Select parameters from SSRS to SQL Server RE: Using XML to pass Multi-Select parameters from SSRS to SQL Server

  • May 8, 2008 at 1:55 pm

    #812669

    lklein (5/8/2008)

    My dataset Parameter code is: =ReturnXML(Parameters!C.Value,"C","Customer","Customer_Number") - C being the name of the multivalue parameter which is defined as string the the parameter details.

    try changing that to =Code.ReturnXML(...)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2