Custom print report
Editor of print reports
Giriton offers a simple editor of print reports thanks to which you can compile simple reports yourself. Your new print report will then be offered in Attendance agenda -> Print where, as with other reports, you can select the period for which the data will be exported and the users whose data should be exported. You will download an Excel file with your data after exporting.
You can create a new Print report in User Menu -> Configuration -> Reports, by clicking on +Add button. Name the new print report and choose whether it is of the "daily" or "monthly" type.
- Daily report: Displays the attendance of individual users for each individual day of the month. If you export multiple users at once, the resulting Excel file will have multiple sheets, one for each user. There will be 28-30 lines on each sheet, one for each day of the month. The columns will then contain the results of individual attendance activities.
- Monthly report: Displays the sums of attendance activities of individual users for the entire selected month. If you export multiple users at once, the resulting Excel file will have a single sheet where the rows will contain individual users, the columns will contain individual attendance activities and the cells will contain the sum of the given activity for the given user.
Switch to the "2 Report data" tab after naming the new print report and choosing the "daily" or "monthly" type. You can add columns of individual types to the print report from the "Available columns" table, for example "Human resources field" (Name, Surname, Type of employment, ...) or "Attendance value" (Work total, Meal vouchers, Vacation, ...) You can setup for the individual columns the column header, column width, column order and, for example, for the "Attendance value" column, you can setup whether the time should be displayed as hours:minutes or as a decimal number. As the last step, save your new report and you will find it in Attendance agenda -> Print under the name you have chosen for the print report.
What if you cannot create a print report in the editor or the report editor does not offer the options you need?
If you cannot choose between the many print reports and exports that are already in Giriton, it is possible to add custom print reports and exports. This may be useful if you have your own Excel spreadsheet in which you are used to work with the attendance data. Your spreadsheet may contain special equations and additional calculations or it may just be special formatting you are used to.
If you are interested in the addition of your own print report to Giriton, please write us an email and provide us with an exact sample of your report in Excel.
The provided Excel sample file must comply with:
- The file must contain sample data of some sample users, so that it is clear, for example, whether you want to format the time as "8.5" or "8:30" etc.
- If you want to have your own equations in Excel, it is necessary that you add the equations to it before seding it to us. Please note that we do not check the correctness of your equations.
- If you wish to enter some attendance data from Giriton into the report, it is necessary to describe exactly which item from Giriton you want to export into which column in your Excel report. For example, you would add columns to Excel called "Work Total" and "Night work", i.e. named the same as the corresponding items are named in Giriton. If you wish to have items in the report named differently than in Giriton, you must provide us with a description of thy type "In columns C, export the value "Night work" from Giriton" etc.
- If you wish to have some formatting in the resulting report (different font sizes, bold, ...) it is necessary that this formatting is part of the Excel sample that you provide us with.
A custom print report is a one-time paid work. The price of the paid work depends on the complexity of the print report and especially on the number of additional adjustments compared to the original assignment.
We will answer you within a few days whether such a report can be added to Giriton or what amount we would invoice for the paid work after receiving the sample Excel file. After a mutual agreement, we will take the Excel file provided by you and connect it to Giriton so that this Excel file will be filled with the relevant data from Giriton at the time of printing.