Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 116 of 118
Document Version 1.0 – Last Updated 10.18.2010
Figure 87 –Employee count and salary sum within Group & Summary Bands............. 50
Figure 88 – The completed report .............................................................................................. 51
Figure 89 – Choosing the field to be formatted ..................................................................... 52
Figure 90 – Selecting the formatting option ........................................................................... 53
Figure 91 – The expression as one string ................................................................................. 53
Figure 92 – The expression separated into 2 fields ............................................................... 53
Figure 93 – The formatted numeric output printed.............................................................. 54
Figure 94 – Grouping by First Letter of Last Name ................................................................ 55
Figure 95 – The format of the report prior to creating groups .......................................... 56
Figure 96 – Creating the Group Header Band ......................................................................... 56
Figure 97 – Selecting the COPY function .................................................................................. 56
Figure 98 – Obtaining the first letter of the last name ......................................................... 57
Figure 99 – The expression entered into the Group-by-field or expression box ......... 57
Figure 100 – Adding the expression to print within the Group Header ......................... 58
Figure 101 – The final report grouped by first letter of employee last name ............... 58
Figure 102 – Selecting the Mailing Label Report Type ......................................................... 59
Figure 103 – Selecting the Mailing Label Type ....................................................................... 60
Figure 104 – The Label Format shown within the Band Report Editor ........................... 60
Figure 105 – Rearranging and aligning fields ......................................................................... 61
Figure 106 – The Rich Text Field Editor ..................................................................................... 62
Figure 108 – Identifying lines not to print if empty ............................................................... 63
Figure 110 – The completed mailing label ............................................................................... 63
Figure 109 – Edit dialog box for Rich Text Field ..................................................................... 63
Figure 111 – The printed report .................................................................................................. 64
Figure 112 – The Report Design .................................................................................................. 65
Figure 113 – Forcing a New Page for the Group Header Band .......................................... 65
Figure 114 – Obtaining the name of the expression ............................................................ 66
Figure 115 – Entering the expression name into the RESETEXPR function ................... 66
Figure 116 – The report showing all Purchase Orders .......................................................... 67
Figure 117 – Entering the criteria for conditional printing ................................................. 68
Figure 118 – The complete expression used for conditional printing ............................ 68
Figure 119 – The final report with conditional printing applied ....................................... 69
Figure 120 –Band Report Editor with Blank Report Type selected ................................... 70
Figure 121 – Tables to be used to create datasets for Sub-Detail Bands ........................ 72
Figure 122 – The Banded Report to be created ...................................................................... 72
Figure 123 – Clicking the Green Plus Sign to add a dataset ............................................... 73
Figure 124 – Building the dataset using the query builder................................................. 73
Figure 125 – Selecting fields from the Employee_Phone table......................................... 74
Figure 126 – Linking the Employees table to the Employee_Phone table .................... 74
Figure 127 – The query for the empl_phone dataset ........................................................... 74
Figure 128 – The empl_phone query shown in the Band Report Editor ........................ 75
Figure 129 – All datasets shown in the Band Report Editor ................................................ 75
Figure 130 – Properties of the first Sub-Detail Band ............................................................. 76
Figure 131 – Adding database fields to the Sub-Detail Band ............................................ 76