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

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,091 on at
    RE: When will the data be line break in SSRS report automatically.

    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".

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: When will the data be line break in SSRS report automatically.

    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

  • Shinji Hoang Profile Picture
    Shinji Hoang 237 on at
    RE: When will the data be line break in SSRS report automatically.

    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

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,091 on at
    RE: When will the data be line break in SSRS report automatically.

    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

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: When will the data be line break in SSRS report automatically.

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans