I generally use the Edit Reports under Reports menu. Then you can set the report settings to A4 size, once you do this then you add your Sheet Objects in the report to fit into A4 size. I understand it is additional work but this is the best way for printing and publishing to PDF.
I hope it helps!
Cheers - DV
Thank you very much for your help. This goes a long way to resolving the problem but the printed version of objects does not look the same as when you view them on the sheet.
For example, one of my charts (straight table type) loses the following on the printed version:
- The border (I think this can be resolved in report properties for the object)
- The style where lines alternate between light/darker blue
- The heading of the object (which includes an expression)
Another chart (pie) changes where the legend is positioned when you resize it and you cannot <Ctrl>+<Shift> to readjust the position like you can on a sheet.
I need the printed report version to look exactly like the version on screen. Have you managed to overcome this problem in the past?