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

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

How to show correct info in dataview group footer

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint


I think this is more of an xslt type question. Still learning more about it everyday. Just need some help or a guide to the right direction.

I've created a dataview that has grouping enabled. There's just 1 level grouping. I've enabled both "Show group header" and "Show group footer".

In the group header section, I manually inserted the following to get certain info

 <xsl:value-of select="@Cost" />

I've added the same thing in the group footer. The group header shows the correct info, but in the group footer, it shows the info of the next group header. So, I believe in the group footer, I need to enter the xslt to get info from the previous node/row. Just not sure how to put that as xslt. Would you be able to help?



View Complete Post

More Related Resource Links

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.

Adding a footer to a pre-existing row group

Hi, I want to add a group footer to my report which includes the individual provider name for each page. I have already added a parent row group for details relating to each provider without specifying to include a footer to the row group. When I now add a footer using the insert footer path this places the footer below my row grouping, when I then add the provider field to the footer every page returns the first provider in the list. How do I include the footer to the grouping so ever footer relates to the individual provider type in the main body of the report? Thanks James

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?  

Want to show a group header item only when the group value changes

Hi,    We have a couple of reports that show lines for a customer order. We were told to add notes for each line that were entered in our oe portal so our manufacturers and shippers could see them. I've done this but the group header for an order ine is set to repeat so the note shows on every page.Each line can take up several pages due to the fact that lot pick information is displayed for each line.     When the notes are long, it can create a report that is very long, simply due ot the extra space need on each page. We would like the line note to to appear ONLY when the value of the line number changes and we are on a new line and not after. Is there a way to detect that the line group value has changed and to print the note then but not after until a new line number is reached?    Any help would be appreciated. fig000

Hide a measure group in excel 2007 'Show Fields Related to'


Hi All,

I know that if a I want to hide a measure group to users I have to set the properties 'Visible' to false for all the measure of the measure group.

But when I open a connection to the cube with Excel 2007 I see again the measure group in the drop down list 'Show Fields Related to' in the 'Pivot Table Fields List'.

I don't see it in the measure group list when I choose 'All' in the 'Show Fields Related to', but i don't want to see it in the list 'Show Fields Related to' too.


How I can do to hide permanently the measure group?


Thank you all,


Show users based on ad-security group or OU


Will it somehow be possible to show members of a AD group ?

We have some superusers, and they all have the ad-group: super_users.

Can i show all members somehow ?

Maybe by a search flag, so it is just a link to a search result ?

Jakob Olsen

How to show group totals only at the last page?


Hi All,

I am facing difficulty to show the group totals in the SSRS 2008.

I have group on feilds country,state,city with details group suppose i have choosen country as India,then the state have two values then i need show the report with totals like below.

O/p for state1




col1 col2 col3 col4

city totals

State totals

O/p for state 2




col1 col2 col3 col4

city totals

State totals

Country totals

the difference b/w two outputs is like i need to show the country totals only at the last state totals.

thanks in advance.

Veeren :)

Reporting Services Orphaned Group footer on PDF / Print

Good afternoon

The report I have created using reporting services (VS2005) has a group header which is set to repeat on every new page, and the group footer appears only at the end of the group.

It looks fine in preview mode, and also on the screen, However; when the report is exported to PDF or printed, If the group FOOTER has is pushed onto a new page because of a pagebreak, the group HEADER is not displayed on this new page.

Is there a fix for this?  I have spent hours searching on the web, but have not found a solution.


DataView Person or Group Column Not Showing


Hello all,

I am puzzled at what is going on here.

I have a Person or Group type (Presence: picture with name) column called 'Person'. I added a DataView into sharepoint designer and could not see the picture of person but instead name of person.

Using this article [http://vspug.com/joed/2008/03/17/displaying-users-with-presence-in-xslt-data-view/] I changed the following (disable-output-escaping="yes")

<td class="ms-vb">
    <xsl:value-of select="@Person" disable-output-escaping="yes"  />

However, I still can't see any pictures?

Can you please guide me if I am missing something here.

Thanks in advance.

Sum Issue in Group Footer and report Footer


In attached SSRS 2005 report i am grouping by date and within date i'm showing acconuts.
In group footer i'm trying to do sum depends on TYPE field.
For Receipt Column
=IIf((Fields!Type1.Value= "R"),Sum(Fields!Amount.Value),"")
For Disbursement Column
=IIf((Fields!Type1.Value= "D"),Sum(Fields!Amount.Value),"")

But report is putting sum either in RECEIPT or in DISBURSEMENT column depends on whatever record is 1st.

For Receipt Column in report footer
=IIf((Fields!Type1.Value="R"), Sum(Fields!Amount.Value), "$0.00")
For Disbursement Column in report footer
=IIf((Fields!Type1.Value="D"), Sum(Fields!Amount.Value), "$0.00")

Same way page footer is not showing the correct value.
Instead of $257673.61, it should have been 257673.61-9340-2875.98 = $245457.63
And Disbursement column in report footer instead of $0.00 it should be $12215.98
Any Suggestions what i'm doing wrong here.


Add total in group footer for calculation with multiplication and sum

Not sure if the topic title clarifies my problem correctly but this is what I'm trying to achieve:
I have a simple report, an overview of different projects grouped by accounts. Every project shows the revenue, the costs and the profit.
I want to have a total of all 3 colums, both in group footer as in the table footer. I know how to do a simple Sum(Fields!revenue.Value) but my calculation is a bit more complicated:


Basicly this adds up: Transportation cost (km*cost/km) + Preperation cost + Project Cost + Multiple other costs
The formula itself works perfectly.

Now when I have 3 projects with an account, I want to know the total. I've tried the following:
- =Sum(Formula)
- =Sum(km*cost/km) + Sum(Preperation cost + Sum(Project Cost) + Sum(MultipleOtherCosts)
- =Sum(ReportItems!textbox2.Value)

But either I get errors, or the total is incorrect because of the multiplication. The problem is I need to mulitplie km*cost/km first and not Sum(km)*Sum(Cost/km) because than the total is incorrect.

Is there someone who sees a solution for my problem?


Restict access to page fields. How to show field value to members of certain group?


I have the fields that should be shown for members of one group. How to implement this behavior?

Also i need to restrict access to editing other field for all except of limited amount of persons. How to do this?


All these questions are related to Site Content Types and Page Layouts.

Show/Hide fields on InfoPath based on context User Group Membership

I am reading a book on SharePoint 2010 Development by Wrox and although it is a good book, the InfoPath section is limited. I am Googling to see if I can find anywhere where i can perhaps have this type of functionality to hide and show a specific field based on their Group Membership?
Victor Palma

Reporting Services 2005 - Scatter Report Unable to show category group



  I am using scatter chart to create some sort like


Quantity  Time  Machine Name

12 2010-09-10 04:21:11         M1

22 2010-09-10 19:21:11  M1

100 2010-09-11 05:21:11  M1

89 2010-09-11 07:21:11  M1


66 2010-09-12 07:21:11  M2

18 2010-09-13 07:21:11  M2


68  2010-09-12 07:21:11  M3


X-axis show me the quantity, Y-axis shows me the time and then machine name group its time and qty under different category group. How to make it.

I have tried to use scatter chart to display but I can only see the X and Y -axis and without category group shown...  

Deploying new group in elements doesn't show


When I run the feature my web parts create the group just fine. But when I deploy the wsp file to the server, my groups are not created.

  <File Path="WebpartName.webpart" Url="vpDashboard_DCSSales.webpart" Type="GhostableInLibrary" >
   <Property Name="Group" Value="SalesCharts"

Group By With Collapse="TRUE" doesn't show list item.


I created a SharePoint Page.  I then inserted an XsltListViewWebPart web part via SharePoint Designer 2010.  I then modified the CAML to include a couple of filters.  I then added a start date and end date parameter.  Then I saved my page and went into SharePoint.  I added two date filters (start date and end date) and I connected them to the  XsltListViewWebPart web part.  Then I selected a start date and end date and the list is correctly filtered.  The list is grouped by district and location.  However, when I expand the district and then I expand the location, it says "Loading...." but then it never loads anything.  If I change it to Collapse="FALSE" everything works fine???  Any help would be greatly appreciated.




         <FieldRef Name="Created"/>
         <Value Type="DateTime">{StartDate}</Value>

how to have more than one group by clause and summation of data fields as well in group by footer!


How do we have more than one group by clause in SSRS  and summation of all fields in group by footer clause !

Is it possible to have nested group by clause in SSRS and summation of reports fields in those group by footer.

thanks in advance for your response.

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