how to align fields in crystal reports ( Extreme Left)

Hi guys,

Want I want to do is I have three fields  and I want to control the position of these fields. For example the report should look like this

Record1 Field1    Record1 Field2                  Record1 Field3
Record2 Field1    Record2 Field2                  Record2 Field3
Record3 Field1    Record3 Field2                  Record3 Field3
      Record4 Field1               Record4 Field2         Record4 Field3
      Record5 Field1               Record5 Field2         Record5 Field3
      Record6 Field1               Record6 Field2         Record6 Field3
      Record7 Field1               Record7 Field2         Record7 Field3
      Record8 Field1               Record8 Field2         Record8 Field3
      Record9 Field1               Record9 Field2         Record9 Field3
      Record10 Field1             Record10 Field2        Record10 Field3

Notice the position of the records or rows changed after 3rd record.
The question is "is it possible to change the position of fields runtime " if not then how to acheive these results.

Regards
AAmir


Answer this question

how to align fields in crystal reports ( Extreme Left)

  • Upul-uj

    hi all,

    In crystal report i want the fields to be displayed from the left side corner. is it possible is yes pls help asap..

    expecting ur reply soooooooooooooon.....

    Big Smile



  • Twil1ght

    Hello,

    You can do something like this at design time of the report by using multiple detail sections.

    You would have Details a and Details b and then set when these sections will be suppressed.   Go to the section expert and select Details a then click on the formula button beside the Suppress(no drill down).  In it have a formula like:

    RecordNumber > 3

    for Details b do the same but have the formula text as:

    RecordNumber < 4

    This will then show the first section for the first three records and the second for the remaining records.  Align the fields in each section (at design time) as you wish.

    If you want to vary which record the sections show on then use a formula field like:

    {@Test}
    RecordNumber < 4

    Then all you have to do is reference {@Test} in the Suppress(no drill down) formula for the section you want.

    Keith - Business Objects


  • LionelG

    Thanks Keith.
  • how to align fields in crystal reports ( Extreme Left)