Show multiple line discount percentages horizontally

[waqas_ahmed]

Hi Docentric Community,
I am working on Sales Invoice report. On the line level, I need to show multiple discount percentages horizontally if the particular line has more than one discount percentages.
Can you please show me how I can do it. I tried by following the following post but it seems like it did not work as I expected:

Comma separated list

Sometimes report needs to have a list that is rendered horizontally. In this case you will need to use a separator for the values in the lines. This turns out great by simply using a space character as space is not seen after the last value. Although it would be nice if the values would be separated by the comma (“,”) character. To achieve a horizontally rendered list in a report with customized separators, follow these steps: Add the @FieldName (replace with the actual field name from your da…

I am facing the following issue: I have a table to show the line level values and I have wrapped entire first row of the table with a List Tagging Element. After following above approach, I am getting all the values in the same one column while I want every value to be shown in separate column. Let me clear this with the help of an image.

In order to resolve this issue, I created another row just beneath this row and wrapped it in another List Tagging Element. Then I followed the approach explained above. The issue with this approach is it only fulfills when we have only one line. For multiple lines, it does not work well.
For multiple lines, the list tagging element for the first row runs all its iterations and then comes the turn of second row list tagging element… If I follow this approach, my discount percentages are shown after all the lines have bee run that come under first list tagging element. It does not run the discount percentages with the first list tagging element.

Can you please give me the solution where I can show the multiple discount percentages on the same line level ? THANKS in advance

[waqas_ahmed]

any help from anyone ?

[NatasaKA (Nataša Koščak Antić)]

Hello Ahmed, thank you for contacting our community.
Could you please send us your DDSP file and template so we can review how your data is organized? We are also sending you this forum post which might help you: https://ax.docentric.com/forum/t/table-cell-render-mode-horizontal-listing/219.

[waqas_ahmed]

I can’t access that page. Either the post no longer exists or I do not have permissions.

[AmirO (Amir)]

Hi @waqas_ahmed,

To show multiple discount percentages horizontally for each invoice line in the Sales Invoice report, you need to use a List tagging element inside the discounts cell, and set its Render Mode to Table Cell. This will make each discount appear in a separate table cell, displayed horizontally in the same row as the invoice line.

So it should be something like this:

1. Wrap the invoice line row in a List tagging element bound to your SalesInvoiceLines collection.
2. In the cell where discounts should appear, insert a nested table with one row.
3. Inside that row, add a List element bound to the Discounts collection of the current line.
4. Set the inner List’s Render Mode to Table Cell**.

You can check a similar approach in the following article, where the key point is to set the List’s Render Mode to Table Cell:

Label Design in MS Word with Docentric AX Designer

Try it out and let me know how it goes.

[SemirT (Semir Teskeredzic)]

Hi @waqas_ahmed

Please try adding a new row in the parent list tagging element. Then proceed with the setup that is explained in the shared article. You might need to experiment a bit with the placement of the child list element to get the expected layout. Please try it and let us know how it goes.