@anand Yes that’s how I will be doing the custom print formats we need - it’s still quite cumbersome if you think about it as you have to first filter the list for one Sales Order (we only print one job form at a time) - and that’s the only field you can’t “auto-filter” on simply by clicking it unfortunately 
Then you have to open Excel, paste the data in (careful to put it in the right cells, etc), run the macro, etc.
It’s certainly an option but the ability to add a custom report using HTML would be much better. Unfortunately I can’t even find the syntax to add Sales Order Items to a Custom Print Format for Sales Order - the help section of the system says to use: frappe.db.get_value(“[doctype]”, “[name]”, “fieldname”) As per my thread here: Custom Print Format Examples - #2 by rmehta
But using that logic does not return the Sales Order Item fields at all.
Could you tell me the exact format of that statement to return, say Sales Order Item → Item Code on a Custom Print Format? The standard one does it but I want freedom to place such details elsewhere on my printout - more than simply hiding/showing in the Customise Form section can achieve.
Something like this:
Does that make sense?