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

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

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

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

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.



View Complete Post

More Related Resource Links

SSRS 2008 group footer totals on a new page has a non-expected large cell height

SSRS 2008 group footer totals on a new page has a non-expected large cell height. When the group total is the first component on a new page, then this happens, but when it is part of the group on but not the first component, then it reverts to normal cell height. I have played with the advance settings now for hours, but cannot get this to work. Any ideas?  

Reporting Services 2008 - Repeating Headers when Headers are in a rectangle in header cell

Hello,I had the same problem as others where the tablix header will not repeat on multiple pages of the report.  I followed the instructions here http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx and it did not solve the problem.  After trying several scenarios, I found that it was not repeating because I have each header value in a rectangle which spans one column, rather than having each header value in it's own tablix column.For instance, if we have fields CompanyID and CompanyName on the report, the repeating headers work if I have them in separate columns like this:                              Tablix Column 1  |  Tablix Column 2Tablix Header row    Company ID        |  CompanyNameTablix Detail row      [CompanyID]      |  [CompanyName]It DOES NOT work when it is designed like this:                             Tablix Column 1Tablix Header Row   Company ID    Company Name  (tw

SSRS: Printing multiple values within one cell on a single row


Hi I'm new to SSRS and SQL in general.  I'm trying to publish a report that is easy to read, but I end up printing rows that are largely redundant. Consider the following tables:

Table 1: PersonID; Name; Age

1, Tom, 88
2, Stacey, 16

Table 2: PersonID; Color

1, Blue
1, Red
1, Green
2, Jade

 I would like a report that prints something like this:







c# 2008 Datagridview numericupdown cell not working properly. Odd layout behaviour


Hi all,

Francesco from Italy here, working with MS products since I was professionally born... that's like a century ago or something like that!

This is my 1st post in MSDN forums, so I hope it would be well accepted :)


I'm working with datagrdiview and custom numericupdown cell. I started from here


So, I downloaded the code attached there, opened the solution with Visual studio 2008, processed the automatic upgrade from 2005 to 2008 and started to play a bit with it.

It works pretty well, since I tried to use it the way you can see in this project


What do I do?

- I have a MDI form containing a simple child form 

- the child form has a splitcontainer, containing a treeview in the left panel

- the treeeview has 4 nodes and, clicking node 1 or 2, loads an usercontrol, containing datagridview with the custom numericoupdown object.

It looks great!

But... if you play a bit with the fields, you'll get an odd behaviour.

The first object I interact with works pretty well. The second object (hosted by the other usercontrol) has a funny behaviour... It simply doesn't work properly.

Passing Data to a Cell in Excel



I have a webpage that is created in Visual Studio 2008 and programmed in C#.

I have a web form that prompts the user to enter a value into a text box.  For now, I do not have any validation on that field (I will be adding that later).

I need to pass the value that the user has entered to cell C1 of the excel spreadsheet (user_info.xls).

I understand that using excel is not ideal, but unforutnately need to try to make this work with the excel spreadsheet.

I do not have any code for this yet, because I honestly do not know how to begin.

The action of poulating the excel spreadsheet will be intialized from the On Click event of a Submit button.

Any suggestions would be much appreciated.

Thank you in advance for your assistance,


SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

SSRS 2008 Graph Type?


Greetings -


I am required to plot the following graph in an SSRS report.


Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.


(Sorry for the diagram below, i tried to paste an image but it didn't work)

How can i add a textbox into a GridView Cell dynamically and how can i retrieve entred data

Hey, i think that the the subject can explain what i need, it's about adding a TextBox control with the code behind into a GridView, and also about how can i retrieve entered data after submitting, im using C#,Thanks.

SSRS 2008 date validation

Hello, Perhaps somone can shed some light on this. I want to make sure the user doesn't set a Startdate > EndDate  in a report. I've done some thing like this: Go to the Report Properties under the Report menu and place this code to the Code Tab. Public Function CheckDate(SDate as Date, EDate as Date) as Integer Dim msg as String msg = "" If (SDate > EDate) Then msg="Start Date should not be later than End Date" End If If msg <> "" Then MsgBox(msg, 16, "Parameter Validation Error") Err.Raise(6,Report) 'Raise an overflow End If End Function Then go to the Report Parameters and Add named it XXX with the datatype is string. Checked the Hidden and Allow blank value ckeckboxes. In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code. =CODE.CheckDate( .Value) But I'm having problems with the =CODE.CheckDate( .Value)  syntax. SSRS errors out. Any suggestions/insights? --joe

Dual values in Column chart Y axis in SSRS 2008

Hi,  Any one pls tell me how to show dual values in Column chart Y axis. Example: Im showing Total Number of clients in the Y axis of column chart My Requirement is In that Y axis column chart also  i want to show differently of Inactive clients from total number of clients. how to do this pls help me. Thanks in advance. TotalnumberOf clients :  1000 InActive Clients : 200 among TotalnumberofClients      

Line Divider i n Column chart in SSRS 2008

Hi,  Any one pls tel me how to do the single line divider in Column chart in SSRS 2008 example: --------- |               | |     20      | ---------- |       100 | |               | -------------------------------   i want to show the above example. Thanks in advance Regards, Abdul2010

Help Passing Multiple Parameters Via a URL in SSRS 2008

Hello Everyone, I'm totally and completely confused as to how to pass multiple paramters through a URL.  Book Online is absolutely no help because they do not offer any examples of passing multiple paramters within a URL.  Instead, I get confused over RENDER and COMMAND and what should be repeated where with each paramter and on and on and on. Here's my URL: javascript:void(window.open('http://sereporting01.wdig.com/ReportServer?%2fDOL%2fTEST%2fDisney+Sell-Through&rs:Command=Render&SiteName=Disney,InsertionType=300 x 250,Context=ROS','_blank','resizable=yes,toolbar=0,menubar=0')) What happens is that JavaScript opens a new window but I get a "Reporting Services Error".  I'm assuming it's because my URL parameters are not correct.  Can someone please just give me the correct syntax so that I can get on with my work? I'm editing this post to add - I'm also confused as to how paramters are supposed to be passed through to a report when default paramters are set up in the report which i'm trying to open with the URL.  Should I remove the default paramaters from the report or...what? Again, BOL offers no help on this issue and it just seems to generate more questions.  Thanks!!  

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

I need to set the value of a gridview cell during update.

Hi,  I've been reading the posts here and I'm not finding, or maybe just not understanding, the answer I need so here's my problem. I have a small gridview and the update works very well. The issue is I need to have one of the fields set to a value from my code either when the record is open for undating or when the update runs.  Here is my gridview and the datasource info:<asp:GridView ID="GridViewItemLog" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" CellPadding="3" DataKeyNames="LogID" DataSourceID="SqlDataSourceItemLogEntries" GridLines="Vertical" onrowdatabound="GridViewItemLog_RowDataBound" onrowupdating="GridViewItemLog_RowUpdating" onrowediting="GridViewItemLog_RowEditing"><AlternatingRowStyle BackColor="Gainsboro" /><Columns><asp:CommandField ButtonType="Image" CancelImageUrl="~/Resources/StopSmall.png" EditImageUrl="~/Resources/EditSmall.png" ShowEditButton="True" UpdateImageUrl="~/Resources/Save.png" /><asp:Boun

some of the cell value cant read from Excel

Hi all, Im reading some data from the excel file, using below code objBusy = new BusinessLogic();                string strFileName = FileUpload1.PostedFile.FileName;                string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;";                OleDbConnection objConn = new OleDbConnection(connectionString);                objConn.Open();                String strConString = "SELECT * FROM [Product1$]";                //where date = CDate('" + DateTime.Today.ToShortDateString() + "')";                OleDbCommand objCmdSelect = new OleDbCommand(strConString, objConn);                // Create new OleDbDataAdapter that is used to bui
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