Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
Jayakumar

### overriding "grand totals" for calculated members

hi all, is there a workaround for overriding "grand totals" for calculated members?  (I cannot use the workaround whereby I create the calculation in the DSV or view directly due to it being a pretty complex Descendant parent/child calculation).   thanks much for any thoughts, Cos

### Grand Totals showing "Type MisMatch" error

Hi All, I have created a calculated measure using Exponential and Datediff function, and the formula is shown below. ( (EXP((DateDiff( "d", CDATE([Time].[Date].CurrentMember.PrevMember.MemberValue), CDATE([Time].[Date]. CurrentMember.MemberValue)))/365.0 * [Measures].[CD Dec Interest Rate]) -1) * ([Time].[Date]. CurrentMember.PrevMember.PrevMember,[Measures].[Cummulative_Premium])   ) In the above formula what i am trying to achieve is finding the difference between previous date and current no of days in days and dividing it by 365 and doing some multiplication after that, When i deployed above formula all my row values are getting displayed correctly but all my grand totals are displaying as "#VALUE" and when i checked the error, it displays as TYPE MisMatch. Could some one help me in finding the problem in above formula. Thanks in advance.

### TopCount dynamic named set + "Others" and "Grand Total"

After going through all available posts, unfortunately I could not find a solution for my problem. I have to create a dynamic named set of with TopCount in a cube that will be accessed with excel 2007. This how the outcome should look like:

Brand_A        \$50.00

Brand_Z        \$40.00

Brand_B        \$10.00

Others           \$200.00

Grand Total   \$300.00

This is the MDX I used which gives me the top 3 but not the "Others" and the "Grand Total." Just to keep it simple I used top 3 Brands.

```CREATE DYNAMIC SET CURRENTCUBE.[Top 3 Brands]
AS
TopCount
(
[NDD].[Brand].[Brand].Members,
3,
[Measures].[Sales]
)

, DISPLAY_FOLDER = 'Sets';```

Now I am stuck here. After reviewing many posts it seems that Excel 2007 has some issues with handling sets. I found two possible solutions from Raymond-Lee which I think may work.

Solution 1 - Use a named query in dsv

Solution 2 - create a dummy "Others"

Here is the post: http://social.msdn.microsoft.com/Forums/en-US/sqlanalys

### MDX Grand Totals

I asked this question a while back and got a response at the time from Javier that I thought would do the job - and it does to a degree - but I need a more dynamic approach....

Its to do with always using the subtotal for a calculation of the currently expanded dimension - rather than the total for the row..

Here is my problem....

I have a calculation that basically just divides faults by machines to give me a faults per machine figure...

For example - see the below data...

Fault Area Description Machine Builds Count Inspection Failure Count Faults Per Build (Total Builds)

### Question regarding Calculated Member Grand Totals

I have a Calculated Measure that was inherited. The logic is:

(

STRTOMEMBER(

"[Time].[Time Hierarchy].[Month].&["

+ VBA!CStr(year ([ForecastMonth].[Month].

CurrentMember.Properties("Key0")) )

+ "]&["

+ VBA!Cstr(Month([ForecastMonth].[Month].

CurrentMember.Member_key))

+ "]"

),[Measures].[Regular Cases])

If the [ForecastMonth].[Forecast Month].[Month] is assigned

### Show grand total running total in GridView Footer

In many scenarios we need to display Running total as well as Grand total in GridView footer. In this post i will try to explain in an easy way that how we can display running total & Grand total in a GridView footer combindly. To explain this solution using an example here i use a sales order report. The report contains all sales order amount in a tabular way. I will use a GridView to display sales order amount and use GridView footer to display Running total & Grand total. Let we have a customer table with id and name column plus an orders table with OrderID,CustomerID,OrderDate & Amount. Now our goal is to show all customers order with amount as well as page wise running total & grand total. Note that running total is necessary when you enable paging in a GridView where as Grand total is always you can consider.

### Vrooooom: How .NET and C# Drove an Entry in the DARPA Grand Challenge

