Publish graphs onto SharePoint (Visifire)

k_harpaul
k_harpaul used Ask the Experts™
on
Hi.

I have a SharePoint site where I would like to use graphs that get Data from a SQL DB. I did some research and found that this possible with Visifire.

My question is how do I do it? I currently have Visual Studio installed on my PC and the SharePoint server and SQL server are sitting on different servers.

Can the experts please assist?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Solution Architect
Commented:

Hi,

Visifire is based on Silverlight. SharePoint 2010 has silverlight webpart. After you have designed the graph, you can browse the xap file in Silverlight webpart to show chart in SharePoint.

For SharePoint 2007, look at following article to show Visifire chart -
http://blog.drisgill.com/2009/02/visifire-open-source-silverlight.html

Also, please refer following codeplex project - http://smarttools.codeplex.com/wikipage?title=Charts&referringTitle=Home

I hope it helps.

Cheers ....
Rajendra

Author

Commented:
Hi.

I am using SharePoint 2007. I looked at the article but it caters for Lists. Is there some way I can get a SQL connection to it.
Rajendra ShekhawatSolution Architect

Commented:

Hi,

SharePoint is just a host for Visifire Silverlight Chart Controls.

Visifire connection and data displayed depends on how Visifire is configured.
I have limited understanding of Visifire. However, as seen from videos on Visifire, you can write managed code in Visifire chart. Through managed code, you can write your custom code for SQL Connection and data retrieval.

Below articles on creating Visifire chart with Data binding -

http://visifire.com/documentation/Visifire_Documentation/Common_Tasks/DataBinding_in_a_multi-series_chart.htm
http://www.visifire.com/blog/2010/02/16/visifire-now-supports-databinding/
http://www.visifire.com/forums/index.php?showtopic=571

I hope it helps.

Cheers ...
Rajendra Shekhawat

Top Expert 2010

Commented:
here is an alternate to Visifire
http://www.amrein.com/apps/page.asp?Q=5777

or, if you want to explore silverlight with sharepoint:
http://silverlight.codeplex.com/wikipage?title=Silverlight%20Toolkit%20Overview%20Part%202

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial