Sign in to follow this  
mcgradyming

Using Sql Inside Fusioncharts

Recommended Posts

Hello,

 

I am trying to use custom sql within my fusioncharts for Sharepoint, and the query that I am trying to use contains cursors that I am trying to declare.

 

 

DECLARE @ORIG_TBL1 TABLE (YR SMALLINT

,MNTH SMALLINT

,MNTH_TOTAL INT

,YTD_TOTAL INT)

 

The query obviously runs against SQL Server, no problem, but when I put it into the FusionChart, it complains. Can anyone let me know if this is possible inside FusionCharts?

 

Thanks,

Anthony

Share this post


Link to post
Share on other sites

I have found that sometimes the query needs to be in a stored procedure to work. I was getting errors running some cte statements but once i put them into a strored procedure the problem went away.

Share this post


Link to post
Share on other sites

I have found that sometimes the query needs to be in a stored procedure to work. I was getting errors running some cte statements but once i put them into a strored procedure the problem went away.

 

So are you saying I can make a call from inside the FusionChart SQL to a stored proc?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this