Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In Oracle Reports, how do you suppress report block with no records?

Status
Not open for further replies.

corridor

Programmer
Oct 8, 2003
1
US
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

Timo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top