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 |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-09-22 : 11:19:22
|
| I have a report that has a parameter that allows multiple selection so I have the standard where clause that works fine WHERE (tableA.Dept IN (@Dept))I created a sub-report using the exact same SQL code to create a chart version of the data. When I define the parameter, I select it from the list given. It works perfect if I select a single entry but the report does not display if more than one selection is made. I have tried both =Parameters!ClubArea.ValueAnd=Join(Parameters!Dept.Value,", ")Is that a possible limitation of using sub-reports? Not passing Arrays properly? I resolved by embedding into original tabular report but would prefer to use as a sub-report as the chart would be useful from multiple areas.John"The smoke monster is just the Others doing barbecue" |
|
|
|
|
|
Passing Multi-Value parameters to sub-reports?