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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

sum of only selected column in matrix

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
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


View Complete Post


More Related Resource Links

How to sum selected matrix column in SSRS

  

anybody can help me to solve my problem??

i have a matrix report and i want to calculate just column 1 and column 3...

So any idea to solve my problem?

Thanks before :)

 

Gbu.....


Rendering data with HTML tags in the DD Gridview for a selected column

  

I am having trouble finding out where and how to HTML Encode a cell's data on the Dynamic Data (v4.0) gridview of List.aspx.  As a simple case, suppose I have formatted cell data that is A<br/>B in the DB.    Obviously, I want A stacked on B in the cell.

It seems gridView1.HtmlEncode = true has gone away.

So maybe I'll try to catch it on the RowDataBound event:

protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)

        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                // Html Encode the cells
            }

        }

but this event never fires?


Has anyone figured out how to properly render HTML tags data in the List.aspx's GridView1? 

If I figure this out, then I can add a MetaAttribute called something like [EncodeAsHtml(true)] and be on my way.  Thanks!


Configure BDC column to have multiple values selected

  

How do I Configure BDC column to have multiple values selected and make multiple entities data available in the same column.  Currently it supports only single value for an item.  This requirement is crucial need some solution immediately.


Hiding Columns (not column groups) in a Matrix, can it be done

  
Hi.  I want to be able to hide some of the columns of this report.  For example , I don't want to see the % of State Total for Total column, and I don't want to see the % of Location Total for the other column groups.  Can this be done?  Any help would be appreciated.  Thanks J I am using Visual Studio 2005   Total   Anaheim CA Arlington VA Atlanta GA Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total Count % of State Total % Of Location Total USA   3 100.00% 0.02%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   AB 2 100.00% 0.01%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00%   AE 8 100.00% 0.04%   0.00% 0.00%   0.00% 0.00% 3 37.50% 0.10% 1 12.50% 0.07%   AK 32 100.00% 0.17%   0.00% 0.00%   0.00% 0.00% 3 9.38% 0.10% 1 3.13% 0.07%   AL 161 100.00% 0.85%   0.00% 0.00%   0.00% 0.00% 17 10.56% 0.54% 84 52.17% 6.11%   AP 3 100.00% 0.02%   0.00% 0.00%   0.00% 0.00%   0.00% 0.00% 1 33.33% 0.07%

how to hide a column in Matrix : SSRS 2005

  
I would like to hide a column in matrix using SSRS 2005 but when i use visibility : hiden then it shows white space and if i reduce a width to 0in; but it accepts by default 0.035in something.i really would like to hide a complete column without any whitespace and all.

Hide static Column in matrix report

  

I created one matrix report. i have 2 static columns and some dynamic (PIVOT) coulmns.

I have one boolean variable. If it is true need to hide first column else hide second column.

For matrix report Column visibilty property is disabled.

How to do this?

kindly help me.


Getting the headertext of a selected column when autopostback = true

  

Hi All,

I have a grid which is getting bound from a dataset and the autogeneratecolumns prperty is set to true.

Now i have a menu control. And when i select a particular cell, I want to headertext of the cell selected should appear as the text of the menu item.

But because autogeneratecolumns = true, so i gridview.columns.count=0. So not able to get the header text.

The code goes as follows.

If selectedColumnIndex > 4 Then
                menuBSDet.Items(0).ChildItems(menuDetail.RemoveDetValues).Enabled = True
                menuBSDet.Items(0).ChildItems(menuDetail.RemoveDetValues).Text = "Remove " & gvwBSDetails.Columns(selectedColumnIndex).HeaderText
            Else...


 

Can somebody please help?


Matrix column Interactive sort

  

Hi,

 

In one of my reports, there is a requirement to provide interactive sort functionality on all the columns of the matrix report.

(Reporting Services 2005).

 

I was successful in implementing the interactive sort on the row groupings, but was unable to do the same on the column groupings.

 

For example , I have the following :

Custom Columns - Fill values based on value selected in a lookup column

  

Hello,

I am working with Sharepoint 2007. I have a list of 130 buildings located in six different cities and three different provinces. I imported this list from an Excel spreadsheet. I also have a document library that contains various files associated with these buildings. I've added a custom column to the document library that contains a lookup field to the name of each building. I also have two additional custom columns that have the city and province. What I would like to accomplish is to have the city and province columns automatically be set based on the name of the building selected, such that these values are taken from the same row of this list as the building name.

Hopefully my question makes sense.

Thank you, James


Comparing Selected value against GridView Column

  

