Figure 1 – Explorer objects ... 11
Figure 3 – Explorer Navigation ... 12
Figure 4 – QuickLaunch View ... 12
Figure 2 – Options for QuickLaunch ... 12
Figure 5 – Dashboard View ... 13
Figure 7 – The form containing input selections and query results ... 14
Figure 8 – Form Design within DataBlock Designer... 15
Figure 9 – The Argos DataBlock Designer ... 17
Figure 10 – The Object Toolbar ... 17
Figure 11 – Description of each item within the Object Toolbar ... 20
Figure 12 – The Alignment Toolbar ... 20
Figure 13 – Selecting the database connection ... 21
Figure 14 – The Argos DataBlock Designer ... 22
Figure 15 – Adding the Graphics Object... 22
Figure 16 – The Object Properties Area within the DataBlock Designer ... 23
Figure 17 – Renaming the EndDate object ... 24
Figure 18 – The Variables Tab within the DataBlock Designer ... 24
Figure 20 – Adding Text for a Label Object ... 25
Figure 19 – The Alignment toolbar ... 25
Figure 21 – Adding a Shape Object ... 26
Figure 22 – Choosing the method to populate the employee list box ... 26
Figure 23 – Creating choices for the multi-column list box ... 27
Figure 24 – The Build Query dialog box ... 27
Figure 25 – Identifying the database fields to be visible on the form ... 28
Figure 26 – The Conditional Fields Tab within the Build Query dialog box ... 28
Figure 27 – Adding conditions to the query ... 28
Figure 28 – Entering the Sales Department ID into the SQL Editor ... 29
Figure 29 – The completed condition ... 29
Figure 30 – The resulting SQL ... 29
Figure 31 – Testing the current design ... 30
Figure 32 – Showing all database tables within the Build Query dialog box ... 32
Figure 33 – Selecting the tables applicable to this query... 32
Figure 34 – Joining the tables within the Build Query dialog box ... 33
Figure 35 – Identifying the fields to be visible within the report ... 33
Figure 36 – Entering the calculated field into the SQL Editor ... 34
Figure 37 – The calculated field shown within the Visible Fields tab ... 34
Figure 38 – The multi-column list box to contain the query results ... 34
Figure 39 – The Conditional Fields (WHERE) tab in the Build Query dialog box ... 35
Figure 40 – adding last name to the condition... 35
Figure 43 – The completed condition for last name ... 36
Figure 44 – Adding the condition for first name ... 37
Figure 45 – The complete variable list ... 37
Figure 46 – Creating the conditions for start date and end date ... 37
Figure 47 – Creating the condition for the GO Button ... 38
Figure 48 – The final query for the query display... 39
Figure 49 – The QuickView report ... 39
Figure 50 – DataBlock/QuickView Report ... 40
Figure 51 – Creating a new report ... 40
Figure 52 – The Copy and Paste selections within the Build Query dialog box ... 41
Figure 53 – CSV, Banded, and Extract Reports now selectable ... 41
Figure 54 –Edit Box added to the form ... 43
Figure 55 – Properties for edit box ... 44
Figure 57 – The report results ... 44
Figure 58 –Other variables for this DataBlock ... 45
Figure 59 – Contact types used in this example ... 46
Figure 60 – The Main Form ... 46
Figure 61 – The Forms Tab within the DataBlock Designer ... 47
Figure 62 – Adding the four additional forms ... 47
Figure 63 – Properties of the Address Button ... 48
Figure 64 – Associating a button to an event ... 48
Figure 65 – The design of the address form ... 49
Figure 66 – Selecting the employee on the main form ... 50
Figure 67 – Query results for the phone number form ... 50
Figure 68 – The chart for fiscal years 2006 - 2008 ... 51
Figure 69 – The Main Chart Wizard Interface ... 52
Figure 70 – The SQL Editor ... 52
Figure 71 – The SELECT tab for the fy2006 dataset ... 52
Figure 72 – The WHERE tab for the fy2006 dataset ... 53
Figure 73 – After completing the dataset for fy2006 ... 54
Figure 74 – Selecting the Series that is being created/updated ... 54
Figure 75 –The input selection object ... 56
Figure 76 – Adding the OLAP Cube Object... 56
Figure 77 –Selecting the Main Properties ... 57
Figure 78 – Creating the Fact Table... 57
Figure 79 – The fact table (query) within the Build Query dialog box ... 58
Figure 80 – Identifying the Measures ... 58
Figure 81 –Identifying the Dimensions ... 59
Figure 82 –Applying a style... 59
Figure 84 –The OLAP cube ... 60
Figure 85 – The OLAP cube after moving dimensions into rows and columns ... 60
Figure 83 – Library of Objects selection ... 60
Figure 86 – The Form showing the 3 input selections... 61
Figure 87 – Entering data into the SELECT tab ... 62
Figure 88 – Entering data into the WHERE tab ... 62
Figure 89 – Entering data into the Summing field ... 62
Figure 90 – Entering data into the HAVING tab ... 63
Figure 91 – The final SQL ... 63
Figure 92 – The QuickView report ... 63
Figure 93 –The Free Type icon within the Report Query –Design tab... 64
Figure 94 – The Free Type Editor ... 64
Figure 95 –Validating the query ... 65
Figure 96 –Applying field security ... 65
Figure 97 –The Filters and Sort tabs used for Report Design ... 66
Figure 98 –Reminder to add special characters when using Free Type Query ... 66
Figure 99 –Adding special characters for filtering ... 67
Figure 100 –The Free Type query after adding special characters for filtering ... 67
Figure 101 –The Free Type Query after adding special characters for sorting ... 68
Figure 102 – The main query ... 69
Figure 103 –The Sub Query... 70
Figure 104 – Entering the alias... 70
Figure 105 – The final Query/Sub Query ... 70
Figure 106 –The Main Query shown within the Build Query dialog box ... 71
Figure 107 –The Main Query ... 72
Figure 108 – The Sub Query added to the Main Query ... 72
Figure 109 – The location of the Sub Query Button ... 72
Figure 110 –Selecting the table for the Sub Query ... 73
Figure 111 –Specifying the latest effective date ... 73
Figure 112 –Creating the WHERE clause in the Sub Query ... 73
Figure 113 –The SQL Editor... 74
Figure 114 –Choosing the field to link the Main Query to the Sub Query ... 74
Figure 115 –The Sub Query shown within the Build Query dialog box ... 74
Figure 116 –The Sub Query... 75
Figure 117 –Positioning the Sub Query into the Main Query ... 75
Figure 118 –The aggregate function linking the Sub Query to the Main Query ... 75
Figure 119 –The complete SQL ... 76
Figure 120 –The query results displaying the latest effective date ... 76
Figure 121 –The Main Query ... 77
Figure 122 –The Sub Query... 78
Figure 123 –Placing the Sub Query into the Main Query ... 78
Figure 124 –The completed query ... 78
Figure 125 – The query results ... 79
Figure 126 –The Main Query ... 80
Figure 127 – The Unions pane displayed ... 81
Figure 128 –Editing the Union Name ... 81
Figure 129 –The three queries shown in the Unions pane ... 82
Figure 132 –A schedule shown in the Explorer Tree ... 83
Figure 133 –The General Tab... 83
Figure 134 –The Schedule Tab ... 84
Figure 135 –The Tasks Tab ... 84
Figure 136 –Configuring email properties ... 85
Figure 137 –The email task added to the list of Added tasks ... 85
Figure 138 –The Events Tab ... 86
Figure 139 –Executing the Report ... 87
Figure 140 –Selecting method to populate the input selection objects ... 87
Figure 141 –Options for Process and Save ... 88
Figure 142 –Selecting an output format ... 88
Figure 143 –Copying the report output to a destination ... 88
Figure 144 –Options for creating a Saved State ... 89
Figure 145 –Saved States listed when executing a saved report ... 89
Figure 146 –Managing Saved States by Editing the Report ... 90
Figure 147 –Adding the Bursting task ... 90
Figure 148 –Specifying Burst Conditions... 91
Figure 149 –Using the Expression Builder to specify a Burst Condition ... 91
Figure 150 –The Burst Condition field filled in... 91
Figure 151 –The report shown in the Explorer Tree ... 92
Figure 152 – Library of Objects Manager ... 93
Figure 153 – Edit Styles Using the Format Tab ... 93
Figure 154 – Banded Report Wizard - Report Template ... 95
Figure 155 – Selecting a Style for an OLAP Cube ... 96
Figure 156 – Data Dictionary Configuration in MAPS ... 97
Figure 158 – DataBlock Designer Showing Use of Data Dictionary ... 98
Figure 157 – Enabling the Data Dictionary ... 98
Figure 159 – Edit Table Properties ... 99
Figure 161 – Standard Field Join ... 99
Figure 160 – Display the Edit Table dialog ... 99
Figure 162 – Alias added to Query... 100
Figure 163 – Join Info Added to Query ... 100
Figure 164 – Security dialog box ... 101
Figure 165 – Security icons within the Query Designer ... 103
Figure 166 – Applying security to an individual field ... 103
Figure 167 –Applying security to several fields ... 104
Figure 168 –Publish to the CO-OP ... 105
Figure 169 –CO-OP Upload Form ... 106
Figure 170 – Link to support site from Argos ... 107