OraFAQ Forum: Reports & Discoverer » Exclude 1 Group in Report

Home » Developer & Programmer » Reports & Discoverer » Exclude 1 Group in Report (Report Builder 6)

Mon, 29 November 2010 01:57

fraction
Messages: 29
Registered: November 2010
Location: Pakistan

Junior Member

I want to show all the data except 1 organization, Report is grouped on organization. please tell me how to do that.

Thanks.

Mon, 29 November 2010 02:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't select that group's records.

select ...
from ...
where group <> '1 organization'
  and ...

Or, create a format trigger on group's repeating frame:

return (:group <> '1 organization');

Mon, 29 November 2010 02:47

fraction
Messages: 29
Registered: November 2010
Location: Pakistan

Junior Member

thanks. I created a format trigger.

Previous Topic:	REP-0002 "Unable to retrieve a string from the report builder"
Next Topic:	Calling Report from Form asking enter Password

Goto Forum:

]

Current Time: Mon Dec 02 10:05:17 CST 2024