Hello,

             I have a GridView Column "Gender". After displaying datagrid, I m selecting dropdown which is not in datagrid.

Dropdown list is in the same page. When I select dropdown Gender as male or female, I have to validate that Gender against GridView Column. If that Gender Exist in GridView, I have to display message.


TIA


SSRS report export to CSV showing column headers always in English inspite of the selected locale.

  

We are encoutering an issue with SSRS report export to CSV showing column headers always in English, regardless of locale.

 

We are using SSRS to display report results in a report viewer window launched from an ASP.net page.

 

When the report viewer is lauched in fr-CA locale, the report viewer window content is in French. However, when the results are exported to CSV, all the column header labels inside the CSV are always in English.

 

Complex Matrix column data with different data type

  
Hi
All,
I have a data like this

drop table #table
select 34 as A,17948 as B,0.19 as C,19 as D,16145 as E,'Jan' as Period into #table
Insert into #table
select 26 as A,14206 as B,0.18 as C,19 as D,13411 as E,'Feb' as Period
union all
select 38 as A,13037 as B,0.21 as C,18 as D,14974 as E,'Mar' as Period
select * from #table

From this #table i want the view as below format and is doable thru matrix report option in SSRS,but the problem i am running is that i cannot get in this type of data type format. If you look into it,i have column with header 'Jan' and it has data in different data type e.g money,number,percentage. I need to maintain this data type in order to do the calculation after it generates the report on excel spreadsheet. If i use the varchar for the column, it is not usable to me in the final report and i cannot do the calcualtion. Any workaround will be highly appreciated.

    Jan               Feb          Mar
A $34               $26          $26
B 17,

Static column after aggreate column in matrix reporting service 2008

  

Dear sir/madam,

I would like to creating cross tab with static column after aggregate column. My report showed as below:

No

Name of employee

Performance Rating

Total Rating (Average of Performance rating)

Previous Salary

Increment

1

2

Salary

Bonus

A. Managerial Employee

 

 

 

 

 

 

 

B. Non-Managerial Employee

 

 

 

 

 

 

 

Performance Rating is cross tab column

Total Rating is Aggregate column

Previous Average,Previous,Increment is static column

I look forward to hearing from you.

Thanks in advance,





Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio

  

I need some help.

 

If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.

 

My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.

 

Is this a bug or am I missing a setting?


Matrix Column grouping - Total column incorrect when colum value is wrapped in a call to code

  

I have a column grouped matrix report that shows count, cost and duration.  Duration is time in seconds.  To format the time on the report as hh:mm:ss I send it through a code block that converts the int to a string. 

When the report is generated the total column is NOT code.convert(sum(Fields!Duration.Value)).  At first I thought it was taking the max value, then I thought it is was taking the first value.. not really sure how it is calculating the value.

I did trying wrapping the expression like this IIF(InScope("matrixgroup"), Code.Convert(Fields!Duration.Value), Code.Convert(Sum(Fields!Duration.Value))).  It didn't make a difference the column is still incorrect.

If I remove the Code.Convert from the column, the value is correct.

Does anyone have any suggestions?

 

 


HELP: How to add Total to a row in a calculated column of a Matrix

  

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

 - group by EntityType (bug ou userstory),
 - group by EntityID (101010,101011,101012....n),
 - Qty: [Count(EntityID)]
 - Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
 - LeadTime: =round(sum(Fields!CycleTime.Value), 2)

 

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

HELP: How to add Total to a row in a calculated column of a Matrix

  

Hey guys,

I guess the title wasnt the best representation of my problem, so basically what I need is to add a total of a row so I can count how many developments were closed under a certain SLA. So I created a matrix like the one below, let's say that the SLA for Bugs is 30 hours and for UserStories is 55 hours. What I need to work is the column "Leadtime On Track" to identify and quantify the volume of bugs and UserStories within these SLA, ok? So the matrix was built with the following structure:

 - group by EntityType (bug ou userstory),
 - group by EntityID (101010,101011,101012....n),
 - Qty: [Count(EntityID)]
 - Avg LeadTime: round(Avg(Fields!CycleTime.Value),2)
 - LeadTime: =round(sum(Fields!CycleTime.Value), 2)

 

To identify the ones under the SLA I used the following formula, which worked:

=iif(((Fields!EntityType.Value.Equals("Bug")) andalso (sum(Fields!CycleTime.Value))<=30) or ((Fields!EntityType.Value.Equals("UserStory")) and (sum(Fields!CycleTime.Value))<=55), 1, 0)

however it only works on the dimension "EntityID", because where I tried to have the overall, dimension EntityType, by

Categories: 
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