I'm having a problem with a cross tab report. I am building it around school courses (rows), possible grades (columns) and the values in the columns as the summarized field. My problem is when a course doesn't have any data for a grade, the grade is not returned and made part of the cross tab object. I have been asked to solve this in Crystal as I've been told doing it in the SQL would have a negative impact at the DB server. I was hoping to bring all the grades for a course/categories in with a sub report and then share the values with the cross tab. Is this possible? Below is an illustration of the problem and what I would like to happen.
Problem:
AO Area of concern Good
MATH
Interpets Stories X
Solves Problems X
Multiplication Tables X
Area of concern Good
Social Studies
Reading Maps X
Understands concepts X
Retains Information X
What I need it to do
AO Area of concern Good
MATH
Interpets Stories X
Solves Problems X
Multiplication Tables X
AO Area of concern Good
Social Studies
Reading Maps X
Understands concepts X
Retains Information X
Does this make any sense?
Thanks for you help,
Chris
Problem:
AO Area of concern Good
MATH
Interpets Stories X
Solves Problems X
Multiplication Tables X
Area of concern Good
Social Studies
Reading Maps X
Understands concepts X
Retains Information X
What I need it to do
AO Area of concern Good
MATH
Interpets Stories X
Solves Problems X
Multiplication Tables X
AO Area of concern Good
Social Studies
Reading Maps X
Understands concepts X
Retains Information X
Does this make any sense?
Thanks for you help,
Chris