mcgradyming Report post Posted September 22, 2011 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
nbritton Report post Posted September 22, 2011 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
mcgradyming Report post Posted September 22, 2011 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
Rahul Kumar Report post Posted January 6, 2012 Hi, Could you please let us know if your issue is resolved? Share this post Link to post Share on other sites
