121
In Business documents you can use Ranges to create repeating sections: for example to show all lines on a document. Next, you can also use criteria "Enabled"/"Removed", in order to delete part of your document, should this value be empty.
In Excel you can also use them in combination (e.g. Notes on your sales packing slip lines: there can be a note on line 2 but none on line 1. You only want to show the note of the line if it is actually filled in).
This logic does not work in Word however. In Word: the "Removed" criteria can be:
- ISEMPTY(@.Note): Then he looks if there are notes on line 1. If yes, he shows note on all lines. If No, he does not show notes anywhere.
- ISEMPTY(ALLITEMS(@.Note)): If there is one note on one of the lines, then D365 will show notes everywhere. Also, if the notes are empty on some other lines (white spaces).
See also fix: https://fix.lcs.dynamics.com/Issue/Details?bugId=562546&dbType=3&qc=1a93cc383a735cb75470ee7ee5952b0dc6e0196981f23cdb03355dd0f9674483

However, this is an important restriction to Business documents in Word! Two examples below, but there may be many more:
- Project invoice
Here we create 5 blocks: for hours, fees, items, expenses and on-account. Then we repeat these blocks per project. So for project 1 we might have only hours and fees. For project 2 we might have only expenses.
Still, we will see twice the full 5 blocks of hours, fees, items, expenses and on-account even though 7 out of 10 blocks will be empty.

- If you want to include pictures in your lines
Suppose you want to pick up the image of your release product on your line. If the images are present for all products on all lines, there is no problem. However, if one of the products does not have an image, then you will get an error message and the report will not print.

Therefore, we suggest to enable the use of criteria "Enabled"/"Removed" in combination with a Repeating section.
STATUS DETAILS
Needs Votes

Comments

N

Big limitation, as it prevents the creation of the report design without gaps, as it is not possible to hide the areas / fields in the repeatable area.

Category: Reporting and Analytics

N

In my Projects this is a big limitation to design good looking documents straight forward.


Also, since the standrad word templates want to use these functions in the repeated sections, it looks more like a bug than a missing feature to me.

Category: Reporting and Analytics

N

I don't think this is an idea but a bug.
Nearly every standard MS word template already does this and is not working properly because of this.

In my project that's a huge amount to work around this in all the reports :-(

Category: Reporting and Analytics

N

Hope this gets resolved soon, seems like a big gap in functionality.

Category: Reporting and Analytics