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 |
|
cwildeman
Starting Member
40 Posts |
 Posted - 2011-04-20 : 11:22:46
|
| Hi,I created a main report with three parameters: @startdate, @enddate and @HAC. The @startdate and @enddate paramters are based on the field called dbo.vEncounter.DischDate in a stored procedure. The @HAC is based on the dbo.HACList.HAC in the same stored procedure.I have a subreport based on a very similar stored procedure which also has the three paramters @startdate, @enddate and @HAC and these are based on the same fields listed above. I imbedded my subreport into the main report and want to run my main report with the paramaters and have my subreport provide the totals based on the main reports parameters.In the subreports properties, under parameters I tried a couple of combinations but cannot figure out how to link the two together. How do I link either parameters or fields from my main report to my subreport?Thanks,Chuck W |
|
|
|
|
|
Match parameters of a report to a subreport