DS Multi-Pro Whey Isolate Blend Crystal Reports: Widows and orphans in grouped reports
Crystalkeen logo
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money




CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us

on Steroids

Crystal Reports: Widows and Orphans in Grouped Reports

This article, courtesy of Cindy Kredo (Access development/software solutions/training) www.cindykredo.com

Crystal Decisions Kbase Articles C2000973, C2000972 and C2008983 provide solutions to report widows and orphans in grouped reports.

Users often want both widow and orphan control. If they use the Crystal solution to prevent widowed group headers and widowed group footers, it works fine only when every group has more than one detail record.

Those groups that contain one detail record will get duplicated: the same record appears twice in the report.

One solution is to add a conditional format formula to the Group Footer A section that suppresses the section if the count of the records in the detail section (for that group) is equal to 1.

Widows and orphans are unfortunate artifacts of written language. In addition to the solution above, you can reduce their occurrence by using simpler words and shorter phrases.

For example:

  • Use "To" instead of "In order to"
  • Eliminate modifiers. If something is dangerous, it deserves attention. Saying it's "very" dangerous doesn't change that.
  • Use "here" instead of "this location."

Flatulent word usage is an epidemic, these days. Not only does it contribute to the widows and orphans problem, it detracts from clarity. Don't use two or three words when one will do.

As you use simpler words as part of your widow and orphan control strategy, an interesting thing will happen. Your reports will have more punch. People's eyes won't glaze over as they try to digest high-falootin' words and words with many syllables. Give them the plain English, straight-up.

Take any report you now have, and look for words greater than one syllable. See if you can substitute a single-syllable word in its place. Then, read the report once this is done. Sound better to you?


This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


  • Questions? Please write to mark@crystalkeen.com. We do want your business.
  • Do you have your own tips for Crystal Reports administrators and designers? Write to mark@crystalkeen.com and we'll post your tips with a link to your Website (or with some other attribution if you choose).
  • Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.