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

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... / Cancel caracter limita...
Small and medium business | Business Central, N...
Answered

Cancel caracter limitations in some reports

(3) ShareShare
ReportReport
Posted on by SS-08011023-0 14
Hello everyone

I'm having trouble printing some reports in Business Central. I think the lines for some fields in certain reports are limited to a specific number of characters to prevent the information from being cut off.

For example, an item description might be 45 characters long, but the report line displaying the item name has a limit of 40 characters per line, so a second line is generated for those remaining 5 characters.

I think this limitation is implemented using AL code, so I don't know if I can modify it.

Is there any way to bypass this limitation during the RDLC design phase?

The problem is that sometimes an additional line is generated with a few characters that could easily fit on the first line.
 
For exaple, there is a character for the second line that could go on the first line:
 
Thank you.
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Valentin Castravet Profile Picture
    Valentin Castravet 32,316 Super User 2026 Season 1 on at
    Have you tried making the field wider in the RDLC layout, or reducing the margins? That is usually why it wraps onto a second line. If you do both of those things it should fit in 1 row. 
     
    You can enforce a character limit per line in AL code, but as far as I know there are no standard reports that do this out of the box, it's usually controlled in the layout. 
     
  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,991 Super User 2026 Season 1 on at
    The very first question would be -  is this a standard report or a custom one? Normally, you won’t face these issues with standard reports. However, if you do, you can simply export the layout, make adjustments (such as stretching the textbox), and then reimport the layout. You might need some help with RDLC if you’re not familiar with how to identify which column needs adjustment. For standard reports, length is usually not an issue. But if it’s a custom report, you need to ensure that the layout length is handled properly. The AL code should be correct first before making any changes to the layout.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,313 Super User 2026 Season 1 on at
    It looks like a layout problem.
    You can export the data using the following method to see if it has been split in Excel. If not, modifying the layout file should solve the problem.
    Dynamics 365 Business Central: Save report dataset to Excel from the request page (Report Inspector)
     
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 13,295 Super User 2026 Season 1 on at
    Hello,
    Yes: in RDLC you can sometimes avoid that extra second line by adjusting the textbox width, padding, font size, line height, and CanGrow behavior, but if the text is already being split/truncated in AL before it reaches the layout, RDLC cannot fix it; in that case you must change the report dataset/code, so the quick rule is: if it’s normal wrapping, fix it in RDLC; if AL creates line 1/line 2 or cuts the text, fix the AL.
    Regards,
    Oussama Sabbouh
  • SS-08011023-0 Profile Picture
    SS-08011023-0 14 on at
    Hello

    Thank you for your replies, but I still haven't found the solution.

    I don't think the problem is the column width. I've highlighted the column in question in green so you can see the width I'm allowing and how it's still generating a second line even though there's enough space in the first one.
     
     
    More information: 
     
    It is a custom report

    And screenshots of the column and cell´s properties.
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,316 Super User 2026 Season 1 on at
    If it's a custom report and the field width is already wide enough, it's pretty likely this is being caused by the report code.
     
    You can try making the field super large just to see if it still prints on two lines. If it does, then you will know for sure it's because of the code.
     
    And if the issue is in the code, there is not really a way to fix it in the layout. The code would need to be changed, but it should be a very simple change.
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,947 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,120 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans