Cannot open duplicated special reports (e.g. "Order with Layout" from sale_layout)

Hello Amit,

I have checked the bug and it seems to be a problem from report designer module or framework,
So I request community team to check it once again and transfer it to respected team for further progress.

Thanks,
jap

Hello,

The "Order with Layout" report is a special kind of report that cannot be duplicated, because it depends on a special preprocessor system that makes a virtual "sale_order_lines" value available during report generation. This list contains the sale order lines in a special format, allowing the rendering the various layout options chosen on the sale order.

Of course the "Order with Layout" report uses this virtual "sale_order_lines", so if you duplicate it and create a normal report it will not have the special preprocessor (it is based on the normal "sale order" document), so you will get an error when it tries to access the missing virtual value. Duplicating special reports with preprocessors is not possible, but you have other options:
- modify the original report directly
- or after duplicating the report, remove the references to virtual fields that do not exist in the base document

For example for the Order with Layout report you could change the "loop" on the order lines using the Report Designer, to make it loop on the normal "Order Lines" field (order_line), instead of the virtual sale_order_lines (called here sale_order_lines(o)).

Thanks for your understanding!

PS: we could improve the system to warn about duplicating special reports with preprocessors, but there is no way currently to know for sure if a report cannot be duplicated, so that would be a new development (wishlist). At the same time we could also improve the error message, but at least it shows the correct issue: the report refers to a 'sale_order_lines' name that cannot be found.