Crystal Reports - Display subreport when main report field is null

Question

Crystal Reports - If a field in the main report is null, I would like to display a subreport, else display the field that is in the main report.

heringer heringer · Accepted Answer · 2017-11-08T15:32:46

I will suppose your field is in the header section (but the idea works for other cases).

Create another header section (right click header section and click insert section below).
Put your subreport in this new section.
In the "section expert", set a "suppress" formula for this new section:
```
isnull({TableName.FieldName})
```
Evaluate if it is worth to set the "suppress" formula of the field or the suppress formula of the other section (maybe is not need, since the field has no value):
```
not isnull({TableName.FieldName})
```