I have questions in database table and possible answer choices for each question. What I need to do is show a chart for each question and show the answers of the questions graphically. I have written an stored procedure that selects questions and their answers, and in the report I have grouped the questions. For showing multiple charts, I need to place the chart in the detail section but it doesn't allow me to place the chart in detail section. What is the way in the crystal report to generate charts based on the data.
Thanks.
Last edited by usamaalam; Dec 20th, 2006 at 02:35 AM.
Well , if u have make the sp correctly , and in chart u have define the fields of x and y then u dont need to put it in the detail section , it will run correctly in the footer section.
Still if it is the problem , then send me the sp , i will look into it.
I can't put it on header or footer sections since I need to generate the charts based on the data. Please see the attached image, there is a QuestionID. I need to generate one chart against each QuestionID. For Question ID 10, I need to show Answer choices on a pie chart, and for Question ID 15, I need to show answer choices on another pie chart and there can be any number of questions. This resultset basically shows answers people have selected for two questions.
Yes, I need to generate charts that can be of any number. I don't need to show one chart for each row, I need to show one chart for each Question ID i.e. in this example, one chart for Question ID 10 and one chart for Question ID 15 and so on.
This way we can show answers of each question graphically.
Reply With Quote
