Tab Body (I)

 
Here you can add columns for your report.
 
New Suite legacy report tab Body (I) page in Astrow Web
 
Click to add columns for your report. Use if you want to delete a column. You can also rearrange columns with move down and move up buttons.  
 
Defining the columns report in Suite legacy report tab Body (I) page in Astrow Web
 
When defining a column, first you need to select the type of information to be displayed in the column. This is done in Field. You can enter up to 15 different fields (columns) for each report.
Select an item from the dropdown list. Here are some extra explanations related to booking information:
 
  • 1st In, 1st Out - 10th In, 10th Out: These fields only include time bookings and do not show cost bookings.
  • Last In, Last Out: These fields only include time bookings and do not show cost bookings.
  • 1st booking - 20th booking: These fields show any bookings that has been asked. They do not make a distinction between time and cost bookings.
 
Defining the column type in Suite legacy report tab Body (I) page in Astrow Web
 
Secondly you need to select the format of display. This is done in Format.
 
Defining the column format in Suite legacy report tab Body (I) page in Astrow Web
 
Depending on the type of field (date, time, text, number), you can select a format from the dropdown list. There are four main groups of formats: numerical, time, alphanumerical and date format.
 
Numerical format:
 
  • Items from 0 to ######0 will display no decimals with no preceding 0.
  • Items from 00 to 00000000 will display no decimals, with preceding 0.
  • Items from 0.00 to ######0.00 will display two decimals, no preceding 0.
  • Items from 0.00 to 0000000.00 will display two decimals, with preceding 0.
  • Items from 0.0000 to ######0.0000 will display four decimals, no preceding 0.
  • Items from 0.0000 to 0000000.0000 will display four decimals, with preceding 0.
 
Time format:
 
The report generator supports both the 60th and the 100th time format. In the 100th time format, one hour is divided in 100 parts instead of the normal 60 parts (minutes). This means that 30 minutes equal 0.5, and so on.
 
Time
60th form
100th form
10h. 30 min.
10:30
10.50
1h. 50 min.
1:50
1.83
12h. 15 min.
12:15
12.25
 
The 60th format:
 
  • No preceding 0, no sign: hh:mm to hhhhhh:mm
  • No preceding 0, sign: +hh:mm to +hhhhhh:mm
  • No preceding 0, no sign, no colon: hhmm/60 to hhhhhhmm/60
  • No preceding 0, sign, no colon: +hhmm/60 to hhhhhhmm/60
  • Preceding 0, no sign: HH:MM to HHHHHH:MM
  • Preceding 0, sign: +HH:MM to +HHHHHH:MM
  • Preceding 0, no sign, no colon: HHMM/60 to HHHHHHMM/60
  • Preceding 0, sign, no colon: +HHMM/60 to +HHHHHHMM/60
  • No preceding 0, no sign, with MC-code: hh:mm mc
  • Preceding 0, no sign, with MC-code: HH:MM MC
     
Examples:
 
Time
hh:mm
+hhh:mm
hhmm/60
+hhhmm/60
HH:MM
+HHH:MM
HHMM/60
+HHHMM/60
HH:MM MC
hh:mm mc
1h 30 min
1:30
+1:30
130
+130
01:30
+001:30
0130
+00130
01:30  02
1:30  02
24h 10 min
24:10
+24:10
2410
+2410
24:10
+024:10
2410
+02410
24:10  02
24:10  02
0h 10 min
0:10
+0:10
010
+010
00:10
+000:10
0010
+00010
00:10  02
0:10  02
 
The 100th format:
 
  • No preceding 0, no sign: hh.mm to hhhhhh.mm
  • No preceding 0, sign: +hh.mm to +hhhhhh.mm
  • No preceding 0, no sign, no decimal: hhmm/100 to hhhhhhmm/100
  • No preceding 0, sign, no decimal: +hhmm/100 to +hhhhhhmm/100
  • Preceding 0, no sign: HH.MM to HHHHHH.MM
  • Preceding 0, sign: +HH.MM to +HHHHHH.MM
  • Preceding 0, no sign, no decimal: HHMM/100 to HHHHHHMM/100
  • Preceding 0, sign, no decimal: +HHMM/100 to +HHHHHHMM/100
 
Examples:
 
Time
hh:mm
+hhh:mm
hhmm/100
+hhhmm/100
HH:MM
+HHH:MM
HHMM/100
+HHHMM/100
1h 30 min
1.50
+1.50
150
+150
01.50
+001.50
0150
+00150
24h 10 min
24.17
+24.17
2417
+2417
24.17
+024:17
2417
+02417
0h 10 min
0.17
+0.17
017
+017
00.17
+000.17
0017
+00017
 
Date format:
 
You can choose from 16 different date formats. 8 of these print the three first letters of the weekday followed by the date.
 
No weekday
 
With weekday
 
d/m/yy
8/1/17
ddd d/m/yy
tue 8/1/17
m/d/yy
1/8/17
ddd m/d/yy
tue 1/8/17
dd/mm/yy
8/1/2017
ddd dd/mm/yy
tue 08/01/17
mm/dd/yy
1/8/2017
ddd mm/dd/yy
tue 01/08/17
d/m/yyyy
08/01/17
ddd d/m/yyyy
tue 8/1/2017
m/d/yyyy
01/08/17
ddd m/d/yyyy
tue 1/8/2017
dd/mm/yyyy
08/01/2017
ddd dd/mm/yyyy
tue 08/01/2017
mm/dd/yyyy
01/08/2017
ddd mm/dd/yyyy
tue 01/08/2017
 
Alphanumerical format:
 
Items from x(5mm) to x(100mm) are used for text information. You can choose a format in upper or lower case. The value between the brackets indicates the column width in millimetres (between 5 and 100).
Remark: the columns are always 2 mm wider than the setting, so a separating line can be printed between the columns.
 
Next is alignment, A. This is used for the alignment of the columns. If you check the box, the text of this column will be right aligned. If not, the text will be left aligned.
 
Defining the column alignment in Suite legacy report tab Body (I) page in Astrow Web
 
Next you can select the line style and thickness of the report. If no visible separation is required, you can also select None.
 
Defining the lines in Suite legacy report tab Body (I) page in Astrow Web
 
O and + are two options for time and count items. They are always used in combination, check below to see how.
 
Defining the displayed totals in Suite legacy report tab Body (I) page in Astrow Web
 
If you check 0, the results will be displayed as 0 at the start of each period. The option + can be selected to turn this field into an increasing counter.
There is a big difference between the effects of these options on cumulative time items and on those that are not cumulative. If your counter is already cumulative, you will have a carry-over option. This option enables you to carry over the positive or negative hours from the previous period to the next period. This way you do not have to start each period from 0.
 
Example:
 
 
Cumulative counter
Cumulative counter
Non-cumul. counter
Non-cumul. counter
 
Carry over
+ 10:00
+ 10:00
(none)
(none)
 
 
 
 
 
Mon 9/11
+ 4:00
+ 4:00
+ 8:00
+ 8:00
Tue 10/11
+ 6:00
+ 6:00
+ 8:00
+ 16:00
Wed 11/11
+ 9:00
+ 9:00
+ 8:00
+ 24:00
Thu 12/11
+ 10:00
+ 10:00
+ 8:00
+ 32:00
Fri 13/11
+ 12:00
+ 12:00
+ 7:00
+ 39:00
Sat 14/11
 
 
 
 
Sun 15/11
 
 
 
 
Mon 16/11
+ 14:00
+ 14:00
+ 8:00
+ 47:00
Tue 17/11
+ 15:00
+ 15:00
+ 8:00
+ 55:00
Wed 18/11
+ 18:00
+ 18:00
+ 8:00
+ 63:00
Thu 19/11
+ 19:00
+ 19:00
+ 8:00
+ 71:00
Fri 20/11
+ 21:00
+ 21:00
+ 7:00
+ 78:00
Total
+ 21:00
+ 31:00
+ 78:00
+ 78:00
 
If you select the option 0, you will restart calculation each week at 0. This option is only useful if you also check the + option.
 
Example:
 
 
Non-cumul. counter
Non-cumul. counter
 
Carry over
(none)
(none)
 
 
 
Mon 9/11
+ 8:00
+ 8:00
Tue 10/11
+ 16:00
+ 8:00
Wed 11/11
+ 24:00
+ 8:00
Thu 12/11
+ 32:00
+ 8:00
Fri 13/11
+ 39:00
+ 7:00
Sat 14/11
 
 
Sun 15/11
 
 
Mon 16/11
+ 8:00
+ 8:00
Tue 17/11
+ 16:00
+ 8:00
Wed 18/11
+ 24:00
+ 8:00
Thu 19/11
+ 32:00
+ 8:00
Fri 20/11
+ 39:00
+ 7:00
Total
+ 78:00
+ 78:00
    
Use the header field to insert a column title description of the column content. If you do not insert any text, this column will not have a title.
 
Defining a column header in Suite legacy report tab Body (I) page in Astrow Web
 
Example of definition for a booking report per day:
 
Example of a Suite legacy report tab Body (I) page in Astrow Web
 
This will list all in and out bookings per day.