Report Headers

[Moo]

I have a report that shows sales for the year, sorted by month. So the date
is grouped on month, and has a separate page for each month. How can I
create a label in the header of each page that will tell for what month it's
reporting. ie: on the first page will be January sales in the format
01/01/05. I want header to say January sales...

 

[Rick B]

add a page (or group) header and put something like the following in an
unbound text box...

=Format([YourDateFieldNameHere],"MMMM")



Or...


= "Report for the month of: "& Format([YourDateFieldNameHere],"MMMM")


Hope that helps,
Rick B

 

[fredg]

I have a report that shows sales for the year, sorted by month. So the date
is grouped on month, and has a separate page for each month. How can I
create a label in the header of each page that will tell for what month it's
reporting. ie: on the first page will be January sales in the format
01/01/05. I want header to say January sales...

As long as the report is forcing a new page for each month, simply add
an unbound text control to the Page Header:
=Format([DateField],"mmmm") & " Sales"

As the page header has access to the first detail record, whatever the
first detail record's date for the month is will be displayed in the
header.