web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Report Builder - Blank...
Small and medium business | Business Central, N...
Suggested answer

Report Builder - Blank space

(1) ShareShare
ReportReport
Posted on by LM-26090852-0 145

Hi everyone,

I'm working on an RDLC layout for a Sales Invoice in Business Central, and I need some help with the layout formatting.

Specifically, I want the "Total" section to always appear at the bottom-right of the page — just like in a printed invoice with a fixed layout — regardless of the number of lines in the invoice (which can vary, but has a max of 25).

So basically:

-If there are fewer lines, I want to add some blank space (or visual padding) to push the total down.

-If there are 25 lines, the total should naturally be at the bottom.

-The goal is to keep a consistent layout height, whether the invoice has 5 lines or 25.

Is there a best practice or recommended way to insert this kind of blank space in RDLC?

Thanks in advance for any guidance!

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,876 Super User 2025 Season 2 on at
    Report Builder - Blank space
    Check this link, you need to use page footer but need keep track of the totals in the table
     
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 10,139 Moderator on at
    Report Builder - Blank space
     

    Hi there,

    If you're working on an RDLC layout for a Sales Invoice in Business Central and want the "Total" section to always appear at the bottom-right of the page, regardless of the number of invoice lines (up to 25), here’s a reliable approach:

    ✅ Use the Page Footer Section

    RDLC supports a Page Footer, which is ideal for placing totals that should consistently appear at the bottom of the page.

    Steps to Implement:

    1. Open the RDLC layout in Visual Studio.

    2. Add a Page Footer:

      • Right-click outside the report body and select “Add Page Footer.”
      • This section will always render at the bottom of the page.

    3. Place Total Fields in the Footer:

      • Add your total fields (e.g., Total Amount, VAT, Grand Total) to the footer.
      • Align them to the bottom-right using layout tools.

    4. Bind Data Correctly:

      • Use expressions like:
     
    =Sum(Fields!TotalAmount.Value)
     
    Or reference calculated values from the body using:
     
    =ReportItems!txtTotalAmount.Value
     

    1. Control Line Overflow:

      • Limit the number of lines per page (e.g., max 25).
      • Use a fixed-height container (like a rectangle) to prevent content from overlapping the footer.

    Let me know if you need help with a sample layout or expressions.

    If this answer was helpful, please consider marking it as accepted.
    Best regards,
    Daniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans