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

    Question

  • Good morning all,

     

    I have a report which is getting its parameters from an ASP.net 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.

     

    Thanks,
    Kathryn

    Tuesday, November 13, 2007 2:54 PM

Answers