Jan Tielens' Bloggings

Great Jan! I was very curious about the improvements and tested them right away. Great that you added grouping!

The chart works now with calculated columns, based on currency and number columns. But when an item has decimal places other than ,00 like 0,50 the following error occurs:

Exception: 2260 An error has occurred. [Line: 2 Position: 1166]

If I change the the value so the calculated column ends with ,00 the chart parses correctly.

For reproducing the error: I use the following columns:

Uurtarief;Currency;2 Decimal places;Default value: currency: 112,50, format:Dutch

Aantal;Number;Number of decimal places: Automatic;Defualt value: number

Totaal;Calculated: =Aantal*Uurtarief;Data type returned: currency;format: dutch;decimal places: tried 0 and 2; both the same error

So if you create one item with these three columns where Aantal = 3, Uurtarief = 112,50 the Totaal gets calculated to: 337,50 or 338 when decimal places is 0; then the error occurs; if you adjust the column for this item to 4, the Total gets calculated to 450,00 and then the chart parses correctly again.

Hope this helps again for improvement.

Regards Peter

Pingback from  New SmartTools Release for SharePoint | SharePoint Fun

Hi Peter, once again thanks for testing! I make sure your scenario will be supported in the next release.

Pingback from  BizTalk Linkflood January 23, 2009 « ADA ICT Devsquad’s Blog

Pingback from  Newly Noted #9 | Patrick Verbruggen's Blog

…eine Sammlung aktueller Infos rund um Silverlight, die ich gestern auf dem Rückweg von der Microblogging

Pingback from  Windows 7 News » Silverlight-Links: Mikrofon/Video-Zugriff, PopUps, Obama/Photosynth, Python, SharePoint und mehr

Link Listing - January 26, 2009

Hi Jan,

I performed some more testing, here are the results ;-)

Found a temporary fix for the decimal bug; Added a function to the calculated field Total: =ROUNDUP([Aantal uren]*Uurtarief;0)

The value is then rounded to the next whole number.

Group By Field property --> if one of the list items has an & sign in the field value that's used for Group By Field the web part errors with:

Exception: 7015 An error has occurred. [Line: 2 Position: 1541]

Guess that also counts for other characters that are prone to errors..

When a ColorSet attribute is used other than VisiBlue in the XAML Template the web part doesn't display a chart when used in FireFox or Safari. In IE it does. For cross browser compatibility it is better to use the Theme attribute in the XAML Template. For example: Theme="Theme1" Don't know if this is a bug in Visifire or in the parsing of the web part.

If you use the Prefix attribute in the XAML template like <vc:Axis Prefix="€"> it displays correctly on the Axis. But it is not shown in the value label that is parsed in the datapoint template LabelText and YValue: <vc:DataPoint AxisXLabel="{0}" YValue="{1}" LabelText="{1}" LabelFontSize="12"/>

Nice to have and not possible to create within a list view:

- limit the results; for instance if you want a top 10 of the grouped list items;

- sorting on the SUM field;

- support for a second view to create combined charts;

Percentage counter displayed when loading displays an incorrect value when used in Safari, but guess that's in the Visifire component?

Great web part, becaus the Office 2003 web parts for charting are not needed anymore!

Regards,

Peter

Thanks for the ideas Peter, I'll take them into account for the next version.

O, last but not least: cross site support? If you wan't to place a chart on your front site and the list the chart is based on is on another site. An extra property for setting the server relative site url would be nice.

Pingback from  Blogs in the spotlight - January report &laquo; Path to SharePoint

Hi Jan,

I installed the package, enabled the feature, adjusted the parameters in the web part but the outcome stays a blank screen with no chart display in it.

Any ideas what's going wrong?

(Silverlight plugin is installed, using IE 6 SP2)

Kind Regards,

Wim

@Wim, do you have data in your list to wich the web part is connected?

Hi Jan,

I'm a step closer in making the charts work.

I've enabled the MIME types on our win2K3 server and have more output now. Unfortuneatly the following one:

Seems that visifire has

Error Log Version=2.0.8 Beta:

--------------------------------

1) Copy & Paste the contents of this log in www.visifire.com/forums for support.

2) Exception: 2260 An error has occurred. [Line: 2 Position: 724]

3) XML:

<vc:Chart xmlns:vc="clr-namespace:Visifire.Charts;assembly=SLVisifire.Charts" Width="400" Height="300" BorderThickness="0" View3D="True"

Hi,

I think I followed instructions how to install Silverlight Chart Web part properly. But, still I get white space where chart is suppose to be on my Sharepoint page. I installed 3.5 .NET Framowork and Silverlight 2. I added .xap, xaml, xps and xbap MIME types to my IIS server. I do have a list on the page that Chart points to.

I see that somebody said that he enabled the feature. Is this required, because I don't see Chart Web part in the list of the features in Sharepoint Central Admin.

Server box is WIN 2003 64-bit virtual server and IIS is version 6.

Any ideas?

Thanks.

Goran Djordjevic

It might be useful and esier for admins to track if you would make the version of the Smarttools JQuery match the version of the JQuery it is installing

Hi,

Thanks for SmartTools. I install What's new 1.2 without any problem.

When I click on link under Item I get page cannot be found. Links under sites, lists work fine.

Any I dea?

Thanks a lot.

carl

Pingback from  So what's up with jQuery in SharePoint 2010? | End User SharePoint