Crystal Reports problem
Posted on 1998-12-21
Hello everybody I have the following report that I have to create, but I don't know how I would go about doing it within Crystal.
What I want to do is display the seq_no and quest_text from a table called audit_detail on the left hand column. This will go in order seq_no 1 through whatever and the corresponding text. It is kinda difficult to explain with words what I want on the right hand side, but I'll show you an example.
Left Side Right Side
1 Authorized POG Dealer 1 89.3%
2 # of clipstrips 0 90.7%
Know what the above shows is how many people answered question 1 with a response of 1, 2 in the first question and 0, 1, 2 in the second question. This information is display in the answer_detl table in a field called answer there is also a seq_no in this table which links back to the original table. There is one more table called answer_header which contain a field called survey_code (there is also a survey_code in the orginal table that is linked to this). This table is linked to answer_detl by a field called answer_key.
I do not know how to go about listing each answer that was given for each question and the finding the total percent