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

Answered

Reminder Report 117

(0) Share

Report

Posted on by antmas

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.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
antmas 60 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
antmas 60 on at

Like (0)

Report
Copy link

Link copied!

My apologies on the name typo ^ , Josh.

Was this reply helpful? Yes No
Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
antmas 60 on at

Like (0)

Report
Copy link

Link copied!

Ok, thank you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Reminder Report 117

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Reminder Report 117

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates