Report grouping and printing.

[Hal]

I have a report (data based on a query) that is grouped on the following:
Date, Vehicle# and Trip#. No headers or footers
When I print the report it may look like this:

Date: Vehicle #: Trip#:
1/3/05 2 566
467
378

1/5/05 467

1/6/05 1 345
2 455

1/7/05 1 788
234

Data is:

Date: 1-to-M Vehicle#,
Vehicle#: 1-to-M Trip#
Trip#: Detail

I would like it to print the vehicle # for each new date all on one line.
Currently it skips the vehicle# if it is the same # as the previous date.
( see 1/5/05)
I would like to have it on the same line. I don't like the "stepped" report
look.
Is there any way to do this?

TIA Hal

 

[Fons Ponsioen]

Hi. It looks like the hide duplicates property for the applicable textbox is
set to yes. CHange it to no and that should fix what you described.
Fons

 

[Hal]

Fons thanks for the reply... Correct the TextBox is set to "no" because I
only want it to show once for 'each' date, and if I set to Yes it will show
for each detail record.
With the same data, here's what I would like it to look like:
(Notice for each 'date' it list the vehicles that might have driven....)



Thanks again, Hal

 

[Marshall Barton]

I have a report (data based on a query) that is grouped on the following:
Date, Vehicle# and Trip#. No headers or footers
When I print the report it may look like this:

Date: Vehicle #: Trip#:
1/3/05 2 566
467
378

1/5/05 467

1/6/05 1 345
2 455

1/7/05 1 788
234

Data is:

Date: 1-to-M Vehicle#,
Vehicle#: 1-to-M Trip#
Trip#: Detail

I would like it to print the vehicle # for each new date all on one line.
Currently it skips the vehicle# if it is the same # as the previous date.
( see 1/5/05)
I would like to have it on the same line. I don't like the "stepped" report
look.

Hide Duplicates is kind of wimpy in this kind of situation.

Better to create a Group header (View menu - Sorting and
Grouping) for the data you only want to display once per
group. In this case, I think you want one group for the
date and another for the Vehicle number.

Place the Date text box in the date group header and the
Vehicle text box in the Vehicle header. This will do what
you want, except that the header will not be on the same
line as the first trip number. To get that effect, add a
line pf code to ecah header's Format event procedure:
Me.MoveLayout = False

 

[Hal]

Marsh - you are a genious......

That worked - I have been pulling my hair out on this one, and haven't been
able to find any examples of this.

Thank you - Thank you - Thank you

Hal