How can I supress a record in a group 1

[ldejesuspr]

I need to suppress printing a record when a
running total in a group meets certain
condition. Help will be appreciated.

thanks

 

[MadCatmk2]

If i understand you correctly you should be able to insert a formula in the section expert under the suppress option for details. Formula would be something as follows:


[running_total_field] > (condition)

Hope this helps

 

[QueSpr04]

ONCE YOU HAVE APPLIED THE FIELD ONTO THE PROGRAM, WHAT YOU CAN DO IS RIGHT CLICK ON THE FIELD AND GO TO THE COMMON TAB AND FROM THERE YOU SHOULD SEE THE OPTION CALLED SUPPRESS. IF YOU ENTER IN A CONDITIONAL FORMULA SUCH AS
{TABLE.FIELD} = 0 OR WHATEVER THE CONDITION IS, IT WILL SUPPRESS ALL CONDITIONS THAT MEET THIS REQUIREMENT.

HOPE THIS HELPS AS WELL.

 

[ldejesuspr]

thanks QueSpr4, it worked perfectly.

If I want to supress the complete record, do i have to do the same to every field in it or is there a better way to do it so it will apply to record?

thanks

 

[QueSpr04]

WHAT VERSION OF CRYSTAL ARE YOU RUNNING? BECAUSE IN CR10, THERE IS AN OPTION BUTTON THAT CAN SUPPRESS THE ENTIRE FIELD. SAY FOR INSTANCE YOU GROUP ON A FIELD BUT YOU DON'T WANT THAT PARTICULAR FIELD TO SHOW ON THE REPORT, YOU CAN CLICK ON THIS BUTTON AND IT WILL SUPPRESS THE FIELD. BIT IT ALL DEPENDS ON WHICH VERSION YOU'RE RUNNING.

 

[ldejesuspr]

I have version 9. I am interested in supressing the whole record that met the condition, not just the field.

 

[lbass]

You need to use the section expert as MadCatmk2 suggested. In 8.0 you would go to format->section->details->suppress->x+2 and enter:

{#yourrunningtotal} = <yourcondition>

Not sure where the section expert is in 9.0, but you might try right clicking on the gray area to the left of the report canvas and see if you see "Section expert."

-LB