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 |
|
ayadav0984
Starting Member
21 Posts |
 Posted - 2011-10-14 : 03:19:31
|
| i have two datasets in my report each having a aggregated sum() on the basis of month.What i require to do is join the two months together and then populate the calulated sum value of the second dataset. How can we do it...Please provide the solution.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 03:59:54
|
| You need to write a unified query to join source queries of current datasets and then use it as source for new dataset created. Then you can use that dataset in your reportIts not possible to join results at dataset level inside reports.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ayadav0984
Starting Member
21 Posts |
Posted - 2011-10-17 : 04:54:24
|
| thanks.. |
|
|
|
|
|
|
Multiple datasets joined with calculated fields