Linking 2 subreports to main
in [Reports]
|
Prev: series point value
Next: Odd behavior in SSRS 2005: different totals in dev version and deployed server version
From: DavidC on 9 Apr 2010 17:34 I have a SQL 2008 main report that prints checks and is based on a stored proc and it works fine by itself. I have subreports that I want to add to this main report but I cannot figure out how to "link" them. I was able to drag the subreport from my solution in VS 2008 and place it on the main report but when I preview it it does not print. What do I use to dynamically link a field value on the main report with a field value on the subreport? The parameters for the main report are checknumber start and stop but I want to link the subreport on the CheckID which will always be unique. Thanks. -- David
From: Bruce L-C [MVP] on 15 Apr 2010 13:32
If you have dragged and dropped the report onto the main one you now need to do a right mouse click on it, subreport properties, parameters. Bruce Loehle-Conger MVP SQL Server Reporting Services "DavidC" <dlchase(a)lifetimeinc.com> wrote in message news:529FBEF4-0679-4DA9-844B-B03C3FFD64F1(a)microsoft.com... > I have a SQL 2008 main report that prints checks and is based on a stored > proc and it works fine by itself. I have subreports that I want to add to > this main report but I cannot figure out how to "link" them. I was able > to > drag the subreport from my solution in VS 2008 and place it on the main > report but when I preview it it does not print. What do I use to > dynamically > link a field value on the main report with a field value on the subreport? > The parameters for the main report are checknumber start and stop but I > want > to link the subreport on the CheckID which will always be unique. Thanks. > > -- > David |