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 |
|
liorlankri
Starting Member
17 Posts |
 Posted - 2006-03-13 : 07:34:33
|
| I have a SQL report that contain a Matrix (Example of Matrix fields) CallStatusType NumberOfCalls % HandlingOrg SubjectName SUBTOTALExplanation:"HandlingOrg" and "SubjectName" are Row Groups in the matrix (the result is dynamic according to the dataset)"CallStatus" is Column Group in the matrix (the result is dynamic according to the dataset - the matrix will create column for each StatusType) that contain 2 sub columns : "NumberOfCalls" - number of calls for each status type and "%" - The percent of calles in this status from total of all statuses.I also defined SUBTOTAL under the "SubjectName" groupExample for output: Open Close Watting UnClosedOrg1 Sub1 10 25% 10 25% 10 25% 10 25% Sub2 2 20% 4 40% 0 0% 4 40% Sub3 0 0% 0 0% 1 100% 0 0% SubTotal 12 45% 14 65% 11 125% 14 65%Org2 Sub1 ... Sub4 ...As you can see, my problem is in the SubTotal line!!It's correct to write 12 (total of 10+2) BUT!!! it's also operate totals of the percents (25% + 20% = 45%) And it's not good!!! I want it to be the percent of 12 from the total calls for Org1 (In this example I want it to be the percent of 12 from 51)1) Is there any option to handle value of this subTotal?2) If no, How can I at least to make this value not visibale only in the SubTotal cell of the percents? |
|
|
liorlankri
Starting Member
17 Posts |
Posted - 2006-03-14 : 06:01:05
|
| I will write me question again: It ws not written well!I have a SQL report that contain a Matrix (Example of Matrix fields) CallStatusType NumberOfCalls % HandlingOrg SubjectName SUBTOTALExplanation:"HandlingOrg" and "SubjectName" are Row Groups in the matrix (the result is dynamic according to the dataset)"CallStatus" is Column Group in the matrix (the result is dynamic according to the dataset - the matrix will create column for each StatusType) that contain 2 sub columns : "NumberOfCalls" - number of calls for each status type and "%" - The percent of calles in this status from total of all statuses.I also defined SUBTOTAL under the "SubjectName" groupExample for output: Open Close Watting UnClosedOrg1 Sub1 10 25% 10 25% 10 25% 10 25% Sub2 2 20% 4 40% 0 0% 4 40% Sub3 0 0% 0 0% 1 100% 0 0% SubTotal 12 45% 14 65% 11 125% 14 65%Org2 Sub1 ... Sub4 ...As you can see, my problem is in the SubTotal line!!It's correct to write 12 (total of 10+2) BUT!!! it's also operate totals of the percents (25% + 20% = 45%) And it's not good!!! I want it to be the percent of 12 from the total calls for Org1 (In this example I want it to be the percent of 12 from 51)1) Is there any option to handle value of this subTotal?2) If no, How can I at least to make this value not visibale only in the SubTotal cell of the percents? |
 |
|
|
|
|
|
Problem with Subtotal on SQL Report!!!