Suppressing output

[MegOBytes]

Crystal Reports: V10
Data Source: MS Access

First question: does suppressing a field simply not print it but leave the field space on the report?

I have a report with 5 description fields. fields are stacked above each other in the detail section. most of the time, fields 3 thru 5 are blank. I want to be able to eliminate (as in not print a blank space) the any field where there is no value. I have tried checking the 'suppress' box and used a condition such as:
Isnull({fieldname}) but that does not seem to prevent the blank field from "printing" as in take up space.

Any thoughts?

RP



Rick Piekos
Massachusetts

 

[Madawc]

If you put your fields in a text box, it can be told to leave out blank lines. Right-click on the text box, Format Text > Common tab and choose 'Suppress Embedded'

This also required you make the text box smaller and choose 'Can Grow'.

You can also do this within a formula field - Chr(13) is line skip

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[MegOBytes]

Thank you, the text box approach worked just fine.

RP

Rick Piekos
Massachusetts

 

[lbass]

Or you can place the fields in separate detail sections, a,b,c, etc., and then in the section expert, format each section to "suppress blank section".

-LB