Is there a way to loop over report parameters, and format them before passing them onto the query


  • Good morning all,


    I have a report which is getting its parameters from an page.  My ASP developer wants to send in simple values, such as the list 1,2,3,4 for a parameter.  However my report needs that list to look like [CD RSRC].[RSRC].&[1], [CD RSRC].[RSRC].&[2], [CD RSRC].[RSRC].&[3], [CD RSRC].[RSRC].&[4].


    Is there any way, on the report services side, to capture an incoming report parameter, parse it, loop over the parsed values and format them?


    I don't think there is, but I wanted to check before I go back to the developer and tell him he has to send in tuple lists.



    Tuesday, November 13, 2007 2:54 PM