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 |
|
whhs
Starting Member
14 Posts |
 Posted - 2009-11-20 : 06:47:20
|
| Hello,I would like to build one MS RS Report.In this I have three sections.Each section has the same table/content.e.g. Report 1section 1: table x, field 1section 2; table y, field 1section 3; table z, field 1What is the best option to do?- Have one dataset with three queries in it,- Have three datasets and link these on the same field 1If the latter, how can best do this?Thx. |
|
|
DietSquirt
Starting Member
7 Posts |
Posted - 2009-11-25 : 11:53:29
|
| I don't know if this a "best practice", but multiple datasets can refer to the same parameter(s). So I have reports similar to the one you have described, with several tables or tables and a graph "linked" by the fact that the queries all use exactly the same parameter value(s). I picked this up a couple years ago from either a AppDev or Microsoft Books Online tutorial. |
 |
|
|
whhs
Starting Member
14 Posts |
Posted - 2009-11-27 : 07:52:13
|
| Thx. It works to have multiple datasets in one report! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-28 : 02:12:02
|
| isnt it possible to write query conditionally based on parameter? if yes, you can use single dataset for three cases using diffrent filters |
|
|
|
|
|
|
Report based on multiple queries