.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

Subtotal in matrix detail

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi I have a report with a subtotal in the detail of the report, but I don't find the way to calculate this subtotal, this is the example of the report       credit debit Ending balance Group1 Openning balance 300 = detail1 0 25 275 = detail2 15 0 290 = detail3 30 0 320 Group1 total 300 45 25 320 So I nedd that the ending balance for row gives the subtotal, and at the end shows me the total of all the rows.   Hope that someone can help me Regards

View Complete Post

More Related Resource Links

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.                       

Master-Detail with the GridView, DetailsView and jQuery's ThickBox

One more article about grids from Matt Berseth. This time he shows how to create master-detail with the gridview, detailsview and jQuery's ThickBox. He writes:
So I thought I would check some of this out and along the way rebuild my Master-Detail with the GridView, DetailView and ModalPopup Controls and replace the ModalPopup with jQuery's ThickBox. I found it pretty interesting - read on to see how it went

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.

Master-Detail with the GridView, DetailView and jQuery's ThickBox

An example of using the jQuery ThickBox with ASP.NET's GridView and DetailView controls

Web Matrix + Windows Authentication


I'm curious if its possible to get windows auth working with asp.net webpages/webmatrix.

I've got it published to IIS with windows auth turned on and anonymous/forms/basic turned off.

I'm guessing the WebSecurity Helper probably won't work here but can you access User.Identity.Name etc?

Sorry for the newbie questions, I've only just started working with asp.net ^^,

Cutting Edge: Master-Detail Views with the ASP.NET Ajax Library


When you think of data-driven Web pages, most of the time what you really have in mind is a master-detail view of some cross-related data. Dino builds an example with ASP.NET AJAX 4 and jQuery.

Dino Esposito

MSDN Magazine January 2010

DirectX 8.0: Enhancing Real-Time Character Animation with Matrix Palette Skinning and Vertex Shaders


DirectX 8.0 allows the creation of smooth and realistic character movements that are more life-like than simple articulated structure animations. This is made possible by its improved support for vertex tweening and blended vertex deformations, also known as soft-skinning. After a brief history of the use of these techniques in DirectX, soft-skinning using the fixed function pipeline is discussed. This is followed by the use of matrix palettes from within vertex shaders to create a customized soft-skinning solution that takes advantage of the benefits of vertex shaders, such as hardware acceleration and custom lighting algorithms without the limitations of fixed-function solutions.

Benjamin Freidlin

MSDN Magazine June 2001

Passing Primary Key to User Control to Display Record Detail


I'm building a user control to display detail information on a parent record. The user control will be displayed via an Ajax Modal Popup. The user control works and is displayed when expected. The problem that I'm having is that I'm not able to pass in the primary key for the parent. The control is displayed via the _ItemCommand event of a Repeater. In the markup for the user control, I explicity set the ContactId to 0 to avoid an error when the control loads (its still underdevelopment, eventually that I'll check if the value is valid).

I was assuming that I could change the property in the _ItemCommand event, but obviously its not working.

In the Page_Load event this code successfully sets the ContactId property of the control. The _ItemCommand event appears to set the value. However when I set a test label on the user control to the Me.ContactId, its showing '0' as if it was never passed in.

        UserControlContactDetail.ContactId = "1462"
        test.Text = UserControlContactDetail.ContactId

    Protected Sub RepeaterDirectory_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles RepeaterDirectory.ItemCommand

