nbritton Report post Posted August 25, 2011 I have connected to a sql database and i have presented two columns. " Job Title" and "Exit Status". I would like to create a report to show how many instances of each status occured. I have tried just about everything i can think of. Does anyone have ideas for me? I thought this would be one of the simplest reports to start with. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 26, 2011 Hi, Could you please let us know whether you are getting any error or it is not working as expected? Also, have you tried with custom SQL query? Share this post Link to post Share on other sites
nbritton Report post Posted August 26, 2011 No errors. Just not getting any chart data. I have tried using the query. Its actually the way i perfer to go, so i can trim down the amount of data to the past 24 hours. I can see the data in the grid view but i cant see it in the charts. Hi, Could you please let us know whether you are getting any error or it is not working as expected? Also, have you tried with custom SQL query? Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 26, 2011 Hi, Could you please send us wizard's screenshot so that we can have a look into it? Also, Could you please check if there is any error log created for your actions? The error information is being logged in FusionCharts_LogList, you can refer to the attached PDF to know how to get error log information. Stack-Trace.pdf Share this post Link to post Share on other sites
nbritton Report post Posted August 27, 2011 I am using the following query: SELECT * FROM [NETVAULT].[dbo].[NV_JOB_HISTORY] where "StartDateTime_Calc" >= dateadd(hh, -24, GETDATE()) AND "phase" =1 AND NOT "job title" like '%arch%' AND NOT "Job Title" like '%tran%' I am not doing and filtering or grouping, although i have attempted to group several ways and i do not get any results back. I am choosing the pie or bar chart from the single series section. It looks like it should be counting the number of each exit status. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 29, 2011 Hi, Have you clicked on "View data in grid" option if yes, was it showing the data? Also, could you please send us the screenshot showing the output or the issue? Share this post Link to post Share on other sites
nbritton Report post Posted August 29, 2011 I thought i added the screen shots i had taken. I will add them for you today. I have checked to see the data in the grid with the group option. It shows nothing. I would think if i would group by exit status and count on job title, it would count the number of instances. Do you have any docs i can review. Hi, Have you clicked on "View data in grid" option if yes, was it showing the data? Also, could you please send us the screenshot showing the output or the issue? Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 29, 2011 Hi, I am afraid, we do not have any docs as of now. Share this post Link to post Share on other sites
nbritton Report post Posted August 30, 2011 Here is the doc.fusionchartimages.doc Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 30, 2011 Hi, Thanks for the screenshots, unfortunately we need one more information like result of clicking on the highlighted button (In red rectangle, image attached) , please try to cover all the columns so that we can check data types for each columns. Share this post Link to post Share on other sites
nbritton Report post Posted August 30, 2011 datagrid.fusioncharts.doc here is the requested screenshots. Share this post Link to post Share on other sites
nbritton Report post Posted August 30, 2011 For this chart i am really needing the exit status and title. They are both var fields in the database. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 2, 2011 Hi, Both the fields Title and Exit Status are string type data hence chart is not giving the proper output, only solution to this would be to use grouping with Title and use "Count" function with "Exit Status" column. Share this post Link to post Share on other sites
nbritton Report post Posted September 2, 2011 I have attempted that with no luck. Here are the results attached. Thoughts?? fusionchartimages.doc Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 2, 2011 Hi, I am afraid, but you have not selected any Group by operation, Please check the attached image to know the steps. Share this post Link to post Share on other sites
nbritton Report post Posted September 2, 2011 grouping results.docoops i added the wrong doc for you. Share this post Link to post Share on other sites
nbritton Report post Posted September 12, 2011 Any thoughts Rahul?? Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 13, 2011 Hi, Could you please refer to the attached image and send us the result screenshot after clicking on 'Apply' button in Grouping Data step. Share this post Link to post Share on other sites
nbritton Report post Posted September 14, 2011 I have done this in the previous screen shoots. Nothing is present. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted January 6, 2012 Hi, We are pleased to inform you that We have released an updated version of the Collabion Charts for SharePoint (FusionCharts for SharePoint is now Collabion Charts for SharePoint) and request you to please try that once. Share this post Link to post Share on other sites
Guest vishal@fusioncharts Report post Posted February 20, 2012 Hi nbritton, Were you able to get this to work with the latest version of Collabion Charts for SharePoint? Thanks Vishal Share this post Link to post Share on other sites
