Small and medium business | Business Central, N...

Header and footer

(1) Share

Report

Posted on by CU03011304-0

Hi,

I would like to have the header only on the first page of my documents and the footer only on the last.

I've found some solutions for this here, but none are for the scenario when the document has only one page. How do I do that?

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 74,178 Super User 2024 Season 2 on at

Like (0)

Report

Header and footer

Hi, This is briefly mentioned in the Microsoft documentation below.

Headers and footers in Word layouts

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-howto-report-layout?tabs=vscode#headers-and-footers-in-word-layouts

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 5,443 on at

Like (1)

Report

Header and footer

So finally here is the alternate solution for Footer.

Follow below steps:

Select text box.

Select draw text box. Draw it.

Add footer into the textbox.

Select textbox and then select OUTLINE and No outline.

Now publish it and check the output.

Set the fix position on page

For Header on first page only: keep below boolean true

Hope this helps.
Suggested answer

Khushbu Rajvi. 5,443 on at

Like (1)

Report

Header and footer

Instead of placing content directly into the footer, you can use a Text Box. By anchoring the Text Box to the last line of the document and selecting "Fix Position on Page" in the "Wrap Text" settings, the text box will stay in the same position even if content above it changes or the page layout is altered. This gives you more control over the placement of content in the footer.

https://www.yammer.com/dynamicsnavdev/#/Threads/show?threadId=2137266411708416&search_origin=global&scoring=linear1Y-prankie-group-private-higher&match=any-exact&search_sort=relevance&page=1&search=footer%20on%20last%20page%20of%20word%20layout
Suggested answer

Khushbu Rajvi. 5,443 on at

Like (2)

Report

Header and footer

The solution I provided earlier applies to RDLC reports. I wasn’t aware you were looking for a solution specifically for Word layouts, as it wasn’t mentioned in your query.

Unfortunately, due to some limitations in Word layouts, it’s not straightforward to have a header only on the first page and a footer only on the last page when generating reports in Business Central. If you were creating a normal document manually in Word, this would be possible. However, in reports, we can’t use visibility logic in Word layouts, which makes this requirement unachievable in most cases.

Word handles headers and footers in static ways for regular documents because it knows the page structure during design time. In Business Central, Word layout reports are dynamically generated based on the data, so Word doesn't know the total number of pages in advance. This limitation affects requirements like yours.

For single-page reports, both the header (first page) and footer (last page) will appear because they share the same page. For multi-page documents, you can follow the steps outlined in this video:
https://www.youtube.com/watch?v=rFbd7B8BFck
However, extra spacing issues might arise (As you can see the below ss), and this approach may not be suitable for reports with strict layout requirements.

For more details, you can refer to the official documentation:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-howto-report-layout?tabs=vscode
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-howto-report-layout?tabs=vscode#headers-and-footers-in-word-layouts
https://support.microsoft.com/en-us/office/configure-headers-and-footers-for-different-sections-of-a-document-94332643-a6e9-46aa-ab29-064f1d356db6
CU03011304-0 7 on at

Like (1)

Report

Header and footer

Thank you Khushbu Rajvi, that is what I need, but I can't find a panel like that on my version of word. I have Word for Mac under Microsoft 365 subscription. How do I access that?
gdrenteria 12,794 Most Valuable Professional on at

Like (1)

Report

Header and footer

Hi, good day
I hope this can help you, and give you some hints.

How to do the header is only visible in First Page of report

Show a Footer Only on the Last Page? – think about IT

Best Regards
Gerardo
Suggested answer

Khushbu Rajvi. 5,443 on at

Like (4)

Report

Header and footer

If i understand correctly then you want the header and footer as below:
Single page:

Multiple page:

Here is the solution:

It will work for single page and multiple page documet.

Hope this helps you.

Regards,

Khushbu Rajvi