supress fields for ungenerated data

[MTarkington]

Good afternoon,

Crystal 10
Intersystems Cache Database

I currently have a report that has a detail line that contains better than 40 fields. The detail line alone spans 3 pages. Roughly, it is every field in the table in this format:

Address: 123 Any Street
City: Any Town
State: CA

Now, because all of the data is listed down the page with the headers on the left and the field on the right, I need to find a way to supress the header if the field is blank.

I know how to supress the field such that it show no data, but is there any way to move all of the data up if the field is blank?

Example: If City above is blank, I want it to show up like this:

Address: 123 Any Street
State: CA

Has anyone done anything like this or know of a way to supress an 'area' of the detail line?

Any input or advice is appreciated.

TIA,
Mark

 

[synapsevampire]

The standard way of doing this (and you're going to hate this), is to right click the details and select insert section below better than 39 times.

Then place each header/field in it's own section, and in the suppress for the section use code of:

isnull(table.field}
or
{table.field} = ""

Note that the above check will change based on the data types.

It's really the best way to handle this.

-k

 

[Turkbear]

Hi,
One way to handle that would be to insert all the labels and fields into 1 text box and format the box to supress blank lines..






To Paraphrase:"The Help you get is proportional to the Help you give.."