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 |
|
maxyogesh2002
Starting Member
15 Posts |
 Posted - 2014-03-28 : 05:14:42
|
Here is an example of what my tablix/matrix looks like and some examples of what should happen. I have the parameters in the second report setup to accept values and in the main report I have just selected the field it should pass. Since it’s a matrix and grouped, I would think if you clicked a sub total row it would know what values relate to that row.click on below link for image:http://tinypic.com/view.php?pic=2dhwt9j&s=8Following examples,which define what should happen:1.When i click on cell B3(USA) it will pass Locations name i.e USA and Customer name i.e ABC as a parameter to sub report.2).When i click on cell B5 i.e Sub total, it will send both locations i.e. USA,Dubai and customer name i.e.abc as a parameter to Sub Report.3).When i click on cell B10 i.e Grand Total, it will send all Customer names with there respective locations as a parameters to the sub report.Thank You[url][/url][url][/url][url][/url][url][/url][url][/url]
[url][/url][url][/url][url][/url][url][/url][url][/url][url][/url][url][/url][url][/url][url][/url][url][/url] |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-07 : 15:07:27
|
| IN subreport, define the parameters you need. In main report, when you set up the link to the subreport, map the fields you want to the subreport parameters. |
 |
|
|
|
|
|
Passing Parameters from Main Report to Sub Report