CODEWITHSUNDEEP
asp.netcrystal-reports
chamara
chamara

Reputation: 12709

Crystal Reports Hiding Columns

I have a crystal report with several columns.i need to hide a column and remove the blank space based on a condition.currently what i have done is.i have dragged and dropped the fields inside TextObject and tick the "Suppress Embedded Blank Field Lines" and "Can Grow".it'll hide the detail field and also remove the blank space but the issue is header is still visible.

condition to hide a column is if the field data is null or empty

Upvotes: 0

Views: 3422

Answers (1)

paulmelnikow
paulmelnikow

Reputation: 17218

Try creating a formula for your conditionally displaying column heading. Something like:

SomeFieldLabel:

If DistinctCount({@SomeField}) > 0 Then "The Column Label"

or 

If Not IsNull({@SomeField}) And {@SomeField} <> "" Then "The Column Label"

Then create a text object with {@SomeFieldLabel} and all your other labels, and select Suppress Embedded Blank Field Lines.

You may need to experiment to find the right condition – one which evaluates to True whenever the field is present in your detail records, and False the rest of the time.

Upvotes: 1

Related Questions