how to create report headers & footers

building reports desktopintelligence
1

how to create report headers and footres and how to set width.expalin step by step
:expressionless:

janie (BOB member since 2005-04-28)

2

Choose View-Page Layout. You can change the size etc there. Then you can choose Format - Page Header/Footer if you want to shade it etc

irish_stan :ireland: (BOB member since 2003-05-13)

3

In view / page layout, you can add blank cells to the header and footer areas, and then typ in any headers or move any objects or variables there. These will show in every page of the report by default.

Italo Sessegolo (BOB member since 2002-08-29)

4

Further to Italo Sessegolo’s reply, if you want to show the date of report in the header for example, from the menu bar go;

Insert/Special Field/Date and Time/Last_Refresh
Now drag the cursor to create a cell and the date will appear within.

Once you have a cell containing the date, you can go to the formula bar,
and amend its code so it reads;
="Date of Report: " & FormatDate(LastExecutionDate(“Query1 with XYZ”), “dd/mm/yyyy”)

Now format the cell and get rid of the border (it looks neater).
The report will update the date whenever the report is run.

jemmo (BOB member since 2004-10-15)