Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Chart WSS3

Posted on 2009-12-30
5
Medium Priority
?
714 Views
Last Modified: 2012-06-27
Hello experts!
I see Fusion Charts (http://charts4sharepoint.codeplex.com/), but i can´t do it work (yet).

After installation, I can not enter a valid xml of my list.

Somebody know a good (and free) solution for Charts for WSS3 ?

I saw a very good, this is available in the model ITTeamWorkspace.wsp, (Attached: screen, webpart code of chart, and ITTeamWorkspace.wsp, ApplicationTemplateCore.wsp), but I could not use on other websites, I could not understand how it works.

The goal of my post is to find an easy way to generate charts and see how it has created the graphic ITTeamWorkspace.wsp or Fusion Charts.

Thanks
// XLS EDITOR CODE

<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:WebControls="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal">
  <xsl:output method="html" indent="no"/>
  <xsl:decimal-format NaN="NaN"/>
  <xsl:param name="dvt_apos">&apos;</xsl:param>
  <xsl:variable name="dvt_1_automode">0</xsl:variable>
  <xsl:template match="/" xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:WebControls="Microsoft.SharePoint.WebControls">
    <xsl:call-template name="dvt_1"/>
  </xsl:template>
  <xsl:template name="dvt_1">
    <xsl:param name="ParentPath"/>
    <xsl:variable name="dvt_StyleName">Table</xsl:variable>
    <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
    <xsl:variable name="dvt_RowCount" select="count($Rows)" />
    <xsl:variable name="IsEmpty" select="$dvt_RowCount = 0" />
    <xsl:call-template name="dvt_1.footer">
      <xsl:with-param name="Rows" select="$Rows" />
    </xsl:call-template>
  </xsl:template>
  <xsl:template name="dvt_1.body">
    <xsl:param name="ParentPath"/>
    <xsl:param name="Rows"/>
    <xsl:for-each select="$Rows">
      <xsl:variable name="SrcPos" select="count(preceding-sibling::*[local-name()=local-name(current()) and namespace-uri()=namespace-uri(current())])+1" />
      <xsl:call-template name="dvt_1.rowview">
        <xsl:with-param name="ParentPath" select="$ParentPath" />
        <xsl:with-param name="SrcPos" select="$SrcPos" />
      </xsl:call-template>
    </xsl:for-each>
  </xsl:template>
  <xsl:template name="dvt_1.rowview">
    <xsl:param name="ParentPath"/>
    <xsl:param name="SrcPos"/>
  </xsl:template>
    <xsl:template name="percentformat">
  	<xsl:param name="percent"/>
            <xsl:choose>
            <xsl:when test="format-number($percent, '#,##0%;-#,##0%')= 'NaN'">0%</xsl:when>
            <xsl:otherwise>
            <xsl:value-of select="format-number($percent, '#,##0%;-#,##0%')" />
            </xsl:otherwise>
            </xsl:choose>
  </xsl:template>
  <xsl:template name="dvt_1.footer">
    <xsl:param name="ParentPath" />
    <xsl:param name="Rows" />
    <xsl:variable name="NotStarted" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Not Started'])" />
    <xsl:variable name="InProgress" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'In Progress'])" />
    <xsl:variable name="Completed" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Completed'])" />
    <xsl:variable name="Waiting" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Waiting on someone else'])" />
    <xsl:variable name="Deferred" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Deferred'])" />
    <xsl:variable name="AllTasks" select="count(/dsQueryResponse/Rows/Row)" />
    <xsl:variable name="percentNotStarted" select="$NotStarted div $AllTasks" />
    <xsl:variable name="percentInProgress" select="$InProgress div $AllTasks" />
    <xsl:variable name="percentCompleted" select="$Completed div $AllTasks" />
    <xsl:variable name="percentDeferred" select="$Deferred div $AllTasks" />
    <xsl:variable name="percentWaiting" select="$Waiting div $AllTasks" />
    <table width="100%" cellspacing="0" cellpadding="2" style="border-right: 1 solid #C0C0C0; border-bottom: 1 solid #C0C0C0; border-left-style: solid; border-left-width: 1; border-top-style: solid; border-top-width: 1;">
      <tr>
        <td class="ms-formbody" width="125px"  style="vertical-align:middle">
          Not Started: <xsl:value-of select="$NotStarted" />
          <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;			
			</xsl:text>(
            <xsl:call-template name="percentformat">
            <xsl:with-param name="percent" select="$percentNotStarted"/>
            </xsl:call-template>
      )
        </td>
        <td>
          <table width="100%" >
            <tr>
              <td width="{round($percentNotStarted*100)+1}%" height="15px" class="ms-selected">
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
              <td width="100%" >
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td class="ms-formbody" width="125px"  style="vertical-align:middle">
          In Progress: <xsl:value-of select="$InProgress" />
          <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;			
			</xsl:text>(
            <xsl:call-template name="percentformat">
            <xsl:with-param name="percent" select="$percentInProgress"/>
            </xsl:call-template>      
      )
        </td>
        <td>
          <table width="100%" >
            <tr>
              <td width="{round($percentInProgress*100)+1}%" height="15px" class="ms-selected">
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
              <td width="100%" >
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td class="ms-formbody" width="125px"  style="vertical-align:middle">
          Completed: <xsl:value-of select="$Completed" />
          <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;			
			</xsl:text>(     
            <xsl:call-template name="percentformat">
            <xsl:with-param name="percent" select="$percentCompleted"/>
            </xsl:call-template>  
      )
        </td>
        <td>
          <table width="100%" >
            <tr>
              <td width="{round($percentCompleted*100)+1}%" height="15px" class="ms-selected">
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
              <td width="100%" >
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td class="ms-formbody" width="125px"  style="vertical-align:middle">
          Deferred: <xsl:value-of select="$Deferred" />
          <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;			
			</xsl:text>(
            <xsl:call-template name="percentformat">
            <xsl:with-param name="percent" select="$percentDeferred"/>
            </xsl:call-template>        
      )
        </td>
        <td>
          <table width="100%" >
            <tr>
              <td width="{round($percentDeferred*100)+1}%" height="15px" class="ms-selected">
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
              <td width="100%" >
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td class="ms-formbody" width="125px"  style="vertical-align:middle">
          Waiting on someone else: <xsl:value-of select="$Waiting" />
          <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;			
			</xsl:text>(
            <xsl:call-template name="percentformat">
            <xsl:with-param name="percent" select="$percentWaiting"/>
            </xsl:call-template>              
      )
        </td>
        <td>
          <table width="100%" >
            <tr>
              <td width="{round($percentWaiting*100)+1}%" height="15px" class="ms-selected">
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
              <td width="100%" >
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
              </td>
            </tr>
          </table>
        </td>
      </tr>      
    </table>
  </xsl:template>
  <xsl:template name="dvt_1.header">
    <xsl:param name="ParentPath" />
    <xsl:param name="Rows" />
    <table cellSpacing="0" cellPadding="2" border="0" width="365px" >
      <tr>
        <td class="ms-formfieldlabel">
          <p>
            <strong>Overall Task Status</strong>
          </p>
        </td>
      </tr>
    </table>
  </xsl:template>
