Self Reference 1

[Teduken]

Hello. I was just wondering if anyone know if there is syntax for referencing an object itself. In other words I have a report with about 30 Running total fields, which I want to suppress if their value is less than 50. Usually I would use something like: {MyValue} < 50 in the Section Expert Formula section. What I would like to do is highligh all the fields and conditionally suppress them by making generic reference to themselves. Something like:
me < 50 where "me" is the VB syntax for the current object or maybe something like . < 50 which is DOS syntax for the current directory? If this isn't possible seems like it should be cause it is gonna be a pain to go to each field and suppress it like:
{MyValue1} < 50
{MyValue2} < 50
{MyValue3} < 50 etc.
Seems reasonable because I know there is functionality to suppress values that are null or 0.
Hope this makes sense. Thanks for any info you all have.

 

[kskid]

Go into Select Expert, click on Formula Editor and then click on group selection and enter your formula

{myValue} >= 50

This shyould give you only those groups whose count is greater or equal to 50

-LW

 

[Teduken]

Thanks, but that won't work. At least not the way I have things set up. Let me see if I can make this more clear. My report looks something like this:

Page Header
Group Header: School
Details - Hidden
Group Footer: School
#WhiteStudents
#AfroAmericanStudents
#HispanicStudents
Page Footer

So my intent is to suppress the Running Total Field Objects if the count is less than 50. The only way I know how to do this is to right click on a field (i.e. #WhiteStudents) then go to the format object. Click on the common tab and then the "X-2" (formula editor) for supression. Then type in the formula {#WhiteStudents} < 50

What I would like to do is "shift"-"click" all the fields:
#WhiteStudents
#AfroAmericanStudents
#Hispanic
Then right click -> common tab -> formula ... and type in something that works for all the fields.

IF "This Field - the current field being processed" < 50 Then True (Suppress)

I don't know if this makes if more clear or more confusing? Oh well all I can do is throw it out there ; )

 

[lbass]

You can use the shift key to select all running totals in the group footer and then right click->format objects->suppress->x+2 and enter:

currentfieldvalue < 50

-LB

 

[Teduken]

Thanks "LB" that is EXACTLY what I was looking for. You are a godsent. Damn I wish I would of thought of looking for this a few months ago. I don't know how much time I have wasted when I could of used that.