Group Header is NULL, how can I get text to appear for that field??? 1

[lab509]

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.

Thanks!!!

 

[along73]

Create a formula field that would check for a null and replace whatever text you want to display and use that formula field in your grouping instead.

 

[MattMiller]

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)

 

[IdoMillet]

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.

http://www.MilletSoftware.com