Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Reminder Report 117

Posted on by 60

Community,

I'm sure that this has been answered but I can't seem to find a solution...

... can't get the Reminder Text from Report 117 to show outside of the Lines portion of any report, including the built-in versions.

...have tried editing custom versions in WORD but Istill can't find the right XML Parts to use.

Admittdely, I'm much less familiar with the RDLC / Report Builder route, but I can't find the correct parts in the DataSet there either.

... can get my text to show but it continually shows as the first lines and not before or after.

I'm also confused between the terms used in the Reminder Text Page (Beginning & Ending Text) versus the relevant XML Parts I see in WORD (Greeting, Body & Closing).

I hope that there is something simple which I am overlooking.

Attached are some pics of dummy data.

Thanks in advance.

Reminder-Beginning-Text.pngReminder-with-Lines.pngReport-with-Lines.png

  • antmas Profile Picture
    antmas 60 on at
    RE: Reminder Report 117

    Ok, thank you.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Reminder Report 117

    No need to apologise. It is my full name after all.

    You’re not missing anything per say. This is how the report operates as standard. If you need something else it’s up to you to create it. Being able to adjust layouts in word doesn’t solve all scenarios unfortunately

    The greeting, body and closing are all baked into the report code. Just ignore them if you want something else.

  • antmas Profile Picture
    antmas 60 on at
    RE: Reminder Report 117

    My apologies on the name typo ^ , Josh.

  • antmas Profile Picture
    antmas 60 on at
    RE: Reminder Report 117

    Joshua,

    Thanks very much for the reply and the suggestions for customization / modification.

    I am sorry if I am asking you to answer for Microsoft here but perhaps I am missing something...

    Does this report look to be behaving as you'd expect?

    It isn't entirely clear to me why a user would want the report to show the reminder text on the lines, yet this IS a built-in report.

    Perhaps this report 117 is used also for some other purpose?

    Additionally, would you tell me if the XML parts "Greeting", "Body" & "Closing" are matched to any data in BC tables?

    I am curious to hear your thoughts on this, as well as the thoughts of others in the community.

    Appreciatively,

    Anthony

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Reminder Report 117

    Looking at the code it is data item IssuedReminderLine which contains the beginning text in order of the “Line No.”. It contains all the lines about invoices too though. Only the ending lines sit in a different dataitem called IssuedReminderLine2. The other text you mentioned are not involved. A report extension would be advisable to adjust the data items. Or adjust at layout level by having a condition on different tablix where you show only lines with an amount of 0 from that dataitem - i.e. the beginning text

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans