Report printing specific records

[Leroy]

I basically need to be able to have a report to print out information from
one specific record in the table, the Blotter Opened record, at the bottom of
each page until it reaches the next Blotter Opened record and change the
information at the bottom of the report to match the information in the new
record. For example:
The fields are Title, Date, Supervisor, Comments.

The report looks something like

Blotter Opened
09-22-76
Mr. Smith
Great Supervisor

Shift Change
09-22-76
Mr. Jones
Bad Changeover

-------Page Footer------
Supervisor: Mr. Smith
------- Bottom of Page---

*Next Page*

Shift Change
09-23-76
Mr. Johnson
Average Changeover

Blotter Opened
09-23-76
Mr. Black
Average Supervisor

-------Page Footer------
Supervisor: Mr. Black
------- Bottom of Page---

That is just an example of what I am needing to have the report do. Any
suggestions would be greatly appreciated. I just more or less need a pointer
in the right direction, and I'll probably be able to figure out the rest.

 

[Duane Hookom]

It looks like your pages are limited to a single date. Is that the case?

 

[Leroy]

Sir,

The report itself is queried by the date that the user wants to search
for. The dates aren't otherwise seperated by page, I just had it like that
for the example. The shift change before the next page could very well be on
the 23rd. I basically just need to find out how to tell it to print a value
that is in the record for Blotter Opened at the bottom of the page. I hope
that answers your question.

V/R
Leroy

 

[Duane Hookom]

You haven't stated if there would be more than one value for Blotter Opened
on a page or what rule states that only one Blotter Opened record will
appear on each page.

 

[Leroy]

Sir,
There could be more then one value for Blotter Opened on a single page,
and in that instance I would just use the last one of the page, the last
Blotter Opened that appeared on the page, or maybe combine the two entries
such as:

-------Page Footer------
Supervisor: Mr. Smith
Supervisor: Mr. Jones
------- Bottom of Page---

I basically just need to know if its possible to add a field in the footer
of the report that will go back to the last known Blotter Opened and grab
that piece of information from it, and print it at the footer? I would also
be curious about having the report set up to start a new page everytime
Blotter Opened came up, but I can mess around with that at a later time. If
you need any more information, please let me know. Thank you for continuing
to work with me on this issue.

V/R
Leroy

 

[Duane Hookom]

I would create a grouping level on an expression like:
=IIf(Comments="Blotter Opened",[Primary Key Field],"")
You can set a group header on this grouping level and add a text box to the
group header (or footer)
Name: txtBlotterOpened
Control Source: Comments

Then add a control to the report page footer:
Control Source: = txtBlotterOpened