Keep Details Section Together

[Hillary]

I am working on customizing a build-in report that came with our software. The report has 1 Grouping, Data.DefaultStudentSort, and 13 Details sections. The data cannot be seen through Crystal; the report has to be uploaded into the software for any data to show.

I am trying to keep the Details sections together. There are no subreports. The Course Name and Course Grade are in Details b, the Teacher Name is in Details c, the Absents are in Details E and the Comments are in Details F.

Many of the reports run onto a second page (depending on how many courses a student took and if comments were given). Some of the reports split the Course so the Course Name and Grade are on one page and the Teacher, Comments and Absent Values are on the second page. Ideally, I would like the Course to stay together and have the Course Name, Teacher and Grade roll onto the second page.

In the Selection Expert, Details and each sub (Details a, Details b, etc...) have Keep Together checked.

I tried adding another Group - Course Name - and even though the Group was suppressed, it messed the report up.

CR 9.0
SQL

Thanks in advance for any help,


Hillary

 

[synapsevampire]

Try explaining what " it messed the report up." means in technical terms.

If you have a course group, right click it and select change group, and then in the Options tab select Keep Group Together, that should help.

-k

 

[Hillary]

The reason I added the Group was so I could use the Keep Group together option. Adding the group did not work.

Note: that in order to see the data it was uploaded into our live db. As soon as I saw extra data reporting, I pulled the report out. I didn't spend much time analyzing it. I added the group and suppressed it so I didn't expect to see anything reported differently, when I did, I pulled it. No technical term for messed up...just data (courses) that weren't expected.

This report is not build off typical tables. For example, the grades, and absents and credits are all listed on the report as [P1]. They are each in a different Detailed section with a suppression {Data.Kind} <> {@DetailTypeCourseName}, {Data.Kind} <> {@DetailTypeGradeItem} and {Data.Kind} <> {@DetailTypeTotalCredits}. The report is build off a single "table" with fields like P1 (all the way through P31). There is no reference to which each means.

I'm looking for a way to keep Detail sections from splitting. Most of the other posts I've looked at have to do with subreports so I'm not sure how to handle this specific situation.

Thanks,

Hillary

 

[synapsevampire]

Adding the group should work, and if you are experiencing row inflation (a term you might want to look up), placing the fields in numerous group footer sections might alleviate your problem.

If you really want technical assistance, post example data and the expected output rather than trying to explain the scenario.

-k

 

[Hillary]

The example data is posted in the third paragraph of the original post.

I have no control over the code which controls this report. Like I tried to explain, this is not a typical report build off tables which, (to me) explains why the Course is not grouped in the first place.

I'm looking to see if there is another way to control the way which Details report. Thank you for your suggestion of adding a group but that is not feasible in this case.

Hillary