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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Set Default Print Size...
Small and medium business | Business Central, N...
Suggested Answer

Set Default Print Size to A4

(0) ShareShare
ReportReport
Posted on by KRM 60

Hi,

Today when our users print reports out from Business Central by using the function "Send to Excel", the report usually comes in the Page Size "LETTER" by default and even if we change the local printer settings on the computer, it still requires us to change it in the actual excel document exported from "Letter" to "A4".

I was wondering what code can be used to change the property and to set it as default to "A4" ?

Thanks in advance,

I have the same question (0)
  • MahGah Profile Picture
    MahGah 15,529 on at

    Hi

    A few points to check 

    1) What is a default printer (I mean Windows or another OS) for this user? Does that printer has a correct setup (A4, etc)? 

    2) Check in your display settings right click desktop -> display settings. Make sure it 100%. If not change to 100% and try again. 

    3) if you are on SaaS version when you try to print what printer you see and what is the paper size for that? You may need to adjust that printer then try in Excel. 

    4) Do you have any zoom on your web browser? if yes can you rest it to normal and try?

    Thanks 

  • KRM Profile Picture
    KRM 60 on at

    Hi,

    Thanks for the suggestions but as I wrote above we already have a correct setup on the printe, in our display and everywhere else.

    Also, as I wrote I am not printing directly from the web, we are using the "send to excel" function which downloads the files locally and we are printing it from the local computer, however the problem is that the file is not looking at the local printer setup because it is being sent by Business Central with the setup Page Size: "Letter", and thats why my question was more directed to developers if there is a chance to change this property in the background from "Letter" to "A4" and how that could be done ?

    Thanks in advance,

  • MahGah Profile Picture
    MahGah 15,529 on at

    Sorry about that. 

    I am not aware of any method to do this. I mean I know it is possible through development. Meaning someone need to edit the report template 

    You can search for Report Layout Selection. Find the report then export it out and see if you can change the layout. But normally this is not recommended for base BC report. 

    I hope someone else can provide a better answer.

  • KRM Profile Picture
    KRM 60 on at

    no problem. thanks for trying!

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    I assume you are using Windows Client for this, Spring release v14?

    Thanks.

  • KRM Profile Picture
    KRM 60 on at

    Hi Marco,

    not sure what you mean with V14 but as far as I know it is version 21H1.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    Apologies, I was not very clear. 21H1 is the Windows release I assume. I meant the following:

    support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-365-business-central-spring-2019-update-on-premises-f35e3fa9-bab8-fd76-e384-4171bfff6da1

    Build is 14.x.

    Thanks.

  • KRM Profile Picture
    KRM 60 on at

    Hi Marco,

    thanks for your reply.

    We are not running BC on premises. We are on Cloud and the version we have is 18.5 

    Platform 18.0.29486.31219 + Application 18.5.29545.0

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    Then I was completely off with this. I now see what you mean. I am not sure if this is considered a bug or a feature suggestion. You may want to raise it as an issue to Microsoft and then a supporter will ask product group if they consider this a by design scenario where we should create a feature suggestion for a future release.

    If this were a report then you would be able to create an extension for a rdlc report.

    Thanks.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans