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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2009-05-01 : 08:49:44
|
| I have a matrix report(dashboard report), with appointment counts for each day. If we click on the appointment counts, all the details should show up. I have created this detailed report. Now I am trying to find out how I can link this detailed report(subreport) to the main report. The following are the parameters of the main report and the detailed report(subreport):1. The main report has startdate(datetime),enddate(datetime) and doctor-UNIQUEIDENTIFIER datatype as parameter.2. detailed report has startdate(datetime), enddate(datetime) and doctor-varchar datatype as parameters. Please let me know how I can do this. Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-01 : 10:41:14
|
| Look at the textbox properties for appointment counts. You should see an action propety where you can set it to call the other report and pass parameters.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Trybbe
Starting Member
27 Posts |
Posted - 2009-05-08 : 03:48:37
|
| Right click on appointment counts, go to properties, on the navigation tab click on jump to report, specify the report(subreport) from the drop down next to it click on parameters button then specify the parameters to be passed on to the sub report------------------------------I am not, I am becoming |
|
|
|
|
|
|
subreport question