Help with a Crystal Report
Posted on 2009-02-18
Greetings..I am having some trouble creating a report on Crystal Reports XI:
I have a single table that has all the data I need to work with.
- ID (Primary Key)
Q1 through Q5 are questions that contain string values ranging from 1 to 6.
What I need is to come up with a report that will show a Table, with 6 columns: Region, Q1, Q2, Q3, Q4, and Q5, where each line will have the region and percentage of values for each question that were marked as 4 or 5, with regard to the total for thet region (provided the answer wasn't 6).
In other words something like:
Q1 Q2 Q3 Q4 Q5
Region1 90% 56% 23% 67% 12%
Region2 80% 87% 11% 34% 78%
Where each percentage is calculated as:
For every Q column
(Total amount of entries where Qx = 4 or 5 )DIVDED (Total amount of entries where Qx <> 6).
I hope that was clear enough to state the problem I'm having. I want to do as much of the calculation on the Crystal Side to avoid taxing the Database. I've tried fiddling with functions and summary fields but go nowhere.
Anyhelp would be greatly appreciated and rewarded.