How to supress a blank field and space in the report

[shil]

Can any one help me out? I have a report in which I am displaying 10
fields row wise. I wrote a formula not to show the field if that is
blank. So far so good... But blank space is not getting supressed. For
example if first two fields exists, they show up, if next four fields
are null, they don't, then if the last two in ten exist, they show up.
so my reult look like this.

Field1
Field2



Field7

Field9
Field10

How can I supress the blank space? I have read that we can set
CanShrink property to Yes. But I don't see that property in the version
I am using(CrystalReports 10.0). Can any one drive in the right
direction?

 

[Rick Brandt]

Can any one help me out? I have a report in which I am displaying 10
fields row wise. I wrote a formula not to show the field if that is
blank. So far so good... But blank space is not getting supressed. For
example if first two fields exists, they show up, if next four fields
are null, they don't, then if the last two in ten exist, they show up.
so my reult look like this.

Field1
Field2



Field7

Field9
Field10

How can I supress the blank space? I have read that we can set
CanShrink property to Yes. But I don't see that property in the
version I am using(CrystalReports 10.0). Can any one drive in the
right direction?

If you are using Crystal Reports then this is not an Access question. I
suggest you ask in a group that concerns itself with Crystal Reports.

If you were using Access' report tool then you would have no trouble finding
CanShrink.