runtime field position

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

[1196 byte] By [aamirmalik] at [2007-12-16]

«« I have installed Microsoft SQL Server 2005 Express edition, but I can't find Enterprise Manager
»» Want to make a high end game

# 1

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

KeithThomson at 2007-9-9 >