</xsl:stylesheet>

// END XSL EDITOR CODE

// PARAMETERS EDITOR CODE

	<ParameterBinding Name="ListID" Location="None" DefaultValue="{EB47DB14-E666-4639-BB5C-0A5256F40608}"/>
	<ParameterBinding Name="dvt_apos" Location="Postback;Connection"/>
	<ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>
	<ParameterBinding Name="Today" Location="CAMLVariable" DefaultValue="CurrentDate"/>

//END PARAMETERS EDITOR CODE

Open in new window

Empty1.png
0
Comment
Question by:br_ms
  • 3
  • 2
5 Comments
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 2000 total points
ID: 26147155
i haven't heard of that one you're using.
the two i'm aware of are ChartPart and SmartTools.

http://www.codeplex.com/ChartPart/
http://smarttools.codeplex.com/wikipage?title=Charts
0
 

Author Comment

by:br_ms
ID: 26147273
Hello zephyr_hex,

I have intalled Chart Part too, but when i try insert CharPart webpart, a error msg box show:

Unable to add selected web part(s).

ChartPart: A Web Part or Web Form Control on this page cannot be displayed or imported. The type could not be found or it is not registered as safe.

Do you know how can I fix it?

Thx
0
 
LVL 44

Assisted Solution

by:zephyr_hex (Megan)
zephyr_hex (Megan) earned 2000 total points
ID: 26147350
make sure you've installed the prerequisites:
http://chartpart.codeplex.com/wikipage?title=install&referringTitle=Home

and followed the other installation steps.
0
 

Author Comment

by:br_ms
ID: 26147455
Thank you so much Zephyr_hex ... i install  Microsoft Chart Controls for Microsoft .NET Framework 3.5 and the ChartPart work fine.

I still have problems with SmartTools, but i´ll create a new post for it.

Thx
0
 

Author Closing Comment

by:br_ms
ID: 31671280
Excelent!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question