Skip to main content
Conga Support

Using Detail Regions with If Statements

When using Detail Regions with IF statements it is important to consider whether your report has the possibility of returning no data, in which case your IF statement could be deleted if not set up properly.  To avoid this issue you will have to isolate your TableStart/TableEnd to a line by itself.

If all your merge fields in an IF statement are coming from detail data, enclose the entire IF statement with TableStart and TableEnd fields, but leave them outside the IF statement. That way, if your report returns no data, it won't break the IF statement.

For more information, see the article called Conditionally Remove a Row in a Table that Has no Data.

 You must use traditional merge fields (not text-based fields). The examples below are toggled open.


{IF "<<CASE_STATUS>>"="Closed" "<<Close_Date>>" "Open" \ * MERGEFORMAT }


If only one of the Fields in an IF statement is being populated by detail data, you'll want to enclose ONLY that field in TableStart/TableEnd fields, and make sure this field has its own line.


<<TableStart:Case>> "<<Close_Date>>" <<TableEnd:Case>>


Maybe you have two different detail datasets you want to compare in one IF statement. The process for this is simply an extension of the above technique, where each dataset needs its own row.


"<<TableStart:Case>> <<Close_Date>> <<TableEnd:Case>>"

"<<TableStart:Opportunities>> <<Close_Date>> <<TableEnd: Opportuntities>>"