|
There are a couple of things that you can try for this:
1. If you need all of the data, but just don't want to see duplicate details you could add an inner group on the formula (not the field!). Put your data in the group header, suppress the details and the group footer.
2. If you don't need the other data, go to the Select Expert and add {MGCOMP01.OPDESC}="PLATEMAKING" to the selection criteria. If you have an outer join to the MGCOMP01 table and you want to show other data, but only this detail line, you would change the formula to:
(
IsNull({MGCOMP01.OPDESC}) OR
{MGCOMP01.OPDESC}="PLATEMAKING"
)
This process will limit the data coming from the database and make the report run faster if you don't need all of the details.
3. For the section (Details, I assume), you could suppress the section based on whether or not {MGCOMP01.OPDESC}="PLATEMAKING". You'll be pulling more data into the report than you may need, but you'll only have the one row appear.
-Dell
|
IP Logged
