I have a group header that returns a NULL value, but I want to actually put text in that field to say "Blank" or "Subtype not entered". Not truly leave the field invisible on the report.
Create a formula field and there should be a property for visible. Write a statement where is the field isnull you print text, if not you display the field:
If (IsNull (field),"Blank", field)
Actually, you don't need to change what you are grouping on to solve this.
Go back to the Group dialog (Report, Chenge Group Expert, Options...).
Turn on the "Customize Group Name Field" option.
Select the "Use a Formula as Group Name" option and enter an expression such as:
-----------------------------------------------
IF IsNull {your_group_field} THEN "Blank" ELSE {your_group_field}
-----------------------------------------------
The key advantage of this approach is that your Group Tree will show the "Blank" node with its proper name.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.