Hi, scenario: a report with a table with some columns. The requirement is: select some records (more than one) on the first column and pass them to a report child (a new report is open). Is it possible? If yes how can I do? Many thanks for your help.

Is that possible to write T-SQL statement (another dataset) to select only needed column/s and data?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi, could you explain what you mean? Thanks

Hi fasttrack, Thanks for your question, to your requirement, there is no build-in feature to achieve it in report level, as we could only click one value on report to pass it to subreport. However, to work around the issue, I would recommend you make use of Multiple value parameter, you can have this multiple value parameter to show all the recoreds in the first column of your report, with this parameter, you can select whichever you like. Then pass this parameter's value to subreport. For more information about multiple value parameter passing to subreport, please see this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ae5ac615-1076-428d-9fcf-6c27e5fee1f0 Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks for your contribution, I checked the link, but I stiil not clear. Do you have any other example? Thanks

As URI said pass a key from parent to child report which identifies your records to be displayed Use this key to pull records from database(create a dataset at child report and having parameter which filters these records) and display it simple Spandan Buch