Crystalkeen logo; we offer Crystal reports viewers and schedulers
 
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money

  Resources  

Articles:
Administration
Advanced
Basic
Database
Financial

Tools:

Analyzers
CR Schedulers
CR UFLs
CR Viewers
DataBase Tools
Graphics
International
Mail UFLs



 
 

Add'l:
About us

Contact Us
 

CrystalReports
on Steroids

Crystal Reports: Group Expert

The Group Expert is a quick way to see what fields you are using for groups in your report. It also provides an easy way to shuffle the groups around into the sequence you require.

One feature we like (in CR9 and above) is you can "undo” after you have used “delete group.”

group expert

 

Steve Dowse from Business Objects in Sydney reminded us that (with Crystal Reports 9.0 and above) you can group on the same field more than once. This lets you use a field for specified order and then within that group you can group by individual values of the fields.

Earlier version users need to create a formula that uses the group field. You then could group on the formula.

Overflow problems?

What if you have a large group that flows over to a subsequent page? How do you control the report so the headings re-appear on each page as the group continues?

When you create the group, select the option "Repeat Group Header on Each Page." This will cause the group header to appear on each new page. If you have forgotten to set this, you can change an existing group, and set it later when you need to.

Here's another tip on this subject:

Display “Continued” when a group continues onto a new page. It can also be useful to display the word “Continued” when then the group header is not the start of the group. Place this formula in the group header section:

If InRepeatedGroupHeader then “Continued” 

See also:

 

 

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.