Is anyone aware of a SET command to change/print a dash (-) ...

[Guest]

Hi Terry

One route would be to try to make the field youre printing be a field that can be MISSING.

Heres how you might do this for the CAR file. I jammed in a zero - well, actually a MISSING on one car/model so we could see the SET NODATA work.

DEFINE FILE CAR

-* Force in a zero for testing on a 6,000 car.

-* leave it 'MISSING ON' so you can use SET NODATA = '-'

ZERO_COST/D12.2 WITH DEALER_COST MISSING ON =IF DEALER_COST EQ 6000 THEN MISSING ELSE DEALER_COST;

END

TABLE FILE CAR

PRINT

MODEL

DEALER_COST

ZERO_COST

WHERE CAR EQ 'BMW'

ON TABLE SET NODATA '-'

END

 

There are other ways of course.

Just at thought

Toby

[Terry Engle 2]

Is anyone aware of a SET command to change/print a dash (-) instead of a zero in a report

[Debra Waybright]

Using the NODATA was my first thought, too. You could also DEFINE a field and set it to - when it is 0.

Deb