we are working on the FLAT layout reports, and each report has 18 to 22 columns and the client wants to fit all columns in a single page.
we unable to achieve the desired output by using the default ‘export to Pdf’ feature. so our workaround option was to export as HTML and save it to the PDF file.
please help us to provide a suitable example which can do this automate progress.
Thank you in advance.
Thank you for writing to us.
Have you tried exporting PDF into a bigger page?
Our PDF export allows defining the
pageFormat property from A0 to A5 – https://www.flexmonster.com/api/exportto/.
Such an approach in combination with landscape layout allows putting much more columns on the page. Here is an example: https://jsfiddle.net/flexmonster/v1b4w8na/.
Please let us know if it solves the case.
yes, I have tried with PageFormat: A2 and page orientation: landscape and I have able to achieve having all columns on one page.
currently, we have maximum column count is 22 and the minimum count is 8 columns along with this, we have CHART reports too which includes line, multi-line, column, stacked-column, and Pie charts,
is there any way to have dynamically selection of page format according to the column count?
example, for CHART reports and the report which have a maximum of 8 columns, set export page Format A4 page size.
Thank you for your feedback.
We are glad that
pageFormat approach works fine for you.
In case you need to extend the default export functionality please try our approach for customizing toolbar: https://www.flexmonster.com/doc/customizing-toolbar/. It allows overriding the default behavior. Using our getReport() API call you can dynamically check the current number of columns in slice and if the charts are used.
Please let us know in case of any other question.