I'm still answering questions from my recent webcast series. I got a question by e-mail from someone who is converting from Access and wants to add headers and footers to a report. Actually, there are several different places you can work with headers and footers.

Report Header and Footer. You might think that there should be a report property that is a header for the entire report. Actually, that's not needed. You can put as many data items on a report as you find  useful. If you want a header that occurs once at the start of a report, just shove your data items downwards a little in the report designer to make some space, and then drop a textbox/image/whatever you want onto the designer. These items will print exactly once at the start of the report. In the textbox, you can either put literal text, or you can use arbitrary expressions. Items like execution time, report name, user ID, or the number of pages in a report are all available as globals, or you can call .NET code, so you can easily build any dynamic header you need. For a report footer, just put the footer after the last repeating item in the report.

Page Header and Footer. There is a special facility for these. In Report Designer, click the Report menu and then select either Page Header or Page Footer. This will create special areas in your report for the page header, page footer, or both. Just like a report header, you can put arbitrary text boxes, images, or any other item that you want into each of these areas. How about putting a little chart onto every page of a report that summarizes the data in the report? If you use text in the page header and footer, that can also contain any arbitrary expression that appeals to you. The Report Properties dialog box contains check boxes that allow you to decide whether the page headers and footers are printed on the first or last page of a report.

Table Header and Footer. If you're building a table, the table has its own header and footer. Click on the table until a set of gray boxes appear around the outside of the table. Right click on the little box with three gray bars at the left hand end of the table details row. The context menu will allow you to turn on or turn off the table header and footer. If you need multiple header rows, use the context menu to create the first header row, and then right click on the header icon that appears at the left hand end of the header row, and select either Insert Row Below or Insert Row Above. The Table Properties dialog box contains check boxes that allow you to repeat header rows on each page, repeat footer rows on each page, or keep the header visible while scrolling.