Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
user:reports:query:export [14/05/2018 05:28]
tagr [Export Parameters]
user:reports:query:export [27/06/2018 08:10] (current)
tagr [Еxcel]
Line 40: Line 40:
 PDF is a widely known file format. To view these files Adobe Acrobat Reader is used (for Windows OS only). This type of file is well suited for printing. PDF is a widely known file format. To view these files Adobe Acrobat Reader is used (for Windows OS only). This type of file is well suited for printing.
  
-You can additionally specify the page orientation (landscape or portrait) and format (A4 or A3). The fixed width is standard. The standard page width is //fixed// which means it depends on the selected page format and orientation. However, if the table is too wide and does not fit the specified page width, this table will not be exported (only the heading will be displayed). In such cases, you can select //​automatic//​ page width, which means it will correspond to the largest row in the table. If //Auto, compact// is selected, the cell width is equal to the length of the largest word in it. If //Auto, no wrap// is selected, the cell width is equal to the largest phrase in it (no line breaks are applied)+You can additionally specify the page orientation (landscape or portrait) and format (A4 or A3) when exporting a PDF-file.
  
-Note that if the automatic page width is selected, the page format and orientation become relative --- they define only page height, not the width. ​+For reports with a large number of columns, the //Page width// option may also be appropriate. The standard page width is //fixed// which means it depends on the selected page format and orientation. However, if the table is too wide and does not fit the specified page width, this table will not be exported (only the heading will be displayed). In such cases, you can select //​automatic//​ page width, and the width of the page will correspond to the largest row in the table. If //Auto, compact// is selected, the cell width is equal to the length of the largest word in it. If //Auto, no wrap// is selected, the cell width is equal to the largest phrase in it (no line breaks are applied).  
 + 
 +Note that if the automatic page width is selected, the page format and orientation become relative --- they define only the height ​of the page, not the width. ​
  
 {{ :​reports:​export-pdf.png?​nolink }} {{ :​reports:​export-pdf.png?​nolink }}
Line 49: Line 51:
  
 Excel (.xslx) is a popular product from the Microsoft Office suite. Here the data is presented in the form of spreadsheets. The report is divided into several tab pages. The data is automatically stored in tables and is suitable for subsequent processing by the tools of this program. Excel (.xslx) is a popular product from the Microsoft Office suite. Here the data is presented in the form of spreadsheets. The report is divided into several tab pages. The data is automatically stored in tables and is suitable for subsequent processing by the tools of this program.
- 
-:!: //Note//.\\ When exporting a report to PDF, HTML, Excel the **alignment** is used. The columns with text (names of sensors, geofences, drivers, users, SMS and notification text, location addresses, etc.) are aligned to the left. The columns with numeric data (time, duration, speed, mileage, fuel, payments, count, etc.) are aligned to the right. ​ 
  
 {{ :​reports:​export-xls.png?​nolink }} {{ :​reports:​export-xls.png?​nolink }}
  
 +:!: //Note//.\\ When exporting a report to PDF, HTML, Excel the **alignment** is used. The columns with text (names of sensors, geofences, drivers, users, SMS and notification text, location addresses, etc.) are aligned to the left. The columns with numeric data (time, duration, speed, mileage, fuel, payments, count, etc.) are aligned to the right. ​
 ==== XML ==== ==== XML ====
  
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2018 Gurtam