I am new to Oracle reports. I have a report with multiple report blocks. How do I suppress the report block and it's headings if there are no records for that report block?
A good trick is to created a dummy group:
- Modify your select statement adding a new column with a constant e.g. 1 AS "dummy"
- Make a parent group containing only "dummy" (other columns in child group)
- Create a repeating frame covering your existing repeating frame with the source of the dummy group
- Place headers inside this frame
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.