Print Data on Same Line

[Hillary]

I have a subreport which brings in courses and grades for a student. Groups 1 and 2 are two different Student ID's, Group 3 is the Course ID and Group 4 is the Bin (Bin are basically like Quarters - Quarter 1 = Bin 1, Quarter 2 = Bin 2, Quarter 3 = Bin 3, Quarter 4 = Bin 4, Class Exam = Bin 5, State Exam = Bin 6 and Final Grade = Bin 7)

The subreport has GH1 and GH2 supressed. GH3 has the course name and number. GH4 has the Bin field 3 times all with different suppress values (suppress all but Bin 5; suppress all but Bin 6; suppress all but Bin 7).

When the report prints, I want it to print both Exams and the Final Grade on the same line.

For example,
English 80 83 87
Math 92 85 90

What the report is doing now is printing the Class Exam on one line, the State Exam on the second line and the Final Grade on the last line.

For example,
English 80
83
87
Math 92
85
90

I know Crystal is designed to break at the group and since I have GH4 as Bin and the scores are all in different Bins it's doing what it is supposed to be doing, but is there a way to get the report to print all the scores on one line? I have Underlay Following Sections already checked for Groups 3 and 4.

Thanks for your help!

Hillary

 

[lbass]

You could try removing the group on Bin and then creating a a formula to be placed in the detail section for each of the three bins under consideration, as in:

//{@bin5}:
if {table.bin} = 5 then {table.grade}

//{@bin6}:
if {table.bin} = 6 then {table.grade}

Then right click on each formula and insert a summary (maximum) at the course ID group level. Then suppress the detail section.

-LB

 

[BruceBussell]

Have you tried putting each Bin in a Different Group Header (ie) GH1 to GH7 and putting each Bin just to the right of the one above it, and then checking UnderLay Following Sections for all the group headers except the last one = GH7 to get all the scores to appear on one line.