SQL Server Performance

Passing Multi-Value Parameters to Sub Reports

Discussion in 'SQL Server 2005 Reporting Services' started by dineshasanka, Jun 29, 2007.

  1. dineshasanka Moderator

    Is there way to pass multi-value parameters from one report to another.

    For example, If I select Several products from one report, I should be able to pass those values to report2, so that I can use IN command in report2

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    I think it is possible,http://www.sqlmag.com/Article/ArticleID/48596/sql_server_48596.html,http://msdn2.microsoft.com/en-us/library/bb508810(sql.90).aspx &http://msdn2.microsoft.com/EN-US/library/aa337292.aspx fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    Yes seems to be <br /><br /><br />=Join(Parameters! &lt<img src='/community/emoticons/emotion-4.gif' alt=';P' />arameterName&gt; .Value,", ") <br /> An expression that concatenates all the values in the array of a multivalued parameter of type String into one string.<br /> <br />=Split("Value1, Value2, Value3",",") <br /> Takes a string and creates an array of objects that can be used to pass to a subreport or drillthrough report expecting a multivalue parameter. <br /> <br /><br /><br />----------------------------------------<br />Contributing Editor, Writer & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><br />Visit my Blog at<br /<a target="_blank" href=http://dineshasanka.spaces.live.com/>http://dineshasanka.spaces.live.com/</a><br />

Share This Page