How to move a group of columns dynamically?

[Videla]

Hi All,
I have some 15 columns and these columns should be moved to a position based on a parameter. Is it possible to move all the columns at one shot.

Other details
-------------
Crystal report XI

 

[GJParker]

Crystal does not support the dynamic moving of fields.

If you provide more information on what it is exactly you are trying to do then we may be able to suggest a different course of action.

One way could be to have multiple sections or fileda in the different positions and suppress thesections according to your requirements.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Videla]

GParker,
Thanks for quick turn around. I have a crystal report showing 20 columns. My requirement is: Based on my Input parameter, Column1 would be suppressed or displayed. if it is suppressed then "there should not be any blank space in that column1" instead of that column2 to column 20 should be repositioned ie move towards left position. Also if column is visible then also the other columns should be repositioned. I hope this would be clear for you.

 

[GJParker]

One way would be to use formula fields to display the relevant column data something like

//@Formula1
If {?Suppress1} = True Then
    If {?Suppress2} = True Then
        {Field3}
    Else
        {Field2}
Else
    {Field1}

You would need to expand this to cover all 20 fields in the first formula and then create similar formulas for the other 19 fields checking the relevant suppression parameters.

HTH




Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

If there are only these two variations, with or without Column 1, then using two sections conditionally suppressed or not by parameter, as Gary first suggested, is probably the simplest approach.

-LB