suppressing data

[jomarelectric]

cr10

how does one go about suppressing an entire row if say one of the fields is blank or begins w/ a '-' (-303.00, etc.)

thanks as always.

 

[AngelB]

Hi there

Right-click on the relevant section on the left hand side in design mode and choose 'Section Expert' or 'Format Section' depending on your version of crystal. There is a button labelled 'X-2' alongside the suppress option. In here enter something along the lines of

field_name = "" or mid(field_name, 1, 1) = "-"

Hope this helps


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[synapsevampire]

Better still, eliminat it from the data being returned using:

Report->Selection Formula->Record and place:

(
not(isnull({table.field}))
)
and
(
not({table.field} startswith "-")
)

Suppression will still use the rows in summaries, etc., the above will eliminate them completely.

-k

 

[jomarelectric]

ah, that seems like the way to go, only i currently have a formula there.

{INIH.INVCDAT} in {?start} to {?end} and
{INIH.SALREP} = {?rep} and
not ({INIH.INVOICE} startswith "X")

this is what i have currently.

can i integrate the new code?

 

[jomarelectric]

nevermind the last post. my mistake.