report not formatting with groups

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a report that is working ALMOST perfectly.

The report is setup as such:

Header had Order# and Order Date
Group1 creates new page for each Category within a group
Detail list the items within the group for the order. The detail is setup
with 2 columns

The problem is that when the detail moves to teh next order, the first page
is still showing the Order# and Order Date from the previous order.

Example: Page 1
Order#1, 6/1/04
Category: Processors
Intel 286
Intel 386
Intel 486

Example: Page 2
Order#1, 6/1/04
Category: CD MFGS
Staples
Memorex
TDK

Example: Page 3
Order#1, 6/1/04 <<<<this is the next order and should have "Order#2,
7/1/04" as the header
Category: Processors
Intel Celeron
Intel 486

Example: Page 4
Order#2, 7/1/04 <<<<this is CORRECTLY showing the correct order
Category: CD MFGS
Memorex
TDK

NOTE: I have the following report settings:
OrderNumber Footer; Force New Page: After Section
ItemCategory Footer; Force New Page: After Section

Why is the header "trailing" behind the details? It appears that the header
is not moving to the next order header until the SECOND page of detail?

Can anyone help with this?
 
I suspect you placed the Order# in the page header, I
suggest create a grouping/header for Oder# and place your
current page header in this Order# header band. Now set
the repeat section for this band to yes.
Hope this helps.
Fons
 
I tried this, but it caused a different problem. The detail section is
setup a two column report. If I do not put the order information in a
header, then the OrderID section ALSO gets split as if in two columns.

I tried to move the orderID field to the OrderID section, however this did
not help with the header section.

Is there a way to have the detail section be a two-column report, yet have
the grouping section NOT divide to two sections?

-Stephen
 
I would suggest that you make the detail section a 2
column subreport, and the main report a regular one column
report.
We'll get there yet.
Fons
 
Back
Top