Report merge problem

[gunstr]

I would need a report where I from the Sales table select SOs and print some order data as a single table in a report.

The template looks like this:

<table class='table table-striped table-condensed'>
    <thead>
        <tr>
            <th style="width:30%;text-align: left">{% trans "Reference" %}</th>
            <th style="width:20%;text-align: left">{% trans "Description" %}</th>
            <th style="width:20%;text-align: left">{% trans "Shipment date" %}</th>
            <th style="width:10%;text-align: center">{% trans "Total price" %}</th>
        </tr>
    </thead>
    <tbody>
        {% for order in instances %}
        <tr>
          <td style="text-align: left">{{ order.reference }}</td>
          <td style="text-align: left">{{ order.description }}</td>
          <td style="text-align: center">{{ order.shipment_date }}</td>
          <td style="text-align: right">{% render_currency order.total_price %}</td>
        </tr>
        {% endfor %}
    </tbody>
</table>

Without using the "merge" function I get the four data points for each selected SO but on separate pages.

With "Merge" enabled I get all selected SOs in one table but only the "Reference" and "Description" cells are populated while "Shipment Date" and Total Price" is blank.

I have tried to find any hints by reading the documentation and the PR for the Merge function and what I understand there should not be any such limitations.

Any suggestions what might be wrong is appreciated.

[gunstr]

@tristanle22 , sorry to bother you but as you submitted the PR for the report "merge" function I'm reaching out to get your view on the issue I describe above. In short all four data points are populated when I print one report per sales order. But when I use the "merge" function only two are populated in the table.

I would need to understand if I have misunderstood how to use the merge function, if it is an expected limitation or if it is a bug.

[tristanle22]

can you try order.order.shipment_date?

[gunstr]

@tristanle22 that worked perfectly, thanks a lot!
I'm a bit puzzled though why order.reference and order.description worked but the two last items have to be order.order.shipment_date and order.order.total_price. If that can be easily explained it would be good the add that info to the documentation.

[SchrodingersGat]

@gunstr this is because, when merging reports, each entry in the list is a dictionary object, where each object is an instance of this dict:

https://docs.inventree.org/en/stable/report/context_variables/#purchase-order

So, each "instance" has a variable named "order" within it, which would normally be exposed globally to the template, but when merging, is contained in each separate instance in the list.

Your code would be more readable if you used "instance" instead:

{% for instance in instances %}
Reference: {{ instance.order.reference }}<br>
{% endfor %}

I'll make some updates to the docs to make this more clearer

[gunstr]

@SchrodingersGat Thanks for the clear explanation and docs update.

I was a bit confused that order.reference worked but not order.shipment_date but I guess that is sort of a corner case. I tested with order.order.reference and that works also why your recomendation to always use instance.order.xxxx will make this more clear and consistent.