.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS ..Problem with SubTotal and Calculating Percentage

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

I am having problem to calculating % on base of subtotal value in Matrix Report.
                  R1   %           R2    %         GrandTot  %          
A       1     20     40%          10  50%         30  34%
         2     30     60%          10  50%         40  66%
       Total  50     100%        20  100%      60  100%
B       1     20   33%            10    20%       30     30%
         2     10   16%           10    20%       20     20%
         3     30    51%          30    60%       50     50%
       Total  60   100%       50     100%   100 100%

The Bold % i nee

View Complete Post

More Related Resource Links

Data Mining solution - SSRS Problem

I have created a Data Mining - Time Series solution and I am getting proper results from SSAS(Mining Model prediction tab) & SQL Management Studio query. However when I try to create an report using SSRS, In the field where I am expecting the predicted value, I am getting "#Error" Any suggestions as why this is happening.

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

Calculating percentage of sceduled hours

 Hi all,       I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48         In excel file i have weekly wise total hours scheduled for each employee  and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports  in bound controls Result should be like this                    Scheduled Hrs      8/1/2010        8/8/2010       8/15/2010       8/22/2010                  Less than 24 hrs     5%                       5%                  5%                   5%        Between 24 and 48 hrs    5%         

calculating field in ssrs

I have a dataset which brings in sales, transcast, transbilling, and cogs in by group. I want to calculate net spend as a percent to sales and gross spend as a percent to sales. but can't seem to figure it out since sales, cost, transbilling, and cogs are all in one column(entry_type)...   my dataset looks like this   group | entry_type| year | jan | feb | mar | apr | may | etc...

A connection could not be made to the report server - Problem deploying an SSRS report from Business

I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

SSRS 2008 R2 Problem understanding View State Validation steps

Hi, Sorry, but I have some problem understanding this steps. Please help me to understand this.  Pasted from http://technet.microsoft.com/en-us/library/cc281307.aspx?lc=1033 How to Configure View State Validation To run a scale-out deployment on an NLB cluster, you must configure view state validation so that users can view interactive HTML reports. You must do this for the report server and for Report Manager. View state validation is controlled by the ASP.NET. By default, view state validation is enabled and uses the identity of the Web service to perform the validation. However, in an NLB cluster scenario, there are multiple service instances and web service identities that run on different computers. Because the service identity varies for each node, you cannot rely on a single process identity to perform the validation. To work around this issue, you can generate an arbitrary validation key to support view state validation, and then manually configure each report server node to use the same key. You can use any randomly generated hexadecimal sequence. The validation algorithm (such as SHA1) determines how long the hexadecimal sequence must be. Generate a validation key and decryption key by using the autogenerate functionality provided by the .NET Framework. (Well, how to generate Validation key using .Net Framework?) In the end, you must have a singl

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

SSRS Report Problem while Exporting into PDF

We are trying to generate a report in SSRS 2005 with Landscape  layout. The report if fine but when we export it into PDF format the result comes in 2 pages that is fine but there is an image in the footer which is only displaying in the last page of the report footer the text fileds are fine only image is not displaying in every page while exporting. Please guide.............

SSRS problem with passing multiple parameter values via URL %2c

Hi, I have a problem with passing multiple parameter values from one report (A) to another report (B).   For example I built a URL string in report (A) with the parameters like &Parameter1=1&Parameter1=2. As soon as I click on that URL the URL parameters look like &Parameter1=1%2c2 and the parameters don’t getting populated on report (B).   If I change the parameter in the URL to &Parameter1=1&Parameter1=2 and execute the URL manual the parameter on report (B) getting populated properly.   Is there a way to disable the coding like %2c (comma) or is there another solution for it?   Thanks

Add percentage subtotal to Matrix

I know this question has been asked many times but I can't seem to find a solution that works for me. I have a matrix as follows with two row groups (provider and hospital) and one column group (mix type). The matrix looks like this:     CKD ESRD PRIOR TOTAL Dr. Amin Arrowhead Hospital 2 3 1 6 Central 0 1 4 5 Westview 1 1 3 5 SUBTOTAL 3 5 8 16 Dr. Sacks Arrowhead Hospital 4 1 2 7 Central 2 2 4 8 Westview 0 4 1 5 SUBTOTAL 6 7 7 20 TOTAL 9 12 15 36 PCT 25% 33% 42% The PCT row is the subtotal row I'm trying to add to the matrix. I've tried adding a third row group and using the InScope function but I can not get it to produce the desired results below the subtotal row. Thanks in advance for any suggestions anyone can offer.                       

Barchart migiration problem when I move it from SSRS 2005 to SSRS 2008

