This time around we are going to add a Page Header, which will print the title to our new report, and also print column header information at the top of each page. We've already reopened the report into the Report Formatter screen.


A Page Header is another REPORT BAND that is generated at the top of each page. The report engine keeps track of how much data can be printed on a page; when it's time for the printer to eject the page after printing as much information as it can the Page Header is created, then printed at the top of the report. Each page of the report will have the Page Header information printed at the top of each page.


We are going to select BAND from the pulldown menu, then NEW, then PAGE HEADER. A new empty band named Page Header is inserted ABOVE the DETAIL band automatically.


The first order of business is thinking of a title that you and your customer(s) will easily understand. For this report title we'll use "Customer Database - ACME Sales". Any and all text that you add to a report is inserted into a FRAME, so we need to create a new  frameinside the new Page Header frame. So, right click inside the Page Header band - an empty frame appears. Most reports have a centered title, so here is an easy way of ensuring that the report title is always centered onscreen:


Place the mouse on the right middle resize box on the empty frame

Resize the box until you reach the right side of the report

Make sure the gaps are the same for the left and right sides of the frame

Type the title inside the FRAME characteristics box

Click the center align button on the toolbar

Click the blue "A" for font type. Select ARIAL, BOLD, 12, then OK

That was easy wasn't it?!? You now have a title that will always be properly centered, and slightly larger than the rest of the report to make it stand out. You don't have to create your title like this - if you want it left or right aligned, or a different size then feel free to do so! You can also create multiple line titles if you want/need to - the choice is up to you!


Now we are going to create headers for each of the fields that are printed. To ensure they are printed at the top of each page they also need to be located in the Page Header band. Create a new frame inside the Page Header band directly above the leftmost column, then type in the header name (in this case, LAST NAME).


After adding all the frames and their header text you will want to resize their frames to be as small as possible. After doing that you need to align the frames so they are even - Ctrl-Leftclick each frame to select them all, then right click to display the alignment popup menu. then select Align Top. Now they are horizontally aligned with each other. Go ahead and move the entire line of selected frames until they are roughly 1/4 inch below the report title. Here is what we have so far:




 We can see from the above screen capture that the Page Header band needs to be reduced in height - otherwise the printed output will have a huge gap between the column headers and the database information printed in the DETAIL band. Go ahead and resize the Page Header band (left click-drag the center red resize box until it can't be reduced in height anymore. Here is what we now have:




Looking pretty good now. However, the column headers would look better if they were BOLD and UNDERLINED, so go ahead and change each FRAME for the headers. You may need to resize a frame if some of the column text is cut off.


 Now we need to left align the column headers with the data information that is printed beneath it. An easy way is to first click the header frame, then Ctrl-Leftclick the field frame underneath it inside the DETAIL band. Once the two frames are selected click the right mouse button, then select "Align Left" from the popup menu. Repeat this process for each column until they are left aligned. Remember that you can move the two selected objects in case they overlap other information by holding down the CTRL key, then tap the left or right arrow button to move the frames sideways. The final result now looks like this:




 Once satisfied with the results save your work (click the blue floppy disc), then print a sample report to the screen to see how it looks.




 Not bad! There is still room for improvement, but we are well on our way to a nice report. Remember, the Report Builder will print information the way you tell it to - YOU control how the reports look, so don't be afraid to experiment. Reports will NEVER change information in your database file(s) - they are completely safe to experiment with.





Published by ABCI Software Solutions | ABC ISO Consultants | Community | ISO Certification Services | ISO Resources

Copyright © Access Business Communications, Inc.