×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Crystal Reports 8.0 Charting Problem

Crystal Reports 8.0 Charting Problem

Crystal Reports 8.0 Charting Problem

(OP)
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.

RE: Crystal Reports 8.0 Charting Problem

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)

RE: Crystal Reports 8.0 Charting Problem

(OP)
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.

RE: Crystal Reports 8.0 Charting Problem

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)

RE: Crystal Reports 8.0 Charting Problem

(OP)
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.

RE: Crystal Reports 8.0 Charting Problem

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)

RE: Crystal Reports 8.0 Charting Problem

(OP)
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.

RE: Crystal Reports 8.0 Charting Problem

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)

RE: Crystal Reports 8.0 Charting Problem

(OP)
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").  Crazy huh?!?!?

RE: Crystal Reports 8.0 Charting Problem

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)

RE: Crystal Reports 8.0 Charting Problem

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close