Find out how the .NET Framework, a team of programmers, and a bunch of people from Carnegie Mellon University built an automated car to compete in the DARPA Grand Challenge. Along the way you get some inside tips on building an extensible real-time control architecture based on a whiteboard metaphor and implementing an accurate GPS-synchronized timer component for .NET.

John Hind

MSDN Magazine December 2004

### Datalist with embedded Grid or List...Sub Totals issue with iteration

Let me see if one of you can assist with this one...

i have a similar situation, but mine does not use the selected item (item Command). Here is what the form is to do:

1. this is for an educational environment, so we use SID- NOT SSN's, but i use the SID as a filter in the subset as the grouping unique id.

2. I'm trying to inject a sub total row at the last line item of each SID (if more than one item in the report for that SID).

3. I'm looping thru the items in the Datalist Item Command with a for each (item i in Datalist2.Items).

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

### RDLC Rows and colums totals

Hi,

I want to  show the row totals and column totals in the rdlc matrix. Please let me know how to do this.

For example:

2006  2007  2008  2009  Total

A                10      20      30      40       100

B                20      30      10      10       70

Total          30      50      40      50       170

### sum of 7 column totals in footer of gridview

I have implemented column tolals in the footer of my gridview using the technicque described in this article http://aspalliance.com/782 .Now I would like to have a total of the 7 column totals that are displayed in the footer.  Can anyone tell me how to do this.  I would like to display this in a label or an addition row in the footer if that is possible.

### TopCount Weirdness

Using 2008r2, I'm wondering why the following queries would return different results, and I gotta think it's a bug: (1) Date as slicer SELECT    {[Reseller Sales Amount]}  ON 0,     TopCount( Product.Subcategory.Subcategory.Members, 5,  [Reseller Sales Amount] )  ON 1 From [Adventure Works] WHERE ([CY 2008]) (2) Date on 0: SELECT    {([CY 2008],[Reseller Sales Amount])}  ON 0,     TopCount( Product.Subcategory.Subcategory.Members, 5,  [Reseller Sales Amount] )  ON 1 From [Adventure Works] Also, query #2 doesn't sort properly.

### SSRS 2008 Toggling visibility changes the totals

SSRS 2008 When I toggle row (detail) visibility off, my subtotals are zero.  My subtotals are correct when I toggle visibility on. I am using custom aggredate functions to producte the subtotals. It appears my custom functions are not called when visibilty is off How can I work around this? Thanks in advance for your help

### Excel 2003 pivot table - parent showing grand total than the sum of its children

All, In Excel 2003, I have a product hierarchy, for simplistic sake lets say it goes A > B > C > model nbr.  I have filtered on model nbr 1.  I have the product hierarchy in my pivot table and unit cnt as the measure. Starting at level A in the hierarchy I am showing a total unit of 12000, if I drill down to B it still shows 12000, if I drill down to C it shows 100 and if I drill down to model nbr it shows me model nbr 1 with a unit cnt of 100. So my question is why are my parents not filtering the model nbr, it is taking the total for ALL records that have level A as their parent regardless of the model nbr? This does NOT happen in Excel 2007 or when I browse my cube in SSAS.

### What is the best way to add an extra row to the bottom of a listivew for such things as totals, etc.

I can add a row to the bottom of a listivew by inserting a table after the layouttemplate in a listview.  It works fine for me to call the added controls from code-behind and chane the control values. Since my listview changes width dynamically depending on the contents of the data, my added table columns don't match up.  I have tried to access the width property of the table and then match the new ones with codebhind, but it doesn't seem to work. I am simply trying to add a row to the bottom of the listview to provide for totals of the columnts.  What is the best way to to that?   Thanks

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

### Report Builder 2.0 and Matrix Sub totals

Hi All, Hope someone can assist... I am busy building a complex Financial report and have to deal with lots of Sub Totals etc. I basically have 2 questions: 1. I have 2 Matrixes and wan't to "SUM" the sub total from one matrix with the sub total from another (both will have seperate groupings, is this even possible. 2. How do i add the Value of "TextBox1" to the value of "TextBox2", the expression will be appriciated ? Regards
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All