Protected Sub RepeaterDirectory_ItemCommand(By

Super Complex Table/Matrix



I'm in a situation where I have to build a super complex table or rather matrix

This is how the table/matrix should look like: 




The complex thing is that everything is taken from a database.


I will try to explain the color sections one by one.


SERIE (Green area)

If we start with the top columns; SERIE 1, SERIE 2, SERIE 3

These values are coming from a table column value. If this column has the value 3 then I will need to print 3 table cells, just like in the image.




Then there is the outer left columns, that goes like this;

Behandlingsdag (meaning day of treatment)

Osplatin (100 mg/m2)

Leucovorin (x)

And so forth.


All these values are also coming from 3 different tables



One Column (Yellow area)

These cells are getting their values from a table. According to some true og false values.



1, 2, 3, 4 (Red area)

Then there is the table cells below the SERIES. These table cells goes like this

First there is a 1, then there are the tables cells 1 to 18 all below

Adding Totals to RDLC Matrix


I'm using a local RDLC report in VS2008 / .NET 3.5 which includes a Matrix.  It works fine and shows its corresponding Rows, Columns, and Data values as specified.

How can I add row totals / column totals in order to show sum of Data values both horizontally and vertically?

Master-Detail GridView in Single Page example with paging throws error

___http://www.java2s.com/Code/ASP/Data-Binding/MasterDetailGridViewinSinglePage.htmI followed example at the link above.When I enablind paging=true (by pagesize=3).and clicking to pages 2|3|4 etc and so;error occuringIndex was out of range. Must be non-negative and less than the size of the collection.at cs line :sourceProducts.SelectParameters[0].DefaultValue = gridMaster.DataKeys[e.Row.DataItemIndex].Value.ToString();got any idea?what should I make to fix this ? is this error  fixable ?thanks much.

Checking out Web Matrix

I dont recall seeing if webmatrix requires asp.net 4.0,  does it?  

group member detail view

hi, i have add member group to my detail view. but it does not show the member group correclty. it shows a lot duplicated members. and members that are not in a group it shows that they are in the group. i know you can not modify the wss_conten database. how can i still use group member in dataview?

Master/Detail with Northwind (SSMA) and ASP.NET

I'm trying this example: http://www.asp.net/data-access/tutorials/master-detail-filtering-with-a-dropdownlist-cs I got it to work before, like 6-months ago.  I'm coming back to this now and I can't seem to get the example working. Do I need to create a query in SSMS and then set up my Master/Detail views off of that?  It seems like the GridView is NOT linked to the DropDownList and it seems like there is no way to link the two Objects.  Any ideas as to what I could be doing wrong? Thanks everyone!!

Matrix (or table) like form: questions

Hi! I have to build a form to allow user to submit data; in some cases user should have to fill "matrix" forms, or table... I mean, I will have to define some columns, to be filled with data by user row by row (with the number of rows predefined too). So, I'm wondering if there's a smarter method to create a "matrix" like form than manually creating a grid with labels and textboxes. At first it seems that, at least visually speaking, datagrid could work; but i've always used it binded to some data source, so its population was automatic. Anyone knows if a datagrid could be created "blank", without any databinding, to be real-time populated? Or if there's a better solution? Thanks! ;)

sum of only selected column in matrix

i have a simple matrix where is display yearly sales: i want to show avg_1_year, avg_2_year, which uses the formula : yearly amount / number of month... for avg_1_year: 2010 amount / 8 (since we are in august).. customer       2010      2009    2008 2007  avg_1_year  avg_2_year  A                    500     200      200  200      500/8         (500+200)/20 i dont know how to get values of 2010 for avg_1_year and of 2010+2009 for avg_2_year

Problems with item detail popup with ie7 and ie8

I have a new installation of Sharepoint 2010 beta.  This is straight, out of the box, fresh install, no custom code at all.  On several browsers I cannot view several items within sharepoint.  But can view them with other browsers When I open the main root site with one of the offending browser I get an error triangle at the bottom left of the browser (details below).  on these browser I am unable to do basic functionality within the sharepoint site: The Page ribbon does not load Cannot view Detail popup for anything in the site. These browsers fail: XP Desktop - ie7.0.5730.13 XP Laptop - ie8.0.6001.18702 These browsers seem to work: Windows 7 laptop - ie8.0.7600.16385 Sharepoint Server - ie8.0.6001.18882 I've tried to update the XP Laptop.  I've run Windows update several time trying to get all the .net and browser updates I can.  But it's still not working. Am to conclude that: I MUST be on windows 7 to use Sharepoint 2010? I must be on a very specific version of ie8? is this even a client issue?  or is it more of a server component issue? Incidentally, Firefox 3.5 seems to work pretty well. Here is the error details I get : on the ie7 desktop I get an error message that reads : Char: 70125, Object expected Webpage error details on the ie8 laptop. User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.
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