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 |
|
rgandy
Starting Member
2 Posts |
 Posted - 2008-06-24 : 16:36:45
|
HeLLo Guys,I am creating a report in SQL Reporting services and I have 2 data sets and both are matrix table.The second table I try to use the second dataset. It always has this First(Fields!......Value, "Dataset2") and when I add the row it hasSum(Fields!estimatedPrice.value' "Dataset2")Confuse... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 02:11:25
|
| It will take Sum() as you're applying group on matrix, it doesnt make sense unless you apply some aggregate function over your field value which is what it does. |
 |
|
|
rgandy
Starting Member
2 Posts |
Posted - 2008-06-25 : 10:10:00
|
| I tried to remove those aggregate function but it doesn't work in that second matrix table.The dataset are identical I just have one different criteria <=40 in the first dataset and >=40 in the second one. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 13:53:50
|
quote:
Originally posted by rgandy
I tried to remove those aggregate function but it doesn't work in that second matrix table.The dataset are identical I just have one different criteria <=40 in the first dataset and >=40 in the second one.
are you not getting expected results with sum() |
|
|
|
|
|
|
Multiple Dataset in Matrix Report