Move Empty column to the left

[dhamal1]

I have about 18 columns and i can suppress columns if there is no values. I want to know how would i move column2 to it's left if column1 is empty?

This is what i have:

Name Orders Address
asc 1213 E
512 546 W

This What i Want:

Name Address
asc 1213 E
512 546 W


please help on this...

 

[dgillz]

You cannot do this easily.

You would have to have a formula that tests if the next column is null:

if isnull({column2}) then {column3} else {column2}

The difficulty is how many columns in your report, and the huge nesting of if-then-else statements that would be required to make this work. It is possible though.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

If you have CR XI or above, you can select the address field->right click->format->size and position->X axis->x+2 and enter:

if isnull({table.Orders}) then -1440 else defaultattribute

This would move the address field one inch to the left. The number is expressed in twips, with 1440 twips to an inch. You could potentially add this to all fields to the right of {table.Orders}. The issue would be that presumably orders would not be null in all cases, and then you would have an odd display with two fields sharing one column.

-LB

 

[dhamal1]

LB,

Your idea works and i what did is i calcuated average of all fields and checked against average.

Question: Where you find correspoinding number for different inches, you said 1 inch = -1440. I need to set to .5 inch.

thanks.

 

[lbass]

One inch = 1440 twips, so .5 would be 720. The minus just moves the column to the left, instead of to the right.

-LB