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 [28/09/2018 07:50] (current)
tagr
Line 18: Line 18:
 The //Split chart by:// option allows to receive, depending on your selection, a separate chart for each day or week of the reporting period.  ​ The //Split chart by:// option allows to receive, depending on your selection, a separate chart for each day or week of the reporting period.  ​
  
-Indicate whether it is necessary to attach the map to the exported report. Graphical objects (such as map, chart) can be exported only into HTML or PDF files. Note that the map will be attached to the file only if any graphical elements (such as [[user/​reports/​templ/​settings/​map|tracks,​ markers, geofences, etc.]]) are selected in the [[../​templ/​templ|report template]]. By default, the map is scaled in order fot the track/​markers/​last unit position to be seen on it. If these elements are not shown on the map, the map is not attached. If the //Squeeze in all graphics// checkbox is marked, the map is scaled in such a way that geofences are shown on the map along with the above mentioned elements. Only Gurtam Maps can be attached to the report. Furthermore,​ the map layer can be hidden (using the //Hide cartographic basis// option) — in this case tracks and markers are shown on the blank background. ​+Indicate whether it is necessary to attach the map to the exported report. Graphical objects (such as map, chart) can be exported only into HTML or PDF files. Note that the map will be attached to the file only if any graphical elements (such as [[user/​reports/​templ/​settings/​map|tracks,​ markers, geofences, etc.]]) are selected in the [[../​templ/​templ|report template]]. By default, the map is scaled in order fot the track/​markers/​last unit position to be seen on it. If these elements are not shown on the map, the map is not attached. If the //Squeeze in all graphics// checkbox is marked, the map is scaled in such a way that geofences are shown on the map along with the above-mentioned elements. Only Gurtam Maps can be attached to the report. Furthermore,​ the map layer can be hidden (using the //Hide cartographic basis// option) — in this casetracks and markers are shown on the blank background. ​
  
 The function of using a link to display the location (if the coordinates are available) is supported for the files exported in PDF or Excel. It works as follows: open the exported report (PDF/​Excel),​ place the cursor on the corresponding field of a report, for example, the beginning/​end time or address information from the unit (the cursor pointer changes to //hand//) and click on the link. Google Maps cartographic service will be opened in your browser, where the marker indicates the location. If there is no need to show the location, you can disable links to Google Maps in PDF and Excel files by marking the corresponding checkbox in the export parameters. The function of using a link to display the location (if the coordinates are available) is supported for the files exported in PDF or Excel. It works as follows: open the exported report (PDF/​Excel),​ place the cursor on the corresponding field of a report, for example, the beginning/​end time or address information from the unit (the cursor pointer changes to //hand//) and click on the link. Google Maps cartographic service will be opened in your browser, where the marker indicates the location. If there is no need to show the location, you can disable links to Google Maps in PDF and Excel files by marking the corresponding checkbox in the export parameters.
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