Welcome :Guest
Congratulations!!!

### Subtotal in matrix detail

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

### SSRS ..Problem with SubTotal and Calculating Percentage

Group,

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

### 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 ^^,

### 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

### Super Complex Table/Matrix

Hi

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:

http://yfrog.com/f/0seq7j/

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.

MEDICINE NAMES (Blue area)

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?

### Reports in Percentage

Hi ALL, I have scheduled hours of each employee for each week and no of days scheduled in a week.i want to get reports for weekly wise no of employees scheduled less 24 hrs per week,b/w 24 and 48 hrs and greater than 48 hrs       Scheduled Hrs              8/1/2010         8/8/2010        15/8/2010            22/8/2010 Less than 24 hrs               5%                      5%                       5%                          4%   b/w 24 and 48 hrs          4%                        6%                    &

### 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%

### Checking out Web Matrix

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

### 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

### wrong Percentage calculation showing in pie chart

Hi,       Im using "#PERCENT{P2}" this one to calculate percentage in pie chart.  It should take 2 decimal only rite? But it is taking 3 decimal values. Example: 20.90678 After applying the formula "#PERCENT{P2}"  it is showing as 20.91 i want to show as 20.90 only pls help me Thanks in advance, Abdul2010

### Empty/blank group at top of matrix table

I'm having trouble creating a report with matrix tables.  I've got all the data showing up properly, but the first line in the preview is always blank.  If I subtotal the groupings, I get a blank Total line as well.  How can I stop this from happening? I'm using SQL 2005, report designer.  Data is coming from a stored procedure.  I've executed the sp in management studio as well as in the data tab of the report and it comes back with the correct data (no completely blank/null lines).  I'm new to SSRS and I've tried googling for a solution, but haven't found anything similar.  Below is the sp and the output data. SP: SELECT s.Status_Name + ' (' + CAST(CAST(s.Status_Weight*100 AS int) AS varchar(50)) + '%)' AS Status, s.Status_Order, CASE WHEN co.Company_Name IS NULL THEN '' ELSE co.Company_Name END AS Company_Name, co.Est_Income FROM tblStatus AS s LEFT OUTER JOIN tblCompany AS co ON (co.Status_ID = s.Status_ID AND co.New_Upsell = @NewUpsell) GROUP BY co.Company_Name, s.Status_Order, s.Status_Name, s.Status_Weight, co.Est_Income ORDER BY s.Status_Order, co.Company_Name Output (mgmt studio): Still Connecting (0%),1,Company1,400000.00 Still Connecting (0%),1,Company2,3000000.00 Clear Future (0%),2,Company3,250000.00 Clear Future (0%),2,Company4,250000.00 Appointment (10%),3,,NULL Proposal (40%),5,,NUL

### Percentage of matching days off among employee's

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday). I want result in percentage.result like thisConsistency Days of assignment            Across 4 weeks            3 weeks                2weeks                0                                                             2%                                   0%     &

### Pie show percentage greater than 100%

Hi all , i have a pie chart and show percentage as label ,i set label data as #PERCENT{P0} but when report runs it has 3 value: 58%,11%,32% you can see the 3 value add up to 101% is something else i need to set on label ? any help for this ?

### How to limited group number in matrix

Hi,  I was wondering how to limited group number in matrix? Because in some case the number of the dataColumn will be very large. So I just wanna to display the top 10 group. I've try the RowNumber(Nothing) mod 10 in group expression, but has no effect. Could you tell me how to do this.  Thank you very much indeed.

### Matrix Total Help

I have matrix report which renders as follows:                     Value category x      10 category y      5 categoy z        10 Total             25   How can i exclude category y from the total but still display its value for its row group? In other words i want Total to sum up to 20 in the above case.
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All