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 |
|
sunny_10
Yak Posting Veteran
72 Posts |
 Posted - 2012-12-19 : 02:50:47
|
| Hi I want to pass a value (I have a column ID in each row that i want to pass) from Main Report to Sub Report . Main Report has no parameter.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 03:13:55
|
| just add a new parameter in subreport. Call the call from main report for each row using jump to report or jump to url method and pass parameter values as Fields!ID.value from main report. The column ID should be included in dataset for main report------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sunny_10
Yak Posting Veteran
72 Posts |
Posted - 2012-12-19 : 03:56:03
|
| Hi I am displaying Sub-report on the main report . How i can pass value Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 03:59:22
|
| have you added the parameter to subreport rdl? if yes, you can pass parameter value inside subreport properties. set value as Fields!ID.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Pass Value from Main To SubReport