I am using CR8.5 with Oracle 8i
In my main report, I have a list of Offenders that are being tracked by an officer. So I have my Officers in Group 1 and the Offenders in Group 2. Detail section A contains personal data about the offender. The detail sections B through P contains subreports that selects any database activity detected in the LastFullWeek involving the offender (i.e., Citations issued, Court Appearances Made, Warrants Issued/Served, etc). If no activity is detected, then the Subreport is suppressed (I have no problems with this part).
The following is a report layout.
Group Section 1 Officer
Group Section 2 Offender
Detail Section A - Personal info on Offender
Detail Section B - Activity on Table B in LastFullWeek
Detail Section C - Activity on Table C in LastFullWeek
...
Detail Section P - Activity on Table P LastFullWeek
What I am looking for is a reverse suppression. Here's what I want to do. If there was no activity found for a given offender, then I don't want to see it.
So, if there were no subreports printed in Detail Sections B through P for a given offender, then suppress the Group 2 record (offender) as it's associated Detail Section A in the Main report. And if there are no offender records for an officer then suppress the Group 1 section as well.
Am I making sense? It would sure be a lot easier than trying to do it with the SQL unions and exists statements I currently have to include on the DataBase... Show SQL pop-up window.
WichitaKid
In my main report, I have a list of Offenders that are being tracked by an officer. So I have my Officers in Group 1 and the Offenders in Group 2. Detail section A contains personal data about the offender. The detail sections B through P contains subreports that selects any database activity detected in the LastFullWeek involving the offender (i.e., Citations issued, Court Appearances Made, Warrants Issued/Served, etc). If no activity is detected, then the Subreport is suppressed (I have no problems with this part).
The following is a report layout.
Group Section 1 Officer
Group Section 2 Offender
Detail Section A - Personal info on Offender
Detail Section B - Activity on Table B in LastFullWeek
Detail Section C - Activity on Table C in LastFullWeek
...
Detail Section P - Activity on Table P LastFullWeek
What I am looking for is a reverse suppression. Here's what I want to do. If there was no activity found for a given offender, then I don't want to see it.
So, if there were no subreports printed in Detail Sections B through P for a given offender, then suppress the Group 2 record (offender) as it's associated Detail Section A in the Main report. And if there are no offender records for an officer then suppress the Group 1 section as well.
Am I making sense? It would sure be a lot easier than trying to do it with the SQL unions and exists statements I currently have to include on the DataBase... Show SQL pop-up window.
WichitaKid