suppressing blank columns

[susanna123]

I have a report that looks like a chart but it is created using lines and boxes. There are 3 columns and 3 rows

looks something like this. It suppose to look almost like a crosstab but it is not. There is data in column 2. Column 1 and Column 3 have calculatoins that are based on Column 2 so that column cannot be deleted. I try to suppress the fields in column 2 but it shows now a blank column. Is it possible to shift Column 3 on top of column 2 so that it appears like there is only 2 columns instead of 3? or to suppress column 2 if it is blank?

|---------|----------|-----------|
| | | |
| | | |
| | | |
| | | |
|---------|----------|-----------|
| | | |
| | | |
| | | |
| | | |
|---------|----------|-----------|
| | | |
| | | |
| | | |
| | | |
|---------|----------|-----------|

 

[IanWaterman]

You could repeat column 3 and overlay it on Column 2.

Then for the two copies of the same formula/field add some conditional formatting they make them appear/disappear depending on the result for column 2

Ian

 

[susanna123]

how would the formula look like?

 

[IanWaterman]

Sorry I thought you had formual in Col 2 and 3 already.

Replace col2 field with formula

@col2

If isnull(col2field) then col3field else col2field.

If you need to suppress text box with Dashed outlines to give column effect.

In format for text boxt col 3, select suppress formula and enter

isnull(col2field)

Ian

 

[susanna123]

Hi Ian
Thanks. What if column 2 has different formulas already on it.
Column 2 row 1 is headings
Column 2 row 2 is values using diffrent formula
Column 2 row 3 is values using different formula

Would the above formula you provided change?

 

[susanna123]

column 2 row 2 contains 2 values that have a formula that looks like this:

first value
{@A}+{@B}

second value:
{@C}+{@D}+{@E}

 

[IanWaterman]

YOu can use the results of the formula to suppress/show fields

Copy Col3 3 fomula and place over col2 formula.

Then suppress col2 and original col3 formula with rules such as

//first value
{@A}+{@B} = 0
and
//second value:
{@C}+{@D}+{@E} =0

In suppression of col3 formula overlaying col2 formula
//first value
{@A}+{@B} <> 0
or
//second value:
{@C}+{@D}+{@E} <>0

Ian