November 28, 2006 at 8:06 am
I'm new to reportign services and am having difficulty creating a matrix for the first time.
I drag a matrix from the toolbox onto the report, I right-click the Rows, Edit Group, and set the Expresssion to the Fields I want as my rows, I do the same to create a Column Group.
In the Data cell I set the Expression to =SUM(FIelds!Amount.Value)
Now when I run the report I get the correct Rows and Columns, but the Sum cell has the sum of all rows and not just the sum of the intersection of the row and the column as I expect.
Please help, what am I missing.
December 1, 2006 at 8:00 am
This was removed by the editor as SPAM
December 1, 2006 at 10:04 am
Just drop simply row fiel,col. field and data field and it will give you total automatically.
If it's not working then could pleas explain bit more....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply