Crystal Reports 8.0 Charting Problem 1

[Roser]

I am creating a chart that is reporting on a small amount of data. The data values can be 1 to 5. If I only have values of 3, 4 and 5 in my database the chart will not leave a space for where the 1 and 2 would have shown up at. I need to be able to show the chart with 1 and 2 as just and empty column along with the 3, 4 and 5 that has values in it. I am a beginner on CR and am looking for any advice.

 

[kenhamady]

A chart will only chart existing groups.
You have to get these other groups, somehow into the report. If you describe the report in more detail, we might be able to point you in the right direction. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Roser]

Ken,
The database consists of people's responses of a course evaluation. The table lists the course name ( course 1, course 2...) then the first questions answer ( 1,2,3,4,5 ). When I have a 1,2,3,4 and 5 in the database the chart will graph the percentage of students that choose 1,2... However when the students only picked either 3,4 or 5, the chart doesn't leave a blank space showing that no one choose 1 or 2.

I am grouping the data per "course name" and "specifing the order" I want them to appear on the chart. On the chart expert on the "data tab" I have selected "on change of" and picked the question number I am wanting to graph. I am showing the values as "Percentage of count of question number" and summarizing as a "percentage of the grand total".
Please respond with and other info needed about this chart. Thanks.

 

[kenhamady]

How many tables are in this report?
Do you have a table that lists all of the questions?
How many different questions are you charting?
What version of CR are you using? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Roser]

There is one table with each of the students entire survey as one record ( ex. CourseName, CourseDate, Question01, Question02, ...). I have a total of 28 questions but will only need to "chart" 3 of these questions. I have all of teh questions in a different table ( Question01 = Blah Blah, ...). I am using CR 8.0 Developer Edition. I am willing to redo everything if I need to. I appreciate your help, Thanks.

 

[kenhamady]

Is this correct?

Each course has 28 questions and you are only charting 3 of those 28 questions. Each question has a value 1 to 5.

You want 3 charts per course, one chart per question, with 5 bars per chart showing how many of each value?
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Roser]

This is generally correct.

Each student filled out a course evaluation after taking the course. Each evaluation had 28 questions on it. Each evaluation equals a record in the database table. Each question can be 1 to 5 (Strongly Disagree, Disagree, Neutral, Agree or Strongly Agree with what the question asked). I want to chart only 3 of the 28 questions for each of the courses.

So after all that I will have 3 charts on each of the courses that the students took. This way future students thinking about taking the course can see what previous students thought of the course based on the course evaluation results.

The charts will need to show percentages like 10% disagree, 50% neutral, 40% strongly agree. However when I chart the previous example, CR 8.0 doesn't show that "0%" of the students "strongly disagree" or "agree". Thanks a bunch.

 

[kenhamady]

We are getting close.
So there is one field per question in each record - 28 questions fields, each with a number 1 to 5.

You will group by course and take the same three questions for each course?
Is the 1 to 5 value a numeric?
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Roser]

This is correct. The "1" to "5" value is numeric. I am currently grouping by the course name. In the group header I have three charts, one for each question I am charting.

On these charts they will only show "3", "4" and "5" if I don't have any "1"s or "2"s. If I modify the database and add two bogus records, one record with a "1" and one with a "2",after refreshing the data, the chart will show five bars ("1" thru "5&quot. Crazy huh?!?!?

 

[kenhamady]

Actually, that is expected behavior, a GROUP chart will only chart existing groups. You can get an advanced chart to do what you want like this:

Create five formulas for each question field like these five:

Name forumula
QA1 If Q1Val = 1 then 1 else 0
QA2 If Q1Val = 2 then 1 else 0
QA3 If Q1Val = 3 then 1 else 0
QA4 If Q1Val = 4 then 1 else 0
QA5 If Q1Val = 5 then 1 else 0

Now do a subtotal of each of these for each class. And finally add an "advanced" chart:

Print Chart = Once Per Class Name (your group field)
On change of = Class Name (your group field again)
Use the 5 subtotals as the 5 summarized fields.

This should give you what you want. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Roser]

That worked great! You have no idea how much time and stress you saved me. People like you are the reason that sites like this stay in business.

Thank you Ken, and Thank you Tek-Tips.com