in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

Marian Lishman's Blog

From STS to WSS and beyond :-)

December 2004 - Posts

  • Putting totals in for a field that is a calculated one


                   
                   
           
           

    For some reason I don't seem to have the option of formatting this as a number in FrontPage so I guess I will need to do that in the XSL as well.

    I have often thought it a bit strange that you cannot total a calculated field, particularly when it is a number. I managed to acheive this a while ago but had forgotten how I did it so now I am going to put in down in writing so that I don't forget!

    You need to change the view to a datasheet one in Frontpage. Then go to the code and find the ??? that ends the display of all the data. Between that and the ??? enter another row and the required number of table cells.

    Then add the xsl code that will sum that field - in my case this makes the xml like this:


               

    Total Cost: <?xml:namespace prefix = xsl /><xsl:value-of select="sum(<A href='$Rows/@TotalCost)"></xsl:value-of>$Rows/@TotalCost)"/>>
               
  • Problems with custom link bars

    When adding a custom link bar through FrontPage it basically just doesn't appear on the page in IE. Can't yet figure out why not.

Need SharePoint Training? Attend a SharePoint Bootcamp!

Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts