cancel
Showing results for 
Search instead for 
Did you mean: 

suppress detail grid if no records

Former Member
0 Kudos

hello all, I'd like to know how supress a group detail grid if there's no record to show. In my case, my report has 3 pages and I print the total amount only in the footer of the last page.

So in the first page the products grid is full of records, the second page too and in the third page there's no products to show, only the footer has to be printed. In this third page, CR shows the detail grid empty and print the footer inside the empty grid.

The design of my report is composed by a report header, a Invoice document group, a product group, product footer, invoice footer, report footer.

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

vitaly_izmaylov
Employee
Employee
0 Kudos

Right-click the Details section > Go to Section Expert and Check Suppress Blank section.

If it does not help, at the same Section Expert use Manual Suppress formula based one of the following formulas like:

IsNull ({YourField})

{YourField}=""

{YourField}=0

Answers (0)