Customizing List Views with XSLT Transformations in SharePoint Designer 2007. Data stored in a Windows SharePoint Services 3.0 list can be presented in more ways than a simple tabular layout. By using Microsoft Office SharePoint Designer 2007 and custom XSLT, you can present the same list data graphically—for example, as a bar graph. This Visual How To illustrates the steps for presenting list data as a bar graph through a Data View Web Part. The data source list used in this example is the standard task list that is stored in a Windows SharePoint Services 3.0 team site.
The bars in the graph represent the total percentage of tasks for each status value. Start with a SharePoint task list that contains some sample data. Assign each task one of these status values: Not Started, In Progress, Completed, or Deferred. Insert a Data View Web Part in a Web Part zone. To insert a Data View Web Part Start Office SharePoint Designer 2007. This procedure inserts a Data View Web Part in the selected Web Part zone in the default.aspx page.
Click the Status field. Figure 2. Creating a Dashboard (Bar Chart) in SharePoint from a Data View « Pam Davis’ Blog. October 7, 2008 by padavis I was in need of a simple way to show some bar charts for list data in a SharePoint site. Actually the requirement was to create a page of dashboards based on various status fields that management could view at a glance. I did some looking online and found a few resources but none that exactly met my needs. The two resources I found most helpful were Customizing List Views with XSLT Transformations in SharePoint Designer 2007 and Create Bar Graphs in SharePoint. Here is a sample dashboard page. A dashboard page consists of a web part page containing a data view and a separate XSL file which formats the data view to look like a bar chart. Creating an XSL Formatting File Download a copy of the sample XSL file from here and then change the file extension from .doc to .xsl.In SharePoint Designer, create a folder called XSLT off of the root folder. 4. 5. 6. 7. 8. 9.
Creating the Dashboard Page 10. Like this: Like Loading... Inserting Repeating Data Items into a Word 2007 Table by Using the Open XML API. Summary: Walk through a solution that solves the problem of displaying an arbitrary number of data items on the surface of a Microsoft Office Word 2007 document by using Open XML Formats and the Microsoft .NET Framework 2.0. (6 printed pages) As part of a business solution, developers sometimes want to dynamically display repeating data items of an unknown number in a Microsoft Office Word 2007 document.
Word 2007 does provide the ability to dynamically map data to the document surface by using the XML mapping feature of data-bound content controls mapped to custom XML parts. However, you can map a content control only to a single XML element in a custom XML part. In addition, Word 2007 does not provide a table content control that can be bound to custom XML that represents tabular data. Further, when you attempt to display repeating data items to the surface of a Word 2007 document, you must know at design time how many data items you want to map. Locating a Table Figure 1. Figure 2. Notes on SharePoint : Automatically create Word documents which include list fields. I haven’t seen much information on the web regarding how to automatically create Word documents in SharePoint and how to pass list item fields directly into a document. It’s fairly straightforward to get this working (certainly no code is required, just SharePoint designer) and the technique could be used to automate all manner of business processes.
For example, you could create an ASPX page containing drop down fields and calculated fields that automatically creates a quotation document or you could have a form that captures all the details for a job vacancy that would create a standard looking job advert. In this exercise I will keep things simple and create an application that creates a certificate with an exam name, user name and pass mark passed into the Word documents from a list item. This would make a nice addition to the Quiz Web Application exam. This example requires Word 2007.
The example has the following components: A document library is really just a special type of list. Kanaal van GetStartedSharePoint. Extending Content Query Web Part XSLT with custom functions. Earlier this month I wrote that SharePoint developers working with the Content Query Web Part (CQWP) are provided a mechanism to extend the information available in the XSLT transformations. While exploring the CQWP even further I found out that you could create custom XSLT functions as well! Can you imagine the possibilities? It's probably a common knowledge by now, that the CQWP uses XSLT for creating the presentation layer for the queried data. The default set of the functions provided with XSLT is limited. If you want to extend the Content Query Web Part XSLT transformations with extra functionality, there are several points where you need to hook into: the Content Query Web Part, to make the custom methods available in the XSLT custom class to define the methodsthe XSL file (ItemStyle.xsl, ContentQueryMain.xsl and/or Header.xsl) to make it aware of the custom functions Getting Started Defining the custom functions Adding the functions to the Content Query Web Part Half way there Summary.
Alchemist XML IDE Standard FREEWARE 3.0 - Alchemist XML IDE, is a free advanced XML Integrated Development Environment (XML... Alchemist's best-in-class features for working with XML, XSL, XSLT, XPath, SQL/XML, code generation, database to XML mapping and many other XML technologies. Alchemist is a product that provides the necessary infrastructure to build pieces of reusable software or aplications.
The product is target to three kinds of specific users: 1- Programmers who want to make RAD (Rapid Application Development) without any previous knowledge about XML. 2- XML programmers who want to develop their own cartridges from a relational database. 3- Users who want to make RAD and elaborate their own cartridges to integrate them in software development project. XSLT Debugger Alchemist features the world's most powerful XSLT debugger a requirement for building bug-free XSLT stylesheets and XML data transformation applications.
Features :