Hi I am having a barchart report in ssrs 2005 which  is going to dynamically generate the bars depending on the input parameters for example if we give 15 as input it is going  to generate 15 bar on the chart and if we give 25 as input it is going to generate 25 bars on the report.Report is working well in ssrs 2005 but when I migrate it from ssrs 2005 to ssrs 2008 and run the report it is working well when i select 15 as input it is showing me 15 bar with the names on x-axis and y-axis.But when I select 25 as input it is generating bar chart  and I see multiples of 5 like(5,10,15,20)  bars are getting the names displayed on the y-axis and rest of the names are not displayed on chart.I was trying to expand the bar chart  and trying to see the different.When I expand report is spliting into two pages and I see multiples of 5 like(5,10,15,20) bars are getting the names displayed and rest of the names are not displayed.So can anyone suggest me any solution.   Thanks in Advance

Calculating a Percentage Value in SQL

Hey, I'm trying to calculate a percentage value in SQL. The following is my full stored procedure with sample data, if you run it you will see that I get one result which is grouped per Policy with a total for hrs_on and a total for hrs_hibernated, to calculate my percentage I need to use the following formula total_hrs_hibernated / total_hrs_on * 100 My problem is I can actually get the percentgae working fine if I do it for each individual record, if you run "Select * from #hibernatetemp" you will see my results with the percentage which are correct. I however need to group my results per policy and I'm not sure how to get the calculations to work correctly when I group by policy etc.  Would appreciate any help or advice on the method to do it as I may be over thinking this and trying to do it a more difficult way, Thanks    CREATE PROCEDURE [dbo].[SP_TEST_TEST2] AS /* Create temp table */ CREATE TABLE #hibernatetemp ( on_time datetime NULL, hibernate_time datetime NULL, startup_after_hibernate datetime NULL, off_time datetime NULL, sub_policy_name varchar(50), total_hrs_on decimal(18, 0), total_hrs_hibernated decimal(18, 0), hibernate_percentage decimal(18, 0) ) /** Insert Values into Temp Table from View, including Day/Night Rates*/ insert into #hibernatetemp (on_time, hibernate_time, startup_after_hi

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

requirePermission - please help - assembly problem (SSRS 2008)

*SSRS 2008 Hi All My report has custom code, the code references Oracle.DataAccess.dll for accessing an Oracle Database. The report works fine in the Designer, when I deploy it to the Report Server, I always get #Error in the column referencing the custom code. I caught the exception, the error is: ============================================== System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> System.Security.SecurityException: Request for ConfigurationPermission failed while attempting to access configuration section 'oracle.dataaccess.client'. To allow all callers to access the data for this section, set section attribute 'requirePermission' equal 'false' in the configuration file where this section is declared. ---> System.Security.SecurityException: Request for the permission of type 'System.Configuration.ConfigurationPermission, System.Configuration, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Configuration.BaseConfigurationRecord.CheckPermissionAllowed(String configKey, Boolean requirePermission, Boolean isTrustedWithoutAptca) The action that failed was: Demand The type of

MOSS and SSRS Integration Problem



Hi all,


We're currently having a great deal of difficulty getting our MOSS/SSRS integration configured.  In short, we're getting "A connection to the computer cannot be established." message in the Grant Database Access page of the Reporting Services Integration settings. 


A few more points:


We have two servers:

  • Server A:  Win2K3 EE SP2, MOSS 2007, SSRS Integration Components
  • Server B:  Win2K3 EE SP2, SQL Server 2005 SP2, MOSS database, SSRS, WSS 3.0, SSRS Integration Components

A user in IE on Server A can successfully browse to the ReportServer virtual directory on Server B.


Another "test" MOSS server has been configured separately and successfully against Server B, so it seems like there's something amiss with Server A.  The report server configuation tool shows all green.  There are no entries in the App or System log that appear related to this issue.  We've looked at KB's 871179 and 896861; no luck there.


We've tried both Windows Authentication and Trusted Connection with a number of different accounts, including a domain admin.  N

Use one cell`s value onto aother Cell to calculate percentage in SSRS 2008


Pls help me with my below issue.


I developed SSRS 2008 Matrix Report.

In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

How can i Reference that Row Values / Matrix subtotal Values Like that ?

Below is formate of my Matrix SSRS 2008 Report.

Jan Feb March

Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

Bangalore 135 192 197

Delhi 149 185 278

Total 284 377 485

How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2008 Matrix ?

I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean.

Please help me!!

Let me know if need information.



SSRS 2005 Heading Repeat problem.


I have a SSRS 2005 report using a table to display data.  I am using a parameter to change visibility of the first column depending upon the sort selected, so I am also using group headings to display the column headings (instead of a page heading) so that the column headings line up properly whether the first column is displayed or not.  The group heading lines are marked to repeat, and one contains a dataset field as heading information.  The table has multiple detail lines defined, and the last line contains a text field (memo field) which can contain LOTS of data.  If this field contains enough data that it takes an entire report page, the group heading is not displayed on this page, so all the column headings are gone for this page.  That is my problem.

There is a lot going on in this report, and the design, as it stands now, accomplishes all I need (dataset field in heading, optional column display with headings, proper sorting and breaking) with the exception of when this text field fills an entire page...in this case, the headings disappear.

Any thoughts on getting around this?  Thanks!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend