Crystal Reports - Suppress formula repeated

Question

I have a Crystal Reports report, It contains 3 sub reports in 3 different details sections. (details a, details b, details c)

If I set suppress formula that use data from DB to the details section b and c

ISNULL({Table.Field})

When I generate a report the whole details section (a,b and c) is repeated multiple times and data duplicated from a 3-93 pages report.

My data is structured ads follow:

DataSource: ReportDS
Table: Client (Showed in details a)
 -Name
 -Surname
 -...
Table: Order (Showed in details b repeated for any order in datasource)
 -Date
 -Total
 -...
Table: Product (Showed in details c repeated for any product in datasource)
 -Name
 -Price

Section b suppress formula:

IF ISNULL({Order.Total}) THEN TRUE ELSE FALSE

Section c suppress formula:

IF ISNULL({Product.Name}) THEN TRUE ELSE FALSE

Right click on the details section b -> section expret -> suppress flag -> formula AND Right click on the details section c -> section expret -> suppress flag -> formula — Iaconis Simone
if its a single source then edit the question on what data you are showing in each of the detail sections and what is the condition you are using in supress on detail section b and c — Siva

gerard gerard · Accepted Answer · 2018-02-20T11:00:07

Have you tried adding the suppress command to the Format Subreport itself? Use its Format section.
If that does not work, bring the suppress command into the subreport and suppress all its sections.

Crystal Reports - Suppress formula repeated

1 Answers