This is a migrated thread and some comments may be shown as answers.

Use SQL Datasource to populate Charts

7 Answers 49 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Eric Klein
Top achievements
Rank 1
Eric Klein asked on 18 Dec 2012, 09:42 PM
Ok I have looked through alot of the documentation and I just don't get it.  This should be easy.

I have a sql query that is used in as the datasource for the report.  It displays the data in a a cross tab table.  I then want to take the percentages, some are in the query others are determined at run time of the report.  I want to create a bar chart that has the Categories across the bottom and the percentages as the y.

I would also like to use the same data set to build a pie chart.  I can set the datasource to the chart but I can not see any way to set the x and y axis to the fields I want displayed

7 Answers, 1 is accepted

Sort by
0
jayanthi
Top achievements
Rank 1
answered on 19 Dec 2012, 08:52 AM
Add a series to Pie chart and then assign DataYCoulmn value.
0
Eric Klein
Top achievements
Rank 1
answered on 19 Dec 2012, 01:32 PM
I have the crosstab located in groupheader and I have placed the chart in the Details.  I add the sqlDatasource as the chart datasource, I then open the series I add a series I go to the DataYColumn I click the dropdown arrow but there is nothing there.  How do I add the data fields to the columns?
0
Massimiliano Bassili
Top achievements
Rank 1
answered on 19 Dec 2012, 02:15 PM
Enter the column name manually, the chart series editor would not list them. If you check the Telerik examples, you would notice the same design behavior.
0
Eric Klein
Top achievements
Rank 1
answered on 19 Dec 2012, 02:31 PM
I have included the settings I have set in the attachment.

WHen I run the app I get an error 
     An eorror has occured while processing Chart 'chart1':
    Cannot set Column 'FGID' to be null. Please use DBNull instead.

I am unsure how it is getting the FGID.
0
Eric Klein
Top achievements
Rank 1
answered on 19 Dec 2012, 05:31 PM
Ok it looks like none of the fileds can have a null in, even if it is not used. 
0
Accepted
Steve
Telerik team
answered on 20 Dec 2012, 08:52 AM
Hi Eric,

This has been fixed in the Q3 2012 version, namely: Fixed: Chart cannot work with null, requires DBNull. Upgrade to resolve the issue.

Regards,
Steve
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Eric Klein
Top achievements
Rank 1
answered on 20 Dec 2012, 01:53 PM
Thanks the update fixed the issue.
Tags
General Discussions
Asked by
Eric Klein
Top achievements
Rank 1
Answers by
jayanthi
Top achievements
Rank 1
Eric Klein
Top achievements
Rank 1
Massimiliano Bassili
Top achievements
Rank 1
Steve
Telerik team
Share this question
or