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 / Finance | Project Operations, Human Resources, ... / When will the data be ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

When will the data be line break in SSRS report automatically.

(0) ShareShare
ReportReport
Posted on by Shinji Hoang 237

Dear all,

I have customized the changes TransTxt EDT(String length: 60→500) in D365FO.

When I run Vendor transactions report, the Description column will be line break if I input the length of Description shortly (about 60 characters).

But I input about 500 character for Description, it is unable to line break automatically in Vendor transactions report. 

I don't know what is the line break of specification in SSRS report?

Could you please let me know the line break of specification in SSRS report in D365FO? 

Thank you in advance.

HOA

I have the same question (0)
  • Blue Wang Profile Picture
    Blue Wang on at

    Hi HOA,

    Do you mean this field?

    7624.PNG

    In fact, I haven't seen the line break of specification.

    It should display length 60,  it;s from GeneralJournalAccountEntry.text, EDT is TransactionTextLarge, and the defined field length is 512.

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi HOA,

    You probably looking for "Sizing options" in SSRS

    docs.microsoft.com/.../allow-a-text-box-to-grow-or-shrink-report-builder-and-ssrs

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at

    Dear Blue Wang

    Yes, it is not break the line in Voucher transactions.

    But you see the line break in Voucher transactions report.

    Regards,

    HOA

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at

    Dear Sergei

    The vendor transactions report is set canGrow=True, canShrink=False.

    Could you please tell me about the rules for the line break?

    Is it manage from SSRS report?

    Regards,

    HOA

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi HOA,

    Yes, it's property for certain control in the SSRS report desing. You can choose any text control, open context menu and select "Text box properties" and on the "General" tab you will see "Sizing options".

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans