Skip to Content
avatar image
Former Member

suppress detail grid if no records

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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})

    {YourField}=""

    {YourField}=0

    Add comment
    10|10000 characters needed characters exceeded