Configuring headers and footers SQL Server


show more Headers and footers are visible in each page of a report created in your SQL Server. The header at the top of the page differs from a report's title because the title is only shown at the top of the report's first page. Learn about the advantages and steps for configuring headers and footers in this online video. show less
please wait ...

Configuring headers and footers

Whenever you make a new report in Report Builder it might first look like you have a header and a footer section, but you've actually just been given a footer, because in a normal report this is a title, not a header, so it will only show at the top of the first page. But we have a footer that is activated, and that will show on every page. Now, you can toggle headers and footers on and off from the Insert tab. Add a header, remove a footer, and vice versa. Both the Footer and Header sections have their own properties, so if I right-click in the footer area, I have footer properties here where I have such options like do I print on the first page, do I print on the last page? I'm just going to leave those as is.

Now, by default, the footer you given contains a text box with this expression that will just show the date and time that this report is generated. But most of the things you would add to a footer or header are simple, often just text. So first, you would insert a text box....

Configuring headers and footers
Video duration: 3m 9s 3h 44m Advanced

Viewers:

Headers and footers are visible in each page of a report created in your SQL Server. The header at the top of the page differs from a report's title because the title is only shown at the top of the report's first page. Learn about the advantages and steps for configuring headers and footers in this online video.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...