Passing Multi-Value Parameters to Sub Reports | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Passing Multi-Value Parameters to Sub Reports

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/

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.
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 />
]]>