CODEWITHSUNDEEP
crystal-reports
Zain Ali
Zain Ali

Reputation: 15953

Suppressing empty fields in crosstab

Suppressing lines in a cross tab crystal report

We currently have a cross tab report having a summary with 4 fields placed in a single section, sequentially one below the other.

If one of the fields are blank for e.g. 4 fields are named as f1, f2, f3, and f4 if f2 is blank we need to suppress this section to displaying a total of 3 lines. I.e. displaying fields f1, f3, f4.

Is this possible in crystal reports 10.0. This would save the display space of the report also present a consistent look to the report.

Please refer to the attached image which may help understand the problem. Please see this for further details

Upvotes: 0

Views: 6857

Answers (2)

Zain Ali
Zain Ali

Reputation: 15953

I solved this by! Go to Cross Tab Expert and ,Customize Style And select desired row and then check Suppress SubTotals in group options.

Upvotes: 3

Marc
Marc

Reputation: 778

IF I understand your question,

If you are using the built-in Cross-Tab object, then rows/columns will drop automatically if there is no data to populate a full row or column. This is standard behaviour of the object.

If you are mimicking a cross-tab using groups or rows, you can conditionally suppress either group or row based on a formula. This can be done in the Section Expert using the option Suppress (No Drill-down) by clicking on the "formula" symbol.

If I misunderstand, then please explain again.

Upvotes: 0

Related Questions