Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 13th, 2006, 08:11 AM
Authorized User
 
Join Date: Oct 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with Subtotal on SQL Report!!!

I have a SQL report that contain a Matrix (Example of Matrix fields)

                                 CallStatusType
                          NumberOfCalls %

HandlingOrg SubjectName
              SUBTOTAL

Explanation:
"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" group

Example for output:

                   Open Close Watting UnClosed

Org1 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?








Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal yogeshyl SQL Language 1 July 15th, 2008 02:16 PM
Crystal Report Problem with SQL AnushkaKRajasingha C# 0 October 8th, 2007 11:53 PM
Matrix SubTotal Problem ramsk Reporting Services 0 November 20th, 2006 08:27 PM
QUERY SUBTOTAL NEWAGE Access 2 November 8th, 2006 11:59 AM
percent of subtotal mtlpp Excel VBA 0 May 14th, 2005 10:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.