Printing Dynamic Reports

You can print a Dynamic Report and apply the required settings from the Print Setup dialog page using this functionality. 

Following are the options available in each section on the Print Setup page

Paper

You can use this section to configure the paper size and quality based on your print output requirement. The following are the options available in this section:

Paper Size: Select the required paper size from the drop-down. The options available are as follows:

• Letter

• Tabloid

• Ledger

• Legal

• Statement

• A3

• A4

• A5

Paper Quality: This option determines the print quality. The higher the number, the better quality. The options available are as follows:

• 300 dpi

• 600 dpi

Scaling

Based on the selected paper type, you can either use the Adjust to or Fit to options to define how the report's content should spread across the pages in the print output. 

Ideally, you can use the Adjust to option when the number of columns in the report is less and the Fit To option if the number of columns in the report is more for clear output.

Adjust to

Set the required percentage in this field to determine the overall area the report covers on a page in the print output. For example, if you provide 10%, the report covers only 10% of the area of a page in the output.

Here is an example output preview of the 50% scale.

If you provide 100%, the report covers 100% of the area of a page in the output. If the content does not fit on one page (when the number of rows and columns is more), the report is split into multiple pages in the output.   

Here is an example output preview of the 100% scale.

Fit to

You can mention the number of pages you want to print the report. For example, if you set Fit to 1 page(s) wide by 1 tall, the entire report is printed on a page.

If you are using the Fit To option, the application will try to fit the content in the output page as per defined values. For example, if we give Page Wide as 1 and Tall as 1, the report’s content will fit on one page.

If you try to fit a report with many columns/rows on less number of pages, the content may not be legible in the output, and the header/footer may not be visible. We recommend that you carefully set the values in the Fit To section based on the size of the report. Update the Pages Wide setting based on the number of columns(typically 12 or more) and the clarity needed. If you are not sure about the value you want to fill for the Tall field, you can leave it. Preview the output and keep adjusting the values until you get the desired output.

Orientation

Select Portrait or Landscape mode for the page layout of the print based on your requirements. Ideally, if a report contains more rows when compared to columns, you can select Portrait as it can accommodate more rows and select Landscape if the report contains more columns than rows.

Page Order

If the report has multiple pages, the page order defines the pattern in which you want to print the pages. The options available are as follows:

• Down, then over

• Over, then down

Margins

The content in the output (including Header and Footer) aligns with the output pages based on the margins provided in this section. The Top, Bottom, Left, and Right margins represent four sides of the output pages and the value given in the respective fields defines the gap between the content and the edges of the output page. In PDFs, the header and footer always align with the layout of the PDF, and its margin depends on the value provided in the Top, Bottom, and Right fields in this section. If you are not able to view the footer in the print preview, try increasing the Right margin until you are able to view the footer.

Other Options:

Select the required checkbox based on your need to further customize the print output:

• Show Gridlines: Selecting this option will display the rows and columns border in the print output.

• Repeat row header on each page: If the report is spread across multiple pages in the print output, selecting this option will add the row header on every page in the output. This checkbox is selected by default.

• Repeat column header on each page: If the report is spread across multiple pages in the print output, selecting this option will add the column header on every page in the output. This checkbox is selected by default.

• Delete extra rows and columns: Select this checkbox if you want to remove any empty or extra rows and columns from the print output. This checkbox is applicable only for Dynamic reports.

Header and Footer

You can configure the header and footer settings for different print output types from this section. Click the Header icon on the top menu and select any of the following options from the Header and Footer Display section based on your requirements.

Header and Footer section: Select this option if your print output is PDF or Excel. In PDFs, the header and footer always align with the layout of the PDF rather than with the report as shown in the application, so it is recommended to preview the output and check their alignment before printing the report. If you have provided any margins in the Print Settings window, the alignment of the header and footer would depend on the margins provided.

Footer in a report in the application

Footer in a report in the print output

Rows: Select this option if your print output is only Excel.

Export to PDF

You can use the Export to PDF option to download the report in PDF format. The format of the data in the downloaded report depends on the print settings you set in the Print Setup screen. Also, make sure that you have selected the Header and Footer Section option in the header and footer settings. 

Export to Excel

You can use the Export to Excel option to download the report in Excel format. The format of the data in the downloaded report depends on the print settings you set in the Print Setup screen. Also, make sure that you have selected the Rows option in the header and footer settings.