Details printing out of order

[Lucieann]

I have a report that the details section is split into sections a, b, c and d. For some reason, section d is printing before section c. I'm about to drive myself crazy trying to figure this one out, so I thought I should ask for help.

Any ideas?!?

 

[synapsevampire]

Doesn't sound right.

You may have an underlay following sections, print at bottom of page, or a suppress which gives that illusion.

Place some text in each section to identify them and test.

Then check the formatting for the aforementioned.

-k

 

[Lucieann]

OK. I changed them to text fields and they worked fine.

The data being pulled is description fields (Access database). If the description will not fit on one line in the database, it creates another description field, but changes the line # field to 2. I created the following formulas in order to print both description fields if needed:

For line 1: (Positioned on report in Details B)
If {ACOL1301.ItemNumber} = 1 then {ACOL1301.Description} else ""

For line 2: (Positioned on report in Details C)
If {ACOL1301.ItemNumber} = 2 then {ACOL1301.Description} else ""

When I preview the report, the additional fields that I have pulled and placed in Details D print before Details C.

Sounds crazy, but it's true. Are my formulas possibly causing the problem?