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 |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2008-11-05 : 13:39:07
|
| Hi,I have a report that need to have drill thru with multi value parameter. How do i accomplish this?eg. orig report have payment type as row group and ethnic as column group. payment type consist of Medical and Dental. ethnic consist of native and non native. subreport have type as row group and no column group. type consist of native medical, non native medical, native dental and non native dental. In the orig report, i went to navigation property and hit jump to report, in the parameters I put in type = fields!type.valueI click on the orig report and click on the drill thru, the subreport shows only the native medical. I want it to show native medical and non native medical when i click on medical in the orig report. Please help!!!!!!!!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-07 : 02:25:59
|
| have your drilldown reports query been written to handle multi value params? Use a csv parsing function and then join onto it to filter for passed multi values.Also check if you're passing = fields!type.value rather than = fields!type.value(0) on drilldown (by default when you double click (0) will appear in expression window) |
 |
|
|
|
|
|
How to pass multi value parameter