Skip to Content

suppress detail grid if no records

Dec 21, 2017 at 09:19 AM


avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vitaly Izmaylov
Dec 29, 2017 at 06:01 PM

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})



10 |10000 characters needed characters left characters exceeded