Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SallyWorc
Starting Member
5 Posts |
 Posted - 2012-04-24 : 04:37:05
|
| I have a report with a multi value parameter. When I run it on its own it runs fine with several values.However - when I run it as a subreport within another report only one value seems to be passed. I'm something of an SSRS novice so it could be the way I've set the subreport up (main report dataset column as parameter value).Any advice would be greatly appreciated |
|
|
SallyWorc
Starting Member
5 Posts |
Posted - 2012-04-24 : 04:41:17
|
| What I'd ideally like to do is get all values from a column in the main report into a string A,B,C etc and use it in the subreport SQL |
 |
|
|
SallyWorc
Starting Member
5 Posts |
Posted - 2012-04-24 : 05:59:28
|
| Well here's what I didCreated new multi valued internal parameter in main report picking up all IDs.Used the join function to put them in a text string which feeds into the subreport sql and Bob's your uncle! |
|
|
|
|
|
|
Multiple parameters not passing to subreport