I have a monthly report which uses 6 repeating fields to store the number of specific actions completed in a month. I want the user to have the option to export to Excel or print to PDF.
Excel: The repeating fields are exported into Excel as a single cell with no delimitation between the values and is completely unusable. I have thought of using a virtual list but don't want to if a similar problem exists.
PDF: Although the layout will fit on A4 Landscape the Save to PDF option does not allow that option to be selected and prints Portrait and cuts off much of the print. I have played about with the Print option in layout, selecting print as one column, but it has had no effect.
Any suggestions gratefully received.