July 26, 2006 at 3:54 am
I am using RS 2005 to show up data in matrix Foramt returned from a Stored procedure.I am Having one of the column Group as Person name.With the person name as Column heading.I have three Sub Column
One is Elapsed Minutes Spent by the person and incurred time spent by the Person and ratio(Calculation of two columns).To show up Total of all the minutes for that particular Row.I Clicked right on the Group heading,Selected "Sub Total" But it is showing Wrong total.
I would be glad if some body shares the experience to use SubTotal in matrix
I want to give an Example
Service ID Person1 Person2 Person4 Total
10001 1 3 5 9
10003 3 4 6 13
10005 6 6 12
Total 4 13 17 34
But it is showing wrong total
Am i am missing sime thing here ,pls let me know
Your Suggestions are highly appreciated
I would be glad if some body shares the experience to use SubTotal in matrix
Thank you
Raj Deep.A
Thank you
Raj Deep.A
July 27, 2006 at 7:20 am
Raj,
I think that you are not handling null or missing values (probably in elapsed minutes column) correctly. Your matrix is not alligned. If you look carefuly you will see that employee 10005 has only four columns. So, if you align your matrix (notice 0 in the second column/third row) correctly in your stor proc I think that everything will be OK.
10001 1 3 5 9
10003 3 4 6 13
10005 0 6 6 12
Total 4 13 17 34
dmv
July 27, 2006 at 8:00 am
Actually,
I typed the matrix manually to show the matrix.there is no problem ,i am able to see the values if they are null and Zero.It was Ok as i came across anotehr solution to create a matrix for each and every aggregation.And the Aggregatrion in the column which we are seeing will be returned by stored procedure.
But I think i am Missing something On Grouping levels.
If i Keep all these things Aside, i need some more help on Format Option of Subtotals.my Stored procedure is returning values of time in Minutes,I want to convert them into Minutes at reporting level ,So i added Expression like
Format(Minutes\60,"00")& ":" Format(Minutes Mod 60,"00")
But SubTotal is not able to Catch this Expression which should sum up on this Expression Field .it has given the WARNING ALSO.
How and where should i ask the SubTotal to Display in Hours:Minutes Format.
help from any Means is highly appreciated
Thank you
RajDeep.A
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply