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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2009-02-26 : 10:42:02
|
| Is it possible to use different datasets in seperate columns in a matrix? I have a matrix which uses a single dataset. I created a new dataset and dragged an item to a new column. It automatically placed SUM around the field and it displays correctly. Can I use the field without using SUM etc?Works:=Sum(Fields!PercentOccupancy.Value, "dsSurvey")Does not work:=(Fields!PercentOccupancy.Value, "dsSurvey") |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-02 : 13:03:41
|
| Nope you cant. you need to apply some kind of aggregation when you want to give scope parameter. perhaps, you may explain on what you're trying to achieve here so that we can suggest an alternative |
 |
|
|
|
|
|
different datasets in different columns in matrix