Home

Getting Started Guide

1. FPBPOHD PRINT IND FPBPOHD PO PRINTED DATE FPEPOHD VEND PIDM Fig 3 20 Adding Fields to Conditional Alternatively you can double click on the column you wish to add Page 65 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support O ae L ira ILI E Img IL Argos n Pick one of the following choices User User DbName User Description User EmailAddress User Mame ConvertDates ConvertDates CONVENDDATE ConvertDates CONVSTARTDATE EndDate Getyvendor GetYendor FTVVEND PIDIM aet vendor N StartDate Fig 3 21 Adding Variables to Conditional e Show Hide Free Type Controls the format of the where clause for the selected conditional group Fig 3 22 Expert Mode Icon Either use Free Type or F qm EE E oo QOQooQRm _ _ aE Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY rook gt group gt spriden change ind is HULL and FPBPOHD FPBPOHD PO DATE between ConvertDates CONVSTARTDATE and ConvertDates CONVENDDATE Fig 3 23 Manually Entering WHERE Clause Page 66 Getting Started Guide Last Updated 06 13 2006 To add the actual condition click on the ellipsis on the Condition line and enter the condition that nee
2. SATURILSSBSECT SSBSECT Index Name all SSBSECT TERM CODE SSBSECT CRM SSBSECT PTRM CODE ssBSECT SUBJ CODE SSBSECT CRSE NUMB m ri Pick one of the following choices 4i 6G j Ch n ds LI fd i SSBSECT SEQ NUMB SSBSECT SSTS CODE SSBSECT SCHD CODE SSBSECT CAMP CODE SSBSECT CRSE TITLE SSBSECT CREDIT HRS SLiser amp ser DbName SUser Description SUser EmailAddress SUser Name MultiColumn MultiColumn COURSE MultiColumn CRM MultiColumn SECTION SelSubject SelSubject Description SelSubject Subject SelTerm SelTerm CODE SelTerm TERM Table ssesecr Field SSBSECT TERM CODE Condition Fig 2 30 adding conditions Click on the condition field to open up another SQL editor ame to add the condition To list all the variables defined to date click on the ABC icon Y and select the variable SelTerm CODE Repeat to filter on the Subject field Finally you can change the order by moving over to the Order By tab and selecting the field you want to order the returned rows by We will order by the CRN Click OK to continue Page 39 Evisions Inc e 14522 Myfor
3. rgos MAPS and Evisions are Li registered trademarks of Evisians Ine MAPS administrator to see which Making documents work Together 2003 2005 Copyright Evisions ine po rt to use amp e Local intranet Fig 1 1 Argos Launched from Web Page 5 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Do you want to install and run Evisions Digitally Signed CAB signed on 4 20 2004 12 31 PM and distributed by GLOBAL EVISIONS SOLUTIONS INC Publisher authenticity verified by VeriSign Class 3 Code Signing 2001 CA Caution GLOBAL EVISIONS SOLUTIONS INC asserts that this content is safe You should only install view this content if you trust GLOBAL EVISIONS SOLUTIONS INC to make that assertion DC Always trust content from GLOBAL EVISIONS SOLUTIONS INC Fig 1 2 Security Warning for Client Download Fig 1 3 Login Icon Page 6 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 If this is the first time you have
4. Fig 5 3 Edit Describe Report Explorer Quick Launch jo Roster e x ZNTOUE Roster 7 Alumni H p AR Execute this Report L Finance Edit the details of this Report H OrderProcessing A Ly Payrall gt Student Catalog Ly Faculty Edit the security settings for this Report Ly FincialAid Author administrator 17 General T A 11 18 2004 4 57 39 PM author administrator x Rosters Detail Roster Detail Roster By Department Run this at beginning of semester A New DataBlock A Rosters quickview gt Roster dh SummaryRoster H i 5 SQLServer 1 A Advisor A BasicAdmission Training UnderConstruction Eb Ee E Fig 5 4 Adding Notes to a Report Page 79 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 The next form allows the report creator to name the report as well as provide a description In addition you can mark the report Public or Private A Public report is accessible to anyone with access to the DataBlock A Private report will be seen by only the creator of the report Give the report a meaningful name as well as good description Click the Finsh button to save the report After the report is added you can also add Notes This is useful for noting characteristics of the report when to run the report
5. Finally the developer can set the column to be Visib e 3 or not If Visible is checked you can also set the display width for the column shaded right Lets review what we have so far Note in the Multi Column Box the Titles are being picked up either from the Alias in the SQL Select Subject a statement or from the Column Prini Administration d efi ni t ION CHEM Chemistry CHSM Core Humanities Seminar ECON Economics ELET Electronic Engineering Tech ENGL Eng Note that the Subject List box will E not populate until we select a x term Likewise the multicolumn 2430 001 10007 box displaying the Course information will not display until we select the Subject Select Term Fall 1995 Retrieve a maximum record s Fig 2 35 Test run with MultiColumn Page 42 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATgos Parameter Form Variables Getting Started Guide Last Updated 06 13 2006 In the three examples created the columns have been assigned variable names by using the AS clause of the Select Statement If no AS clause is used the variable will be assigned the name of the field or column title CRNRoster QV Commit Changes Active Connection amp Dew v Form Design Query Design ee Parameters Variables
6. Columns on each page 1 E Column spacing 0 00 E Orientation 5 Portrait O Landscape Fig 5 17 Report Options Page 87 Getting Started Guide Last Updated 06 13 2006 On the next screen you select what bands you want to appear on the report By default the Page Header and Title are selected Check uncheck the options you want Here we have selected to also print the Summary and page Footer Click Next to continue On the next form you set up the characteristic of the report itself Here you assign a Title to the Report This is the title that will print in the Title Band The Columns indicator allows you to split the page into multiple columns These columns are distinct from the data columns that were selected For example if you changed the number of columns from 1 to 2 there would be two columns of all the fields selected similar to how a news letter is formatted You can also indicate if this is for a protrait or landscape output Click Next to continue Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support New report definition Font Far column headers and labels Font Far datafields Lines horizontal lines vertical lines box lines ORDERS 1997 Fig 5 18 Report Characteristics Mew report definition Fig 5 19 Preview Report You can now select Preview to check the
7. select SPRIDEN SPRIDEN LAST NAME SPRIDEN SPRIDEN FIRST NAME from SATURN SPRADDR SPRADDR SATURN SPRIDEN SPRIDEN where SPRIDEN SPRIDEN PIDM SPRADDR SPRADDR PIDM and and SPRADDR SPRADDR STATUS IND is null or selectActiveOnly N Page 95 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 OK Button 3 Using the OK button on a background allows items on the background to be refreshed In addition it can be used to force an event to occur One place a button is useful is to delay an execution of a query until the user has all the parameters filled in and is ready to run the query Since many datablocks can be created to show results in a QuickView report as well as a banded report maybe the end user does not want the QuickView report to be executed Likewise some queries are complex and take a long time to execute Using the button the user can populate the parameters but the main query will only execute when the button is pressed Following is an example of how this might be used Technical Training part 2 complete ox Active Connection o M al Form Design Free Type Parameters Variables Mo x n Pis ab 3 B e E zi EH P pa 3443 Button li E E Action None Caption Bun Query Description
8. Variable Name StartD ate reris 141 e rn c4 D MO De Doe DA A OD SO e O08 O04 o e e o e e o e e o e 08 OD e e o e o e O08 e e o e O08 fields StartDate Fig 3 2a adding date PurchaseOrder AE Active Connection DEVL P a Form Design Query Design Parameters Variables Xx N d ab fi a Ei p ES ul Mol DateEdit ea gt ps a d do m un sns pu B QE Date 4 25 2006 Ir 1 Default Today Yes Description Font FentBold No Font Color cIwindowTet Fontltaics No FontMame Tahoma Font Size B Font Underline No Height 18 Left 812 II Parent Font Tes Required Yes Tab Order i Top 208 Variable Name EndDate se To add a date object click on the Date icon El and place on the form By default the date is blank You can set a default date by setting the Date attribute to the desired date Optionaly you can have the date automaticatically default to the current system date Remember to assign an appropriate variable name Add a date for both a starting and ending date as we want to narrow the PO s by a date range By setting the ending date to defalut to Today s date we do not need to have the user enter current date Page 52 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 9
9. Font Font Font Bold Yes 0 Font Color cfwindowT ext i EIN Fontltalics Mo Enter Date fe Select Address Type s x Font Mame Tahoma H8 un T i d n z wF e dc FontSize 11 Js Select Entity Active Address Only re Font Underline No E omg dd Height 2 Name Search BpHonal I Est Parent Font Tab Order Top 1539 Run Query Variable Name runQuery ip 10 Last Name First Name Address i State Record Count addressCount RECORDCOLINT Fig A 5 Button By default when pressed the button will have a value of 1 When not pressed it is NULL A sample query using the Button Page 96 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ar Getting Started Guide ATOS Last Updated 06 13 2006 select SPRIDEN SPRIDEN_LAST_NAME SPRIDEN SPRIDEN_FIRST_NAME from SATURN SPRADDR SPRADDR SATURN SPRIDEN SPRIDEN where SPRIDEN SPRIDEN PIDM SPRADDR SPRADDR_PIDM and and SPRADDR SPRADDR_STATUS_IND is null and runQuery is not null The query will not be executed until the runQuery button is pressed Page 97 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 Table of Figures Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig
10. Fig 2 1 Adding a QuickView DataBlock Getting Started Guide Last Updated 06 13 2006 To create a DataBlock highlight the Folder you wish to contain the DataBlock right click and select NEW DATABLOCK When Prompted enter a valid name In this example we have called the DataBlock CRNRoster QV When naming a DataBlock it is useful to the end user to somehow indicate if this is a QuickView or a Report DataBlock We are using the convention of appending a QV to the name to indicate this is a QuickView For this example the QV DataBlock is going to allow the end user to select the term and CRN and then list the students enrolled in that CRN and their majors When creating a DataBlock the developer can associated the block to a connection pool or a specific database connection By associating a DataBlock with a connection pool the block can be executed against any database in that pool When the user runs a report based on the DataBlock they will be prompted for the database to which they wish to connect Please refer to the MAPS Installation and Administration Guide for more information on connection pools Page 12 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Logout x amp e e a ee Delete Export Publish Security Publish Site Support Explorer Quick Launch di x E p Banner fH Dev Team Home y Evision
11. Font Fort lt 3 Font Bold No Font Color cheindowText Fontltalics Ho Font Mame Tahoma Font Size B Font Underline Ma Height 13 Layout Top Lett BEA Text set rselnfa Bldg 2w Top GetCrselnio Bldg arene GetCrselnto Course itle Getlrselnto EndD ate Word Wrap GetCreelnfo Instructor Test Run Getlrselnto Meeting ays GetCrselnio Meeting Time GetUrselnfto Room GetCrselnto StartD ate Fig 2 42 Setting Data Aware Attribute Select Term Fal 1995 Select Subject ZIE gt ANTH Anthropology BIOL Biology BUAD Business Administration CHEM Chemistry CHSM Core Humanities Seminar ECON Economics ELET Electronic Engineering Tech ENGL English COURSE SECTION CRN 2310 001 10005 PHIL 2340 001 10006 2430 001 10007 MWF Getting Started Guide Last Updated 06 13 2006 On the parameter form we are going to add a Static text field however we need to make it Data Aware On the attribute form note the label Data Aware Set this to YES 1 Next go to the TEXT attribute 2 Typically you would type the text you want to be displayed This time however note the Expansion arrow When expanded a list of all variables that have currently been defined will be listed Select the variable we just added on the Variables form GetCrseInfo Bldg Change the font of the Data Aware Variable by select the Font attribute 3 Repeat to add other fields from the GetCrseInfo Query Hit the
12. abl E E e a E ou E Gi Height 119 Left 112 Top 1632 Width 114 Fig 2 33 Select Statement for Multi Column Box Page 41 Getting Started Guide Last Updated 06 13 2006 Click Finish to move on Note that the Alias s by defaut will be set as the Column name If no alias is given to a returned value the Column name from the table will be displayed Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support Getting Started Guide Last Updated 06 13 2006 Multi Column Boxes are used to CRNRoster QV create queries or manual entries _commit changes _ Active Connection oen spa that will display multiple columns EEE of data One of the attributes the dtum REL Developer should consider Align None E Lenis e i e No modifying is the Columns attribute Auto Size Colur 0 Cheices Choices KER 1 n rosa Can Ee om C GN DNA isp F m course Here you can assign a Display asi TTM Caption 2 i e the caption that To ju Else wah ganen will be displayed when the data is VariableName MultiColumn c 80 E Left wan lor i displayed The Column Description will appear when the user creates a report
13. 2 Using the shift or ctrl key the user can select more than one column To add all the columns select the double arrows We will not be adding all the fields as we want to format some of the fields To add a new field select E the Equation Builder icon ju Ji Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Edit Beane 7 Choose a Function Categories Date amp Time Logical Math String Select a Function From above Functions Abs ArcCos ArcCosh Arci ot ArcCoth Arci sc ArcCsch ArcSec amp rcSech Arcsin Arc inh ArcTan ArcTanh Cos Cosecant Cash Coton al Fig 5 9 Available Built in Functions Edit Report Expression Builder VendorLastName COAS Desc we Choose Field PO Date PO Numb Printed D Quantity Configure the columns that will be Are one of Ehe Following choices er ate Shipping Code StartDate Tax Amaunt TRANS Date LIniEPrice LIONS vendorEntiby vendarFirskMame vVendorID vendorLastMame Sled Click on the complete list of all the fields from Fig 5 10 Adding Formatted Fields Page 83 Getting Started Guide Last Updated 06 13 2006 When the Equation Builder icon is clicked the expression buillder window wil
14. Argos Getting Started Guide Creating Your First DataBlocks Version 2 0 LAST UPDATED 06 13 2006 Evisions Inc e 14522 My ford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support AT Getting Started Guide n 205 Last Updated 06 13 2006 Table of Contents DOCUMENT OVER VIE caracas dada das 4 E PMA o A 4 Sample Databases nia ana ri 4 1 GENERAL OVER VIE Vide 5 Arsos AFrchitecira ONE EET E T m E I 5 OU snanidaaisi niadazanaiasndii cetra 5 DEP pat 7 A ei ee ee eee eee ee ee 10 PABO OPIO nn 11 2 CREATING FIRST DATABLOCK vasesacice ive ccececesecescsecnseszsseneiesivencetecesssesasecnseecssonsteniveoceteceescesasecnsuezsseanises 12 UNA ds AA nn o o Ano 12 adm Parame S isos coc ses eiiis er neces alati 14 Parancola 19 Parameter Lom Drop Down BOX nd aio 24 Parameter Poe Ib dioe e 29 Parameter Formia Mole olmi Bini denota tdcata 35 Parameter Form Variables i 43 SES Ud MV VLIE S el qe 50 ado a Bebop Databloe edu sconto ani idiom ei decis d 50 A an M 53 Dias TOS NPERNORR 56 Is A A ra 60 Conditional FSU RN sd di 65 OATB A S 67 EU a 67 4 Advanced Report DataBlock vsceecescaciscascesivesscocecaseeessuesssusvesescuciucasveseceshessvecessneveaesoucheeseacecasseess VEA AE PEN ERR Cel Sis 69
15. FPBEOCD FPBEPRF FPBPOHD FPBRCDT FPBRCHD FPBREQH FPBRTRN FPRAGRD FPRBIDD FPRBIDY FPRBLAO FPRDELV FPRENCC FPREOCA FPREOCC FPREOCD FPRPODA FPRPODT ES ennmna r e 24 O 0 cJ C D Aa QQ P9 0 E ff lt all FPBPOHD_CODE FPBPOHD_CHANGE_SEQ_N FPBPOHD_ACTIVITY_DATE FPBPOHD_USER_ID FPBPOHD PO DATE FPBPOHD TRARMS DATE FPBPOHD BLAMKET CODE FPBPOHD BLANKET IND FPBPOHD BLANKET TERM FPBPOHD CLOSED IND FPBPOHD COMPLETE IND Char we Numeric DBTime Char DBTime DBTime Char Char DBTime Char Char Fai A gt y Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Fig 3 5 Adding Table Definition Page 54 typing the name of the table entering enough unique characters to identify We want to add the table FPBPOHD which is the header table for Purchase Orders Every purchase order created in Banner will have at least one record in the FPBPOHD table n The Columns can be displayed in alphabetical order by clicking on E the icon Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATgos Getting Started Guide Last Updated 06 13 2006 If you are editing an existing DataBlock the icon can be used to refresh the table definition Use this if you feel the table definition is not current eg the table itself has been modified
16. E amp y gir uis Hg gie 1 8 gH Farm Design ron Type ca Checked Value Y ont Font FontBeld Yes Font Color cMWindowText Fontltalics Enter Date PE Select Address Type s FontMame Tahoma B FontSize 11 He Select Entity g el Active Adgress Only Name Search Optional Parent Font Required Tab Drder a o Run Query Text Active Address Only z Top a Wie Last Name irst Name Address Zip UnChecked Wa N i Variable Name selectActiveOnly width 181 Record Count addressCount RECORDCOUNT Fig A 4 Check Box Some of the attributes of a check box to note gt Checked By default this value is set to N The developer can change this to Yes and the check box will be initially checked when the user runs the report gt Checked value By default it is set to 1 In the above example the checked value is set it Y The value entered here can be more then one character long Unchecked Value By default this is set to NULL In the above example the unchecked value is set to N Page 94 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 A sample of a query using the results from a Checked Box variable The following query is based on the above example The variable name for the checked box is selectActiveOnly
17. SAM DIMAS SAN DIMAS SAN DIMAS SAM DIMAS SAN DIMAS SAM DIMAS Getting Started Guide Last Updated 06 13 2006 If the Save button is pressed the user can select how to save it as a PDF CSV or Excel Export Here the output was saved as an Excel output Note that the formatting of the report is carried over into Excel The intent of this manual was to provide the developer with a quick overview of how to create a simple datablock and generate a report In addition to this manual there are training materials at the Evisions web site Tutorials in the form of screen cams can be downloaded and reviewed They range from simpe How to Launch Argos to in depth discussions Creating a Quick View Report In addition to the screen cams there are the documents referred to in this manual Page 90 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 endix A Parameter Form Objects Since the original creation of this document new objects have been added to the Parameter form This appendix was added to discuss some of these objects and how to use them affectively A list of all the objects that can be added to a parameter form can be found in Chapter 2 Parameter Tools In this appendix we would like to discuss the use of some of the objects that we have not used in our previous datablocks B
18. This is the SQL statement that will ERRATA riable The associated visual design will not reflect any changes made he select ssbsect Subj Cd Type the value for SelTerm CODE ssbsect subj cd f student get dq from ssbsect where ssbsect term cq group by ssbsect subj 199610 E iz Edit ADO properties Xx gt x e gt ike or and not is mul evisions Fig 2 21 test query populate variable Choice Entry Select the field that will be displayed to the user A y CC Fig 2 22 Associate Retuned Data with Variable Page 31 Getting Started Guide Last Updated 06 13 2006 Once the query has been created click Next gt to continue Because we are using a variable in the where clause it will prompt you for a value to populate that variable with Fill in a valid term code and click ok to continue The first five records returned will be displayed Click Next again to select which field to display to the user A List box like a drop down box ONLY displays one column to the end user Here we are using the Description field to display Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 To complete the List Box definition provide a brief Description 1 Commit Changes Active Connection Form Design Query Design rats ecs Also name the var
19. etc To add a note highlight the report just added 1 and from the menu select Notes Notes Jy 2 Oracle evisions Fig 5 5 Choosing a Connection Rosters Enter Term Code 199520 v Select CRN 10001 t Enrolled Students Studen FullN ame StudentlD Major Level RSTS CreditHR EthnicCode Ethnicl Title HRS Attempted HRS E Adams Ant 610009101 ELET CR RE 1 Ca Institutiona 96 96 Adason Ma 610009109 LAW Li RE 5 Sio Transfer GPA O 0 Babbit Bruce 210009305 ACCT UG RE d 1 Ca Overall GPA 96 96 Bard Celeste 210009519 LAW Li RE Bloom Jenni 210009514 NURS UG RE Bums Benja 610009102 ELET cR RE use format Variable Field Carlson Karl 610009110 LAW Li RE 3 Charles Corey 210009306 ACCT UG RE 5 Sie Clark Cand 210009103 0000 CE RE Vl FullName Correll Nikome 610009103 NURS UG RE Donaldson 610009104 NURS UG RE Edwards Mi 610009105 ACCT UG RE a v CreditHR Gittings Joyce 210009510 LAW Li RE J EthnicCode Henry Paul 610009108 ANTH UG RE Y EthnicDesc Kendzior M 610009106 ACCT UG RE Gender Markus John 210009513 NURS UG RE lt vi PTS Quality Y GPA vi SortOrder Fig 5 6 Run and Save Quick View Report Page 80 Getting Started Guide Last Updated 06 13 2006 Under the DataBlock a new icon will now be displayed To run the report click on the icon or from the menu select execute cente If no default database has been selected the user will be forced to select the co
20. fields have been added If the table is no longer needed in the query remove the table definition by using the button Active Connection DEVL Form Design Query Design rs e frs aria y aora oe A OCA a PE 2 c DAMA 1 a m zm ud FIRBDIS FIRBONC FIRBOND FPBPOHD CODE Char FIRCADC FPBPOHD CHANGE SEQ N Numeric FIRCADT FPBPOHD ACTIVITY DATE DBTime FIRCERC FPBPOHD LISER ID Char FIRCERD FPBPOHD PO DATE DBTime FIRCUDC FPBPOMD TRANS DATE DBTime FIRCUDY FPBPOHP BLAMKET CODE Char FIRCUSC FPBPOHD BLANKET IND Char FIRCUUC FPBPOHD BLANKET TERM DBTime FIRCUUV FPBPOHD CLOSED IND Char FIRDSDC FPBPOHD COMPLETE IND Char FIRDSDT FIRISUM FIRMMKC Type the name of the table Mus RR nie SERIA FIRPFIF FIRPRTC FIRPRTY FIRRIPC FIRSPND FIRSTCC FIRSTCK FIRSTOC FIRSTOP FIRTLTC FIRTOTC lt FIVCASH FIVCUDV Add Table a Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Fig 3 6 Adding Tables Manually Choose Table Multiple tables exist that resemble FPRPODT Choose the table that best represents the one you are trying to add Name Catalog Schema Description FPRPODT FIMSMGR a FPRPODT SYNONYM Fig 3 7 Choose table or synonym Page 55 If you know the name of a table you can add it directly without searching through the list Click on the Add Table button and fill in the name of the table you wish to add We need to add
21. folder the available options are listed A folder can be renamed In naming a folder do not use spaces Under an existing folder a new folder or DataBlock can be added In addition to the normal cut copy paste delete functions a user can also export a folder To export an object select Export from the option menu When prompted enter a file name By default the file will be named the Object name followed by the current date in YYYYMMDD format An extension of argosexport is automatically added Security can be set at the folder level The security set at folder level will default to the objects inside the folder This topic is beyond the scope of this document Page 10 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide 205 Last Updated 06 13 2006 DataBlock Options Sen DataBlock options are similar to Win L3 m Rx cR NIME A those for the folder except the Se d Cut Copy A i pot Export nl Publish Security Publish Site Support b only obje ct that C an b e adde d EDS EE below a DataBlock is a report 3 z ew Campaign Summary Reports gt A j Pe Default security for a DataBlock is 6 ie me ee inherited from the folder level If n e nis na Add to QuickLaunch E View edit the notes on this DataBlock cha nged the secu rity Will be i LET dans inherited for any new object i e BE hd d Publis
22. gt lt gt lke or and not is nul Fig 3 1 Customer Query for OrderReport After adding the new DataBlock click the Edit button This will take you immediately to the Query Design screen First we will need to create a parameter that will pull back the Vendor IDs To do this go to the Parameter Design form and add a List Box as outlined in the previous chapter We want this to be a Multi Select so the end user can select one or all vendors Therefore make sure to set Multi Select to YES We also want to narrow the Purchase orders for selected date range We wil add two date objects to define this date range Page 51 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support Ar Getting Started Guide ATZOS Last Updated 06 13 2006 PurchaseOrder BG Active Connection e DEYL al A s Form Design Query Design Parameters Variables ox Lena Saas w DateEdit Pea to eee ng aeu uq Lii Date 12 30 1992 a __ ua gt _ ____TTtT TtTt j Purchase Order Information Description Font FontBold No FontColor chvindowT ext Fontltaics Na FentName Tahoma Font Size 8 Font Underline No Height Lett Parent Font Required Tab Order Top
23. i Eod E dod EY bod I bd dE EIL OR A Y 4472 21 71 1728 78 7037080783570 ee oe 73 b Pod c go ag 4 o4 do 3 4 oa Po a P3 4 3 dod doi vod amp E y Pee Per pF po 8 FO EP BG pp opp 03 po A A i 4 a 4 d 4 4 M MH M B EH E M ZW EM B NH E b bk H E b Lb I b A Pb bo i A A A do asd doc 3i 70 Li A A B E amp Ckoa br Ato E tar t tta t UT vor P d ro dod go nm o3 or dod amp or b ro dod d EU rw poro Topo ro p pono p pom PP no pps Bin bob gor pb bo rr amp d ror pod or do o3 03 do A d dE r0 d odor og amp o whb hmst3 Lb Re gd rs b dari A n BD pha A DO E a AT on Mod ilb iut bu biu PrP PP Pop Ph Pop hap rh hoop Pm hop pos v r w id end d ror d d aon d d eer dP d ror d d rca vr amp br r kb do ror amp d eb od as dod rr bk A amp bb diede bod d c bod P og Pod d r Bodo c bod d oa oP moror hor WOFr p or d OF FF VOF 0978 103 3 3 8 plone so rogo rom oe po WP ee e POR Bo Pon 8 pr m d 2 p Po gor o Po nna o kd BL b b rd di i dor a A Gk dl a repo Pag bem Workspace Fig 2 8 Parameter Tool Bar What you are creating at this time will be visible by all users who have the proper permission to run the report Along the top of the grid on the right half are the tools available for creating the controls and or parameters Page 17 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Gett
24. np Variable Name User DbMame Description EmailAddress Name MAPS logon name of the u E Control COURSE Course Number CRM SECTION I SelSubject Description Subject Description Usage Settings regarding the us System ADO connection logon na Description of the user Email address of the user Sample using list box Control Term code selection Control i SelTerm CODE This is the term code TERM Fig 2 36 List of Variables Page 43 When creating the query or manual entries for the different boxes the values returned will be stored in variables To see all the variables that have been defined click on the Variables tab from the Parameter form window The list of variable objects will be displayed To see the full list of variables click on the plus sign to expand In addition to the variables that are being returned via the parameters there are other Argos system variables that can be used SUSER name will automatically be set to the user id who is running the query This could be useful for keeping an audit trail or for determining is this user has the proper access to the underlying tables These are referred to as System Variables Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 At this point we still have not answered the question What Commit changes BERE
25. the user can select multiple values that can be used in subsequent queries canoer 4d Add a List Box by clicking on the Active Connection DEVL a O T List Box icon place the object Gud nos ax oras sr o T on the Parameter Form and select ann Select E A ces for this control can be typed manually or populated by a SQL statement Choose ug choices 1 n ESR Choices opriate mode then dick Next ie a Manual entries A n A dis e Osee As this will be another SQL statement set the apporpriate Top 312 VariableName ListBox Width 121 mode to SQL 2 SSS Page 29 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ar Getting Started Guide ATZOS Last Updated 06 13 2006 Choice Entry This is the SQL statement that will retrieve the choices for the end user Each SELECT field will become a sub variable The associated visual design will not reflect any changes made here select ssbsect subj code as Subject ssbsect subj code Il f student get desc S5TVSUBJ ssbsect subj code 30 as Description 35bsect ssbsect term code SelTerm CODE group by ssbsect subj coded Edit ADO properties gt lt gt lt gt ike or and not is nul Fig 2 19 Select Statement for List Box This time we are going to create a query that will return the SUBJECT CO
26. 2006 ENS aa We need to be able to instruct or E m Doc ni inform the end user of what they Frame varabies ax Lomas ar wo should be entering or selecting PE d utin cs o We can do this by adding text to em 2d describe the parameter To add a Font Font AA A text objext select the M and Font Size 12 Bold 1talics C Underline position the cusor on the blank form This will open a box with the words Type Text Here Font Underline No Height ABCabcXYZxyz 0123456789 On the right hand side are the properties for this object To enter text go to the Label Text 1 and enter the desired comment In IM this example type Fig 2 10 Adding Text to Parameter Form Select Term To change the font 2 click on the Font box You can select the style color and other attributes In our example we have set the color to clMenuHighlight the font to Tahoma and th font size to 12 Page 22 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 Using the attributes the developer can VV ON Vv YYYY Align This will move the text object to various spots on the form Alignment The user can left right or center the text within the defined text box Auto Size If set to YES the text box will automatically resize if the size of the text within the b
27. ATOS Last Updated 06 13 2006 4 Advanced Report DataBlock The DataBlock defined in the previous example was pretty straightforward By first selecting the tables and creating the relationship the majority of the WHERE clause was created for us For example in to operating accounting ledger table FGBOPAL all the data for each FOAPAL is strung out in one row i e one row contains the budget information for multiple periods If you wanted to return one row per period for selected FOAPAL you would need to do a UNION In addition there are times that a WHERE clause is more complex and requires a sub query Argos provides a method of creating a sub query and using this in the WHERE clause In this chapter we will discuss adding a UNION and a subquery The final topic will show you how to create a query without using the wizard Unions The one caveate with UNIONS is that each select statement must have an equal number of expressions in their list In addition these expressions column names literals dates results from functions etc must be of compatibile data types For example if the expression evaluates to a date in one query it must evaluate as a date in the second Argos will not check the syntax of the UNION until execution so it is up to the developer to make sure these conditions are met To add a UNION go to the Query Design window and click on the icon along the top The next form allows you to select the typ
28. Belo Description mis in the Query Designer Fig 3 7 Review SQL Statement At any point you can review the SQL statement that is being built by clicking on the Review SQL button Notice that the joins are automatically built into the WHERE clause of the SQL statement that has been built thus far It is also important to save your i work while working To save what PurchaseOrder tive Connection has been built to date push the Commit Changes button on the Form Design Query Design form Tables Hide Tables Show Union Fig 3 8 Commit Modifications Page 59 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATOS Adding Fields FIMSMGR FPBPOHD FPBPOHD Index Mame Type Tall FPBPOHD CODE Char Numeric DBTime Char DBTime DBTime Char Char DBTime Char 1 E 3 4 J B a a Visible Fields SELECT Conditidnal Fields WHERE Ordering ORDER E gt coi Table FPBPOHD aR Field FPEPOHD CODE Type string As PO Number Description Ma es Fig 3 9 Adding Fields by clicking Page 60 Getting Started Guide Last Updated 06 13 2006 Now that all the tables have been added the developer will need to add the fields that we want to pull data from There are several ways of adding a field to a query The easiest is by double clicking on the
29. Date Printed Date HVL FPBPOHD CLOSED IND N Closed BUYER _Code HVL FPBPOHD COMPLETE IND N Complete pare Nene FIMSMGR FPBPOHD FPBPOHD PO PRINTED DATE Printed Date COAS Desc FIMSMGR FPBPOHD FPBPOHD BUYR CODE BUYER Code COAS Status FIHMSHGR FTVBUTE FTVBUTE NAME Buyer Name SHIPPINGCode FIMSMGR FPBPOHD FPBPOHD COAS CODE CoOAS cabo cada SUBSTR f get finance desc FTVCOAS FPBPOHD COAS CODE HULL 30 1 CommodityDescription SUBSTR f get finance status FTVCOAS FPBPOHD COAS CODE HULL 1 10 UOMS Code FIMSMGR FPBPOHD FPBPOHD SHIP CODE SHIPPINGCode tein FIMNSMGR FPRPODT FPRPODT ITEM Item Number A SEE FIMSMGR FPRPODT FPRPODT COMM CODE CommodityCode Discount Amt HVL FPRPODT COMM DESC FTVCOMM DESC CommodityDescription A FIMSMGR FPRPODT FPRPODT UOMS CODE UOMS Code VendorPIDM FIMSMGR FPRPODT FPRPODT UNIT PRICE Unit Price LaskMame FIMSMGER FPRPODT FPRPODT OTY Quanity FirstName FIMSMGR FPRPODT FPRPODT UNIT PRICE FIMSMGR FPRPODT FPEPODT QTY tate FIMSMGR FPRPODT FPRPODT DISC AMT Discount Amt ID FIMSMGR FPRPODT FPRPODT TAX AMT Tax Amount FIMSMGR FPRPODT FPRPODT ADDL CHRG AMT idditionalCharge P FIMSMGR FPBPOHD FPBPOHD VEND PIDM VendorPIDM SPRIDEN SPRIDEN LAST NAME LastName SPRIDEN SPRIDEN FIRST NAME FirstName SPRIDEN SPRIDEN MI MI SPRIDEN SPRIDEN ENTITY IND Entitiy SPRIDEN SPRIDEN ID ID FIMSMGR FPBPOHD FIMSMGR FPRPODT FIMSHGR FTVBUYR v ii m y
30. E3 1 Select the Condition here we are selecting lt 2 and fill in table and column Here we are indicating the table SGBSTDN field SGBSTDN TERM CODE EFF should be lt to the MAXIMUM sgbstdn term code eff for the selected student Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support AT Getting Started Guide ATZOS Last Updated 06 13 2006 In the final query the WHERE clause would read and SGBSTDN SGBSTDN_TERM_CODE_EFF select Max A SGBSTDN_TERM_CODE_EFF from SATURN SGBSTDN A where A SGBSTDN_PIDM SGBSTDN SGBSTDN_PIDM and A SGBSTDN_TERM_CODE_EFF lt TERM TERM Page 74 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support IA Getting Started Guide Argos Last Updated 06 13 2006 Advance Query In Chapter 3 we spent a great deal of time showing you how to create a query using a point and click method to add tables and fields There are times you already have a SQL statement created in some other tool and you really just want to drop that query into Argos without having to manually re do the query This is possible by using the Advance Mode Query button On the top of Argos datablock form you will see three icons dai The first one green arrow we have used to review the datablock we have created to date The spyglass allows the developer to look at what
31. Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 The following form displays the columns for the selected table To er add a column to the query double SSBSECT_TERM_CODE SSESECT_CRI jar click on the column name you want SSBSECT_PTRM_CODE SSBSECT_SUB _CODE r SSBSECT_CRSE_NUMB ar to a d d n SSBSECT_SEQ_NUMB ar SSBSECT SSTS CODE SSBSECT SCHD CODE SSBSECT CAMP CODE Decree uA x Here we have added the column SSBSECT CREDIT HRS i DA SSBSECT CRSE NUMB Note the SSBSECT SAPR CODE Sr Ow column appears in the GRID on the SSBSECT LINK IDENT E iui y bottom of the form HA x In addition to the column you can og MM add an Alias by typing a value in ec E mea o the alias field of the grid Here we O asign the alias of COURSE escription Fig 2 29 Add SSBSECT_CRSE_NUMB Page 38 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 Continue to add the following columns gt SSBSECT SEQ NUMB as SECTION gt SSBSECT_CRN as CRN Once the fields are added we want to filter the values by the term and subject that the end user selected Click on the Conditional Field tab to add the conditions in the WHERE clause Double Click on the SSBSECT_TERM_CODE to add to the grid
32. JA Getting Started Guide Argos Last Updated 06 13 2006 Now if we go ahead and add a text object the font by default will inherit the properties of the font set for the parent show objects Form Design Query Design Parameters Variables IS x A d abr E e sie Er zl Ok ij d E Ca us 3 dr Ue uH Align None Alignment Left Auto Size Yes Data Aware No Font Color clBlue _ Font Italics es Font Name Verdana mm Since Parent Font is set to YES the Height 293 text field just added will use the ros to default font set for the parent or Parent Font Yes background Text Type text here Top Width Word wrap MEE Fig A 2 Sample using property of parent Memo Box Adding a memo box B allows developer to add an object where massive amount of text can be added Using a Memo box is one way of adding information to the end user as to how to run this report If added to a background it can be set to use the default font set for the background Page 92 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support IA Getting Started Guide Argos Last Updated 06 13 2006 show objects Di Commit Changes Active Connection fx Rem EI oo ogo Hg ue 8 gl FontColor clBlue Fontltalics Yes Font Name Verdana A This is a Memo Box where the developer E Font Linderline Yes can add information
33. SQL function provided by Banner Argos allows the user to create such fields From the Table row of the Visible Fields SELECT grid choose calculated from the drop down list Next click on the Field row on the grid and a SQL Editor box is displayed Here the developer can create a field using SQL functions In this example we want to pick up the first three characters of the Product description We will use the Banner function to return the Chart of Accounts description Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATOS Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY y e c 5 Xx c 5 xX 3 c 5 X Table FPBPOHD calculated amp Field FPBPOHD_CODE F get finance desc FTVCOAS Type string date time string As PO Number ActivityDate COASDesc Description Purchase Order Number Using Banner Function F get Fit FPBPOHD FPBPOHD ACTIVITY DATE Modify Text Using Banner function f get finance desc return description for Fig 3 14 Adding Description for Calculated Field SQL Editor FPRPODT FPRPODT UNIT PRICE PRRPODT FPRPODT QTY 10 is null like or and mot Fig 3 15 Adding Calc Field using Built in Argos Functions gt fF KE FS LIE Libor IDE Char YENG JDE NT IND OFF IND FPBPOHD FPBPOHD ACK DATE FPBPOHD FPBPOHD ACTIVITY DATE FPBPOHD FPBPOHD ADD
34. SSRMEET TERM CODE SSBSECT SSBSECT TERM CODE and SSRMEET SSRMEET CRN SSBSECT SSBSECT CRN and SCBCRSE SCBCRSE SUBJ CODE SSBSECT SSBSECT SUBJ CODE and SCBCRSE SCBCRSE CRSE NUMB SSBSECT SSBSECT CRSE NUMB and SIRASGN SIRASGN TERM CODE SSRMEET SSRMEET TERM CODE and SIRASGN SIRASGN CRN SSRMEET SSRMEET CRN and SIRASGN SIRASGN CATEGORY SSRMEET SSRMEET CATAGORY and nvl sirasgn primary ind Y Y and SSBSECT SSBSECT TERM CODE SelTerm CODE and SSBSECT SSBSECT SUBJ CODE SelSubject Subject and SSBSECT SSBSECT CRSE NUMB SelCRN COURSE and SSBSECT SSBSECT SEQ NUMB SelCRN SECTION and SSBSECT SSBSECT CRN SelCRN CRN and SCBCRSE SCBCRSE EFF TERM select Max A SCBCRSE EFF TERM from SATURN SCBCRSE A where A scbcrse subj code ssbsect subj code and A scbcrse crse numb ssbsect crse numb and A scbcrse eff term lt ssbsect term code Page 48 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support CRNRoster QV Commit Changes Active Connection DEVL Form Design Query Design Parameters Variables Label Align Mone Alignment Left 1 Autos ize Tes Data Aware Vez lt
35. Test Icon and review the output Note that the Course information is displayed for the selected course Fig 2 43 Final Test 09 00 am 09 50 am Thomas Preston Intermediate Accounting I Retrieve a maximum record s Page 49 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 3 REPORT DATABLOCK Adding a Report DataBlock A complete report can be written by just using the Parameter Form However to give more flexibility or create more complex reports you can also create a Report DataBlock By using the Report DataBlock the developer has more control over what the end user will see This Report DataBlock can be used to answer a multitude of questions When the end user creates a report from a Report DataBlock they will also have more control over what is displayed They can generate a report containing only the columns they want to be displayed In addition the data can be extracted for further manipulation into programs such as Excel or the finalized report can be printed Argos includes a Band Editor that allows the output to be fully formatted Add the DataBlock the same way as CRNRoster QV was created Review the steps as outlined in Fig 2 1 to 2 4 In our sample we will call the DataBlock PurchaseOrders We want to be able to run reports that will show any orders place
36. about the datablock i 134 ME Paca ves Word Wrap is automatically set as aresc Read Only Ma wl Required Yes i E E Tab Order 0 Text i ext Top A Variable Name memoStaticT ext da Width 474 Word Wrap Yes Fig A 3 Use of Memo Field Other attributes for Memo Field Data Aware This is similar to the text object If Data Aware is set to YES then any previously defined variable can be displayed in a memo field For example using a Memo object the developer can display a long wChar field in SglServer Read Only Set to YES the end user cannot update the text in the memo field Set to NO the end user has write access to the data The data in the memo field can then be used in subsequent queries Page 93 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support f Getting Started Guide Argos Last Updated 06 13 2006 Check Box B The Boolean button is a True False button The developer can assign distinct values depending on if the box is checked or not By default the check value is set to 1 and the uncheck value is set to NULL However the developer can set these values to be anything In the following example the check box is being used to limit the addresses that are returned in a subsequent query Technical Training part 2 complete PE Active Connection DEVL Y Os ax A ew EIBe an sw 1 29 er EH Bl
37. as a Banded Report A Banded Report can only be added to a Report DataBlock Using the Band Editor the developer can product fully formatted reports that can be saved as a PDF file or previewed and printed The formatted report can also be saved as a Rich Text Format rtf or Excel format xls Using the Band Editor you can also produce mailing labels For complete instructions on using the Band Editor see the Argos Band Editor User Guide New report definition Select report type CO New blank report ORDERS 1997 9 List style Month Articel Amount Sum fall records listed in columns C Tabular reach datafield on a separate line CO Form style one page Far each record Single Form only one record an one page Mailing labels Fig 5 13 Banded Report Definitions Page 85 Add the report using the steps outlined above but select the Banded Editor icon On the next screen you can select the type of report you wish to create Using the first option New Blank Report you will be taken to a completely blank page where you design the report from scratch For more information on using this option check the Argos Band Editor User Guide The other options will assist you in creating a report We will be creating a List Style Report where all the records will be listed in columns Click Next to continue Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730
38. ch c E to Pr Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY gt ao xX Fable A Field SGBSTDON TERM CODE EFF Type string As Description Summing Fig 4 5a Add Condition to Sub Query Getting Started Guide Last Updated 06 13 2006 Using what you have learned earlier we will need to create the following query select Max A SGBSTDN_TERM_CODE_EFF from SATURN SGBSTDN A where A SGBSTDN_PIDM SGBSTDN SGBSTDN_PIDM and A SGBSTDN_TERM_CODE_EFF lt TERM TERM To add the MAX select the column as normal SGBSTDN TERM CODE EFF and then click on the summation sign gt A new row is displayed in the Visable Fields labeld Summing Here select MAX to choose the Maximum term effective term code Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support SATURN SGBSTDN A Index Mame Tall SGBSTDHM PIDM Type Mumeric SGBSTDN_TERM_CODE_EFF char SGBSTDMN STST CODE Char SBS TON LEVI CODE Char SGBSTOMN_STYR CODE pens DAL PER SQL Editor MllocesTDN SGBSTDN_P 11 SHRLGPA_GPA_CALC Pick one of the Following choices SGBSTON SGBSTON MAIR CODE CONC 121 SGBSTDN SGBSTDN MAJR CODE CONC 122 SGBSTDN SGESTDN MAJR CODE CONC 123 SGBSTDN SGBSTDN MAJR CODE CONC 221 SGBSTDN SGBSTDN MAJR CODE CONC 222 SGBSTDN SGESTDN MAJR CODE CONC 223 SGBSTDN SGBSTDN MAJR CODE DUAL SGBSTD
39. developer needs to make more information available to the end user for either selecting or for a final report A Multi Column Box is used to display multiple columns of information In our next object we want to offer the user a list of all the courses that are taught for the select term and subject This is the SQL statement that will retrieve the choices for the end user Each SELECT field will become a sub variable The associated visual design will not reflect any changes made here Fig 2 26 Select Statement for Multi Column Box Page 35 Add a Multi Column Box by selecting the Multi Column icon 2 position where you want select CHOICES and create the SQL statement In this case we are going to create a query based on what is being selected by the end user from the DropDown list That is the values returned in the query will be filtered by what the term code selected by the user Weare also going to use the query builder to build the query Click on the little hard hat icon amp to move onto the query builder form Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 We will go into more detail on how to use this form in the next chapter For our purposes we just want to create the query that will display the courses taught for the selected Term and subject Im First click on the A
40. field name displayed in the Table description In this example the developer double clicked on the fpbpohd_code field and it droped down to the Visible Fields SELECT section At this point the developer should assign an Alias to the field This will be the name that is displayed to the end user Make the name meaningful as again this is how the end user will refer to the field In addition to a short description the developer can and should assign a Long Desc ription The long description will be used to give more information to the end user Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATpos visible Fields SELECT Conditional Fields WHERE Ordering ORDER Ev y ax a c 0 X Table FPBPOHD FFBPOHD ha EE Field FPBPOHD CODE calculated As PO Number FPRPODT Description Purchase Order Number FTVBLIVR FT omm Fig 3 10 Adding Field Manually Selecting Table visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Table FPBPOHD FRBPOHD eR Field FPBPOHD CODE PBPOHD ACTIVITY DAT Type string FPBPOHD CODE As PO Number Description Purchase Order Number FPEPOHD BLANKET CODE FPBPOHD BLANKET IND Fig 3 11 Select Field Manually Selecting Column visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY gt ax e c 5 3 Table FPEPOHD FPBPOHD eR Field FPBPOHD COD
41. has control over what fields will be displayed as well as how they are displayed Using the Banded Report the end user can organize the data into logical banded areas The final output can be printed or saved in some other format QuickView Reports We begin with a different sample than the one created earlier in the document We will be accessing a roster based on Term and selected CRN After the complete roster is accessed the user can pull up the schedule for a selected student and obtain their GPA Page 77 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Argo Explorer Quick Launch porer rai E Rosters quickview E n Ww New DataBlock Eh Alumni Er AR Execute this DataBlock as a Quickvi ur 24 Finance Edit this DataBlock Gh OrderProcessing E s Payroll Delete this DataBlack E Student ly Si Viewledit the notes on this Dataglo Ey Catalog Le Faculty Mew Report Create a new Report From this Dat amp o Fincial id CM ecurity Edit the security settings For this De _y GeneralStudent Publish Publish this DataBlock to the Argos E Rosters Associated Connection Pool Author Administrator Date Created 3 26 2004 2 03 11 PM 10 11 2004 11 11 11 AM A Detail Roster LA Detail Roster By Department amp New DataBlock A Rosters quickviews Xx SummaryRoster Execute E SQLServer ES A Advisor ES x BasicAdmission E
42. i students are enrolled for selected CRN Go back to the Parameter form Since the next element we add will also be the finished report we can divide the data by adding a line between the selection criteria and the final data Form Design Query Design Parameters Variables Shape wes mew Adding a shape can help in dividing your form or giving the form EN T more presence Click on the shape Icon GI and position the A al shape Click on the Shape property to select the type of shape Fill Color clBlack EE We want to add a rectangle We will also need to change the fill Left 145 color to Black and change the height to 2 and width to 534 This will se Penne produce a long black line Square Width Round Rectangle Finally add another Multicolumn box to display the roster for the selected course Fig 2 37 adding a shape This is the complete query We are pulling back the student name as well as additional information SELECT SPRIDEN_PIDM as PIDM SPRIDEN LAST NAME SPRIDEN FIRST NAME as FullName SPRIDEN ID as StudentID SGBSTDN MAJR CODE 1 as Major SGBSTDN LEVL CODE as Level SFRSTCR RSTS CODE as RSTS SFRSTCR CREDIT HR as CreditHR SPBPERS ETHN CODE as EthnicCode STVETHN DESC as EthnicDesc SPBPERS SEX as Gender FROM SGBSTDN SPRIDEN SFRSTCR SPBPERS STVETHN WHERE SGBSTDN PIDM SFRSTCR PIDM AND SGBSTDN TERM CODE EFF SELECT MAX SGBSTDN TERM CODE EFF FROM SGBSTDN WHERE SGBS
43. iieiessesouusssusuanussssnRERsRRUEREWAEEARREFRRER RRESEERESESARERRRERERESSEEREEESERESEEE 91 A 2 Sample USING property OF parent corria AAA AAA AAA ARA 92 A 3 Use Of Memo FICIG ivi a 93 mg CHeck BO Cai AAA AAA DA AAA 94 A e o PPP 96 Page 99 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support
44. launched Argos from this machine you will receive a security alert asking if you wish to install the user client To avoid having this message being displayed every time the application is launched check the Always trust content box Click Yes to continue This will result in the Argos application being launched The Login form will be displayed You will use the login username and password provided by your administrator You can instruct Argos to remember the password The first time you log onto the system there will be no defined server To change the server click on the Edit Servers link Username Password did Remember the password for this user MAPS_Server Server Address MAPS Server Use the default port Fig 1 4 Login Screen Desktop File Edit View Tools Help ts Ub id a E 9 Logout Import Export Security Publish Site Support Benet Horis i 1_ Root Folder y amp 1 Banner 1L Banner i_ Dev Team Home Dev Team Home 14 Evisions Training University Evisions Training University 1 Evisions University J Evisions University InternalApplication InternalApplication _ our training today 4 our training today LL TrainingExamples TrainingExamples J TrainingSamples H jJ TrainingSamples 14 UniData 1 UniData user ehos Fig 1 5 Explorer Tree and Detail Getting Started Guide L
45. let s add a nice graphics or image to spruce up the Parameter form Select the image 9 icon and indicate on the form where you want to place the image The File open window will be displayed Drill down and select the object you wish to add and select open Normal image files are supported including animated graphics Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support CRNRoster QY Commit Changes Active Connection Banner Db a Form Design Query Design Parameters Variables Image Alian None AutoSize No Center No Height 105 Image Image Left 24 Stretch Top Transparent Width Fig 2 9a Image properties Page 21 Getting Started Guide Last Updated 06 13 2006 Once an object or control has been added the attributes or properties of that control are shown in the property pane Setting AutoSize to YES will ensure that the entire image will be seen Set it to NO to if you want to control what is visible to the end user You can manually move or reposition the image or use the property tab to change the image location We recommend the JPG or GIF images be used in place of BMPs due to size of the image Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide e OS Last Updated 06 13
46. lg n E 69 A 71 LIA A ICE 75 Si COH NER T T e T1 Occ Ie RE DOS T A NEN T T EET 81 BI 85 SAA 90 Appendix A Parameter Form OD GS secssecccscctesenccceecccssscsazssessecccssscecesseesccccsecssausanvascecedsdesenseestcvececsesusssvetedest 91 Page 2 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide 205 Last Updated 06 13 2006 Background 9 ii 92 VS disi RORRE u A 94 DN TT X A 96 Table of FU CS e 98 Page 3 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 Getting Started Guide for Banner Users We encourage you to inform us of any errors you may find in this guide and we ask that you please forward suggestions that will make this document more relevant understandable to those that will follow We listen to our users to always try to improve our lit
47. list Optionally select the creator of the SmartObject No query is executed even if one exists For the object Datablock and select New Report Comma delimited CSV SMISE from the menu Choose the type of report that Argos should generate Banded graphics text charts etc From the list of options select the Comma Delimited CSV option 2 Note that even though this is a Report datablock you can still create a QV report However the main query will not execute Fig 5 7 Types of Report DataBlock Reports Click Next to continue Page 81 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support PO Number CalcDiscount StartDate EndDate PO Date TRANS Date Closed Completed Printed_Date Buyer_Code Buyer Mame COAS COAS Desc v Write column header zs Fig 5 8 Select Columns to Appear in Report Cancel Page 82 Getting Started Guide Last Updated 06 13 2006 The next form gives the option of selecting which fields or columns to include in the report Initially all the columns are listed on the left side Note that the alias that were assigned by the Developer are the names that are listed Also note that if any descriptions were given for a column they would be displayed when the column is selected 1 To add the column to the report select the column and press the single arrow
48. the SQL statement i e what fields or columns to include and how tables are related However there is normally a need to limit the query by some criteria In our sample here we want to limit what is being shown by the vendor id s and the date range selected on the parameter form This requires us to add a criteria or parameter via the Parameter Design form fa Visible Fields SELECT Conditional Fields WHERE ordering ORDER BY root Fig 3 18 Adding Conditional Fields ao 3 and or and 3 Table FPBPOHD z Condition TA FPRPODT FTVBLIYE FT OMM Fig 3 19 Adding Table to Conditional From the Query Design window click on the Conditional Fields WHERE tab 1 Fields columns are defined or selected the same way as described when creating the select statement We need to add the conditions to only select the PO for the selected Vendors between the selected dates First select AND or OR as the condition 2 Then select the table CUSTOMER from the list of tables 3 Next add the field 4 ad andeor and Table FPBPOHD Field BPOHD VEND PIDM gt anditian FPBPOHD BLANKET CODE FPBPOHD BLANKET IND FPFBPOHD BLANKET TERM DATE FPBPOHD CLOSED IND FPBPOHD COMPLETE IND
49. 06 Argos Evisions Inc In the expanded view note that PAE 0 89 Folders can contain other Folders EE Quick Launch Root Folder amp v Ls as well as DataBlocks Ly Alumni AR T im Ly Finance Ly Betsy Bi DataBlocks hold the definitions dp Tee E from which the reports will pull Folder i UnderConstruction th ej r d ata A YearlyBalanceSheet 7 OrderProcessing de nverageorder Q A DataBlock can either be in the A Order Report d diii form of a Report or a QuickView Student X Training 1 UnderConstruction DataBlocks in turn may contain user administrator reports Any report identified with Fig 1 6 Sample Explorer Tree Expanded the icon is a report created from a QuickView DataBlock A or icon indicates that the report was created from a Report DataBlock The Datablock is the foundation from which all reports are created The datablock consists of two parts the Parameter form and the query design The parameter form has two functions First it is used to have the user executing the report a chance to enter or choose from a list certain parameters that will be used to filter the data displayed in the report Secondly the parameter form can be used to display the final results of the report The parameter form can be a complete report in and of itself For example if all I want to see is what advisor is assigned to a certain st
50. 2524 e http www evisions com support New report definition Main dataset For report aes Ss E Dx Fip om p h im mi EJE Ei Lies i Fig 5 14 Select Dataset for Banded Report New report definition Please select the Fields vau wa Available fields CustomerPhoneT ype InvniceMumber OrderDate InvaiceDate StatusDesc StatusCode ProductPrice ProductMumber ProductDescription Qty TotalPrice Salesman Fig 5 15 Select Fields nt to include in your report Fields used in report CustomerID Custhame Customer address AddressTvpe Customercity Customerstate Customer IP CustomerPhone OrderMumbe Page 86 Getting Started Guide Last Updated 06 13 2006 On the next form you will select the dataset which contains the data on which the report will be based Select the ArgosData option and click Next to continue The next window will display all the available fields You can add one at a time add all the fields or using the shift or control button select a range of fields to add Click Next to continue Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support New report definition Please choose the report bands to be created Reportbands Page Header Title Summary Page Footer Fig 5 16 Select Bands New report definition General report options Report title Customer List
51. 38 Completed roster Page 45 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 At this point we have produced a roster for a selected CRN Lets go one step more The person you wrote this report is satisfied but would like to display additional information about the course For example they would like to know where and when the course meets We could create another multi column field but in the interest of learning something new we are going to use a unique feature of Argos that allows a Text field to be used to display Static text i e labels as well as variable text Using a data aware text field you can have a text box display any defined variable a h Lets first add a new SQL query that will commit changes _ Active Connection 16 DEVL v BA ni retreive information about the selected Parametere Varie dx ismano Sees uil CRN Click on the Variables tab oP x mo suit m gH B E d BL gt gt ay all m m 0 EZ A A A 00 0 0 0 0 0 0 To add a new SQL variable on the Variable 1 I Selsubject Sample us GAS INES ESAS ASS Tato ee en scwpw yx_ur MK Li stem CU As Form click on the plus icon e The SQL SQ SalVariable SQL Editor Bn select SUBSTR NVL SSBSECT CRSE TITLE SCBCRSE TITLE 1 40 as f ii ed itor WI nd OW WI m med lately be
52. 49 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide n 205 Last Updated 06 13 2006 Adding Query PurchaseOrder Active Connection DEYL v5 a Form Design Query Design Parameters Variables E Lx M dX favi E Ge x j za 9j E i con BL to oo dg ue m o Fig 3 3 access Query design form to write main query We have added the parameters we need to filter the data Now we need to pull back from Banner the information about the PO s for selected vendor s Eventually we want to create reports that our end users can quickly print off or save as a PDF file or even schedule to be run in the evening To do this we need to use the Query Design form which is accessible by clicking on the Query Design Tab A blank form on which we will create our query will be displayed PurchaseOrder Active Connection DEYL v5 a Form Design Query Design Show Tables Add Table Sub Query SQL Format Oracle A visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY e Field Table Description To add a new visible Field double click or drag a field to this area from one of the added tables in the Query Designer Fig 3 3 access Query design form to write main query Page 53 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Up
53. 6 13 2006 On this screen you can add and modify the appearance of the report itself Complete instructions on using the Band Editor can be found in the Argos Band Editor User Guide You can test the report by cllick on the Preview icon E This allows you to review the output before saving To save the report created click Next You will be taken to the normal form where you fill in the name of the report itself indicate if this is a public or private report and give the report a description This is what the end users will see when the report is executed They will first be presented with the list of parameters After making the selection they then will be asked if they want to preview or save to a PDF Here we have selected Preview From the Preview screen the user can search for a value Wy print the report directly 2 or save the report ld ATpos Customer List Customer CustName VILE VILE VILE VILE WILE VILE VILE VILE VILE VILE VILE 84 ee _ 2 Customer Address hy CustomerCi gar N gar N gar M gar M gar N gar M 390 N gar N gar N 990 N gar N BILUNG BILUNG BILUNG BILLING BILLING BILUNG BILLING BILUNG BILUNG BILLING BILUNG Fig 5 22 Saved as a Excel Spreadsheet That is all you have created simple datablocks and reports The next step is to continue to experiment with the product and have fun Conclusion SAM DIMAS SAN DIMAS SAN DIMAS SAN DIMAS SAN DIMAS
54. A gt gt x gt lke o and not is mull Edit ADO properties Fig 4 8 Advance Query Builder Form completed Security on fields can be set on the Free Type form in the same manner as on the Query Design form The main thing to note is that when building a query it is either or You can either use the Free Type or the Query Design Page 76 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 5 Reports The developer or users who have been given the proper Argos permissions can create reports Please review the Argos Administration and Argos Security White Paper for further information on adding users and modifying security There are three general types of reports A Quick View Report is based off of a QuickView DataBlock Although the user can save the returned data the power of a QuickView Report is that the user can quickly and easily retrieve view the data with a minimum of trouble This really is Information Access The second type a CSV Report is based on a Report DataBlock Here the report creator has more control over what fields will be displayed and how and may add fields The selected data will be extracted in a form usable by other applications The final type is a Banded Report This also is based on a Report DataBlock The report creator
55. AAA AAA AAA A A AAA 22 2 41 DrODDOWH BOX at A A AAA AAA A A ai 24 2 12 Manually Enter Value cuina AAA AAA AAA AAA AA 24 2 13 Sample SQL Statement for Drop Down BOX 222 222222222 22222222222 2 RR MERE ERRRRRRRERERRERRRRRRRR ii iii 25 2 14 Data Returned from Test asisesisax xxnexa sana ian 26 2 15 Associate Data Field with Variable vm 26 2 16 Drop DOWN ACCHIDUEIGS iia AAA AAA AAA 27 2 17 est Parameter FO a 29 210 letali ote LIST BOX Rc 29 2 19 Select Statement for List BOX iii nitri Gan C AAA AAA CROCO AAA 30 2 20 Listof defined v rl Dls sccuscerinrssevascssacerisesteneseusseans AAA AA AAA AAA 30 2 21 test query populate variable viviana ORO IEEE 31 2 22 Associate Retuned Data with Variable 5 5 5 252s252ss2s522522522522522522522 5 31 2 23 Attributes Tor LISU BOX siii dd AAA AA RARA QA AERE DU EK AAA 32 2 24 Test Showing Drop Down vs List BOX i iossssus ouo caian rhuRRuEERREAEREESESEERERRERRRRAEFARRESERERSERREFERERERR ERES 33 229 Parameter TOF TO date iia AAA AAA 34 2 26 Select Statement for Multi Column BOX 11111001100000000000000r0riririnininizinizinizinizizininiaiani zizzania nana 35 2 27 Select Statement for Multi Column BOX 5 5 5 s2s2 5252s252s252 36 2 28 Select Statement for Multi Column BOX x 00v0i a 37 2 49 Add SSBSECT CRSE NUME ciccia 38 2 30 AGGING CODGIDI OS i
56. Argos will actually save in the database This is all XML and typically is used only to debug problems The last icon the pacifier is used to go into the Advance Query Builder mode Clicking on the Icon will take you to a blank form PurchaseOrder Bol ca cages ve mec SET Form Design Free Type Refresh Fields EE Field Security h x gt gt gt like or and not is mull Edit ADO properties Fig 4 7 Advance Query Builder Form Page 75 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 On the right hand side you can paste in an existing SQL statement or create a new SQL statement from scratch Once the Query is pasted or created click on the Refresh Field icon Le Refresh Fields located at the top of the left side of the form This will execute the query and when done the fields in the query will be listed on the left side of the form PurchaseOrder BITES Active Connection DEVL a Form Design Free Type Refresh Fields ES Field Security PO Number select FIMSMGR FPBPOHD FPBPOHD CODE PO Number 31 AG FIMSMGR FPBPOHD FPBPOHD ACTIVITY DATE ActivityDate PO Date FIMSMGR FPBPOHD FPBPOHD USER ID User Transaction Date FIMSMGR FPBPOHD FPBPOHD PO DATE PO Date Closed FIMSMGR FPBPOHD FPBPOHD TRANS DATE Transaction
57. CTIVITY DATE ActivityDate FPRPODT FPRPODT UNIT PRICE FPRPODT FPRPODT QTY 10 CalcDiscount StartDate StartDate EndDate EndDate FPBPOHD FPBPOHD PO DATE PO Date FPBPOHD FPBPOHD TRANS DATE Transaction Date NVL FPBPOHD CLOSED IND N Closed NVL FPBPOHD COMPLETE IND N Complete FPBPOHD FPBPOHD PO PRINTED DATE Print Date FPBPOHD FPBPOHD BUYR CODE BuyerCode FIVBUYR FTVBUYR NAME BuyerName FPBPOHD FPBPOHD COAS CODE COAS f get finance desc FTVCOAS FPBPOHD COAS CODE NULL 30 COASDesc SUBSTR f get finance status FTVCOAS FPBPOHD COAS CODE NULL 1 1 COAS Status FPBPOHD FPBPOHD SHIP CODE Shipping Code FPRPODT FPRPODT ITEM ItemNumber FPRPODT FPRPODT COMM CODE CommCode NVL FPRPODT COMM DESC FTVCOMM DESC CommodityDescription FPRPODT FPRPODT UOMS CODE UOMS FPRPODT FPRPODT UNIT PRICE UnitPrice FPRPODT FPRPODT QTY QTY FIMSMGR FPRPODT FPRPODT UNIT PRICE FIMSMGR FPRPODT FPRPODT QTY Amount FPRPODT FPRPODT DISC AMT Discount FPRPODT FPRPODT TAX AMT Tax FPRPODT FPRPODT ADDL CHRG AMT AdditionalCharge SPRIDEN SPRIDEN LAST NAME VendorLastName SPRIDEN SPRIDEN FIRST NAME VendorFirstName SPRIDEN SPRIDEN ID VendorID Page 64 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATgos Conditional Statement Getting Started Guide Last Updated 06 13 2006 At this time we have created the first part of
58. D S Pick one of the following choices ra FPRPODT COMM DESC Char 8 FPRPODT LlOMS CODE Char E amp User amp User DbMame amp User Description User Email amp ddress User Mame ConvertDates ConvertDates CONVENDDATE ConvertDates CONVSTARTDATE EndDate Getvendor Gett endor FTYVEND_PIDM Getvendor Mame StartDate Cancel Fig 3 17 Display Variables Page 63 Getting Started Guide Last Updated 06 13 2006 There are times you need to add values that were entered in on the parameter form For example in our report we might want to display the date range selected by the user Thus we need the values for StartDate and EndDate First add a Calculated field and expand the field property button By clicking on the abc li icon a list of any variable created on the parameter form will be displayed To add any listed variable that were created on the Parameter Design form click the abc icon and select the desired variable Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 We continue adding columns and defining fields until all desired data is added Remembering the end user make sure to also add descriptions The final select part of our statement should be something like the following select FPBPOHD FPBPOHD CODE PO Number FPBPOHD FPBPOHD A
59. DES This will allow us to narrow the listed courses to not only those offered for the term selected but by subject as well Several things to note in the above SQL statement First the second variable Description is using an Oracle Function concatenation as well as a Banner Function f student get desc Argos allows the developer or designer to use any database specific function that they have Oracle permission to use Also note in the where clause the variable SelTerm CODE This is the variable from the drop down box Argos is smart enough to not execute this query until it has a value for the SelTerm Code Choose Pick one of the following choices When creating a query to see what variables are available and quickly add the variable to the query click on the abc icon Ve and all variables that have been defined will be listed Select the desired variable and note that it will be added to the query with the colon preceeding it SUser DbName SLIser Description SUser EmailAddress User Name Using the AS clause allows the developer to create alias for the PK data returned Remember it is this value used in the AS SelTerm CODE clause or the alias that the end user will see when the results SelTerm TERM are displayed I Fig 2 20 BH uu of defined CK variables Page 30 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support
60. E FPBPOHD ACTIVITY DATE Type string date time As PO Number ActivityDate Description Purchase Order Number Fig 3 12 Adding Calculated Field Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY x e c 2t e c t Table FPBPOHD calculated R Field FPBPOHD_CODE Type string As PO Number Description Purchase Order Number e c t FPBPOHD FPBPOHD ACTIVITY D datejtime ActivityDate SQL Editor f get finance desc FTVCOAS FPBPOHD_COAS CODE NULL 30 Edit ADO properties lt gt lt gt lt gt like or and not is nul Fig 3 13 SQL Statement for Sample Calculated Field Page 61 Getting Started Guide Last Updated 06 13 2006 There also is a second method of adding a data field to a query First position your cursor on the Table row on the Visible Fields SELECT grid Note that a drop down arrow now appears Click on the arrow and all the tables selected will be displayed Select the table containing the field you want to include in the query Here we selected the table FPBPOHD Next repeat on the Field row of the grid Note that the columns or fields for the selected table are displayed Select the field The field FPBPOHD ACTIVITY DATE was selected in this case In addition to selecting a column from an existing table there are times that you might want to reformat the data or use other SQL functions concatenate substr DECODE or a PL
61. FPRPODT ITEM Select the Ordering ORDER BY Sort Ascending Ascending bul tab and add the proper order by fields This is similar to adding the Conditional in that you select the table and the appropriate columns Once selected you then tell Argos if the sort should be Ascending or Descending Fig 3 24 ORDER BY Clause We are done We now have a useable query that will allow end users to run reports that will show all Purchase Orders for a selected vendor We could easily add other conditions such as display only open PO s Make sure to frequently commit save while working Also make sure to document by creating notes and using short and long descriptions On the Parameter Design form make sure to provide clear prompts for the end user Security Field Level Security on a report can be done at the report level i e access to who can execute a report based on the group or the user However there are times it is desirable to allow someone to excute a report but limit the fields that they can see For example we might want only certain users to see employee annual salary Return to the Visible Field SELECT window to set field level security i ay a Above each field there is a set of aot 3 icons tools The two arrows are used to rearrange the order the Fig 3 25 Icons above Query Data Fields fields will be displayed The delete icon will remove the field from the selection Page 67 Evisions
62. Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig 1 1 Argos Launched from Web 5 1 2 Security Warning for Client DOWn1O G ccccccccccccecceceeeececeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeneeeeeenssssnnnennenennen 6 LS LOGIN TOON ii A AAA dalai iis alari 6 1 4 LOGIN Screeh iaia 7 1 5 Explorer Tree and Detail cnica EA AR OR ER n RH AAA 7 1 6 Sample Explorer Tree Expanded avoir 8 L7 Folder ODLIODS iod ORO AAA KORG RIO nC ROG Rr lui RE A RR RF I n QR ER 10 LS DataBIoCcK ODORS ii AAA 11 2 1 Adding a QuickView DataBlOCK orani ais pun uSsueuskausssusa AR RERERER RRERSERRSRRARES AAA ARA AAA EA AAA 12 2 2 Associate Connection Pool 13 2 3 Adding a Description to DataBIOCK xvi iii 13 2 4 AGGING Notes to DataBIOCK ooeussssuensusznsSuusssEEEEEERRRERSEUEESEREREEENERENEEEEMWAERERKEROF C EVE SEERERESERKRERKRFERSKU PNEU 14 2 5 Sample QuickView Parameter DataBloCk 11110000000000000000 0000 vci iiiii zizi iii iii iii nie 14 2 6 Edit DataBIOCK ssxsissssiixbik a ar ORO RR aan 15 2 7 Blank Forni Design aaa leale 16 2 8 Parameter Tool Bar iva 17 2 9 AGG an IMA risa A Aa 20 2 93 Image properties ica AAA AAA AAA AAA AAA AAA ECCE RC AAA EA REEF ETE RE 21 2 10 Adding Text to Parameter FOFIDU corria
63. Fig 2 4 Adding Notes to DataBlock the specific function definition in the notes area Adding Parameters gerbei Some reports or DataBlocks can be B amean entirely created from the Sa a Parameter Design window All Came TE QuickView DataBlocks are created paia using the Parameter Design form M oa only The end user will make o Mn selections until the data they want X is displayed X4 we di He X woe n M dii ne dla This example demonstrates how you can pull up available sections a for a subject by first selecting the Fig 2 5 Sample QuickView Parameter DataBlock Term Code then the Subj Page 14 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 The above is an example of a QuickView report This DataBlock answers the question What courses are offered for the selected term and department In the DataBlock we will be creating we are asking the question For a selected term what CRNS are offered and for that CRN what students are registered for that CRN We will first need to provide a user a list of all the terms After the user selects a term then display the CRNs that are offered for the selected term The following should only be used as a training sample We will be creating several variations of the sa
64. Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 o To limit access to a particular field Choosegrouporuser MIAR click on the key Fa icon above the il ropa A field or column Then press the Add 4g Everyone button A list of all users and groups 4 Payrol will be displayed ET StudentAdmissions y StudentRegistrar RAI Select the user or group and select carends Remove the Allow or Deny radio button EHOS amp ehoswald Here we are denying the user joe the access to see a particular field evisions jaoswald Field Security Groups and users Fig 3 26 Adding Field Column Level Security Fig 3 27 Adding User to Field Level Security gt Edit Fields ER Security can also be added by ET Groups and users a CUS Omer Goti sar clicking on the set of keys to 1 1 the left of the visible field list By OrderNumbe using these the developer can dai review what field level security has InvoiceDate its been set and add delete or modify ane ata NE security on multiple fields ProductPrice PraduckMumber ProductDescription Qty TotalPrice Salesman Fig 3 28 Review Field Level security Page 68 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide
65. L jus FIRC ADC gt y z BBpopnT CHANGE SI EE FIRCADT 3 Edit Join DT ACTIVITY EE FIRCERC 4 oT LISER ID a FIRCERD 5 Left Table dale Right Table FPRPODT v QT ITEM o e FIRCUDE DT COMM Col nod Left Field FPBROHD CODE w Right Field FPRPODT POHD CO br comm Des Tinas PNE f FIRCUSC 8 Inner Join RSS E SE FIRCULIC q Include all records from FPEPOHD and FPRPODT where FPBPOHD cope PT_UNIT_PRIC equals FPRPODT POHD CODE NT LIC AMT DT QTY CT ATT ET pu FIRCULIN EE FIRDSDC EE FIRDSDT pe FIRISUM he FIRMIMEC EE FIRMMET EE FIRPARM e FIRPFIF pe FIRPRTE EE FIRPRTY EE FIRRIPC 2 FIRSPMD pe FIRSTCC EE FIRSTCK EE FIRSTOC 2 FIRSTOP pe FIRTLTC BR FIRTOTC ii EE FIVCASH ji FIVCUDY CO Outer Left Join Include all records From FPEROHD and only those records From FPRPODT where FPBPOHD CODE equals FPRPODT POHD CODE C3 Outer Right Join Include all records From FPRPODT and only those records from FPBPOHD where FPBPOHD CODE equals FPRPODT POHD CODE visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Fig 3 9 Edit Joins By default an Inner Join will be created To edit the properties of the join right click or double click on the join line Argos supports Outer right and Outer left joins Page 57 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fa
66. L CHRG AMT FPBPOHD FPBPOHD APPR IND FPBPOHD FPBPOHD ATTENTION TO FPBPOHD FPBPOHD ATYP CODE FPBPOHD FPBPOHD ATYP SEQ NUM FPBPOHD FPBPOHD BLAMKET CODE FPBPOHD FPBPOHD BLAMKET IND FPBPOHD FPBPOHD BLAMKET TERM DATE FPBPOHD FPBPOHD BUYR_ CODE FPBPOHD FPBPOHD CANCEL DATE FPBPOHD FPBPOHD CANCEL IND FPBPOHD FPBPOHD CARRIER PIDM Cancel Fig 3 16 Display Variables Page 62 Getting Started Guide Last Updated 06 13 2006 Finally because this is a calculated field it is important that we create both an alias and a long description This will allow the end user to quickly identify the values in this field Using a long description the developer can clearly explain what is contained in the column Note that by default Argos will automatically add an alias for calculated fields starting with CALC1 When adding a caculated field there are several tools on the SQL Editor form that make it easier to create the function The developer can quickly add arithmetic and logical functions Here we are calculating a discount on 10 percent When creating the above statements you can display a complete list of fields from the selected tables click on the icon A list of the qualified columns table and column name will be displayed Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support e e ODE ODE IM VEND CODE GENT_IND M OFF IM
67. N Char BANINST Edit Join 5 Char BANSECE Numeric gs BWAMGE Left Table FPRPODT Right Table FTVCOMM v Numeric E E BWFMMGF e ve Numeric E Ewa Left Field FPRPODT COMM CC Right Field FTVCOMM CODE Le Js E BWLMGR Inner Join id E EWPIMGE Include all records from FPRPODT and FTVCOMM where Numeric E ASE FPRPODT COMM CODE equals FTvicOMM CODE Numeric Numeric Criss m E E E E E E E E E E E H FPBFOHD 6 Outer Left Join Include all records from FPRPODT and only those records From FTYCOMM Es EHOS Met E Ga 2 x where FPRPODT_COMM_CODE equals FTYCOMM_CODE Fabian 2 Outer Right Join FIMS ARC Y FIMSMGR FT YBUYR FT Include all records from FTVCOMM and only those records From FPRPODT Fiam gp where FPRPODT_COMM_CODE equals FTYCOMM_CODE GENERA Tall HR Y FTVBLIYR fa Char ICMGR FTVBLIYR ai DBTime Moss FTVBLIR DBTime MLSUSEF FTVBLITR ACTIVITY DATE DBTime FTvcComm LISER ID Char EE FTVBLIYR LISER ID Char FTVCOMM DESC Char EDS FTVBLIYR NAME Char 1 FTVCOMM LIoMS CODE Char OLITLN FTVBLIYR PHORIE AREA Char FTvCORMM TERM DATE DBTime PAYROLL FTVBLIVR PHONE NUMBER Char FTYCOMM_ COMM CODE P Char POSNETI FTYBLMA PHOME EXT Char FTvCOMM AMST IMD Char PRINLISE FTVBUYR LYPO IND Char FTVlOMM_ TGRP_CODE Char ili ES SATURN ATT gt El E EE Type EE El Fe Ee El Re RR El E Ra O p c IN E LI D e e F
68. N SGBSTDN MAJR CODE MIMR 1 SGBSTDN SGBSTDN MAJR CODE MIMR 1 2 SGBSTDN SGBSTDN MAJR CODE MINR 2 SGBSTDN SGESTDN MAJR CODE MINA 2 2 SGESTDN SGESTON_ORSM_CODE SGBSTDN SGBSTDN_PIDM SGBSTDN SGBSTDN PRAC CODE AGRASTAALSARSTARA PRTR Roli TRIS SGN GetSGBSTDNterm A Name TERM CODE a SGBSTDN_TERM_CODE_EFF _CRN _PIDM _CATEGORY PERCENT RESP WORKLOAD ADJ PERCENT SESS Y gt lisible Fields SELECT Conditional Fields WHERE Ordering ORDER BY and lt y gt and pao and lt query gt lt root gt Sub Query GetSGBSTDNterm query OExISTS QONorEXISTS OIN NOTIN Query Field A SGBSTDN TERM COD Table SGBSTDN Field SGBSTDN TERM CODE MU Fig 4 6 Sub Query Added to Conditional O lt O G O Getting Started Guide Last Updated 06 13 2006 E a Add the conditions to make sure the SGBSTDN matches the pidm i the SGBSTDN in the main query To do this on the conditional field select the A SGBSTDN PIDM as the field Then open up the condition tabl To display all the tables in the query press the Display Table icon This displays all the tables including the ones from the main query Select the SGBSTDN PIDM field We also want to add the condition where A SGBSTDN TERM CODE EFF lt TERM TERM Which is coming from the parameter form The final step is to add the results of the sub query into the conditional Click on the Add SubQuery to Condition icon
69. Price PO Number Full iarme Buyer Code Buyer Mame Getting Started Guide Last Updated 06 13 2006 Click close to save the Expression Builder You will then be prompted to assign a name to this new field When complete the new field will be listed Note that it is identified with the Equation Builder Icon To edit this field use the Edit Equation Builder icon E Continue to add the fields you want in the report Note the order of the fields can be changed by selecting the field and right clicking Quantity l MendorID mount Discount Amount Tax_ mount Additional Charge VendorLastName VendorFirstMame YendorEntity VenderID v write column header 5755575 Fig 5 12 Re arranging Fields When all the fields have been added click Finish As with the QuickView report you can make this a puplic all users with proper permissions can execute or private Make sure to give the report a name and a description To run the user will click Execute After making choices on the parameter form they will then be given an opportunity to save the data to a file or save and launch If they choose the later the data will be displayed in Excel Page 84 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATgos Banded Report Getting Started Guide Last Updated 06 13 2006 The last type of report the developer can add is referred to
70. SSRMEET SSRMEET BLDG CODE as Bldg I SSRMEET SSRMEET ROOM CODE as Room Mei DECODE TO CHAR TO DATE SSRMEET BEGIN TIME HH24 MI te t d n displayed a We Wa nt to pick up some TO CHAR TO DATE SSRMEET BEGIN TIME HH24 MI P i NVL SSRMEET SUN DAY SSRMEET MON DAY SSRMEET TUE DAY iiis nfo rmation from the SS RM E ET ta ble The NVL TO CHAR SSRMEET START DATE MM DD TBA as St NVL TO CHAR SSRMEET END DATE MM DD TBA as EndD J an Graff nr Y Tn man ce Tee e end query will read as follows gt A Edit ADO properties 2222 2552322 lt gt lt gt lt gt like or and not is nul f STE REATI AT T AT Close MAI RA AAT D E EAT m v Fig 2 39 Adding a New SQL Variable Page 46 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support p Ca Variable Name Descriptior E user Settings ri MultiColumn SelCRN SelSubject Sample us amp f SelTerm Term code i SQL A Ctrl A Edit Variable Rename Variable inal S Change Description 2 Delete Variable Fig 2 40 renaming variable Getting Started Guide Last Updated 06 13 2006 When complete we will want to rename the SQLVariable We do this by right clicking on the new SQL Variable and selecting Rename Variable We will call the Variable GetCrseInfo Expand
71. TDN PIDM SFRSTCR PIDM AND SGBSTDN TERM CODE EFF lt SelTerm CODE AND SPRIDEN PIDM SFRSTCR PIDM AND SPRIDEN CHANGE IND IS NULL AND SFRSTCR TERM CODE SelTerm CODE AND SFRSTCR CRN SelCRN CRN AND SFRSTCR ERROR FLAG NOT IN F D OR SFRSTCR ERROR FLAG IS NULL OR SFRSTCR RSTS CODE IN SELECT STVRSTS CODE FROM STVRSTS WHERE STVRSTS CODE SFRSTCR RSTS CODE AND STVRSTS GRADABLE IND Y AND SPBPERS PIDM SFRSTCR PIDM AND STVETHN CODE SPBPERS ETHN CODE ORDER BY SPRIDEN LAST NAME SPRIDEN FIRST NAME Page 44 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 Let s review what we have so far Select Term Fall 1995 vi Select Subject ANTH Anthropology BIOL Biology BUAD Business Administration CHEM Chemistry CHSM Core Humanities Seminar ECON Economics ELET Electronic Engineering Tech ENGL English m Select CRN COURSE SECTION CRN 2310 001 10005 2340 001 10006 2430 001 10007 PIDM FullName StudentID Major Level RSTS CreditHR EthnicCode EthnicDesc Gender 67 Abbe Anth 210009506 ACCT UG RE 3 1 Caucasian M 66 Graber Cyn 210009505 ACCT UG RE 3 1 Caucasian F 133 Scott Drew 610009506 ACCT UG RE 3 2 African Am M 132 Wiggin Kate 610009505 ACCT UG RE 3 2 African Am F Retrieve a maximum 5 record s Fig 2
72. Training SE E EINE publish de Cut Copy Edit DataBlock Rename Add to QuickLaunch Corlts Ctrl C Delete B Export B Security Collapse All Fig 5 1 Adding New Report to a QuickView DataBlock Sel Edit Report Choose the type of report that Argos should generate Choose the type af report that Argos should generate Displays the parameter entry form configured by the creator of the SmartObject Mo query is executed even if one exists for the object po Quick View parameter entry only Fig 5 2 Select Type of Report Page 78 Getting Started Guide Last Updated 06 13 2006 Select the QuickView Datablock for which you want to add a new report right click then select New Report from the menu An optional method is to again select the DataBlock and press the New Report button The next form gives you an opportunity to select the type of report to generate At this time since this is a QuickView datablock the the only option available is to create a QuickView report If you were to edit the DataBlock you would see that there is no query and that all the data is being retrived by the options or paramters selected by the end user Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Edit Report Name this report provide a short description and set other security features Report Name
73. _ TRIPS bz 1 AAA FIRDSDC renna un iin pea Ax FIRMMKC FIRMMKT FIRPARM FIRPFIF FIRPRTC FIRPRTY FIRRIPC FIRSPND FIRSTCC FIRSTCK FIRSTOC FIRSTOP FIRTLTC FIRTOTC FIVCASH FIVCUDV ere d co Ja Na OQ N Ee g Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY _ Fig 3 8 Generated Join When the table is brough in Argos is looking at the Meta Layer to determine if any joins exist If one exist it will be added immediately However manually adding a join is staight forward To create a Join merely select the field from one table and while holding down the mouse key draw a line to the field in the second table that you wish to join Here we want to connect our two tables based on the Purchase order number which is held in the fpbpohd_code column for the fpbpohd table and fprpodt pohd code field in the detail table Page 56 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 PurchaseOrder Form Design Query Design f Hide Tables Add Table Sub Query SQL Format Oracle A IN FIMSMGR FPBPOHD FPRPOHD FIMSMGR FPRPODT FPRPODT BE FIRBDIS SA 2 Be s Index Mame Index Mame EE FIRBONC all Al Tall ES FIRBOND y FPBPOHD CODE Char Y FPRPODT POHB CO
74. ackground and 4 allow the user to add a background to the parameter window If the parameters will not fit on one screen the second icon will add scroll bars Using a background other objects on the background can be treated as a group The background becomes the parent and the objects placed on the background will be considered the child For example in the following sample a background was added Like other objects certain attributes can be set For example in the following we set the color of the background object and set the parent font to be used for any text object we will add Note that the Parent of this background is the main parameter form Any object any to this background will be a child of this background show objects Active Connection 4 DEVL v A a Form Design Query Design Parameters e l A i tea Ba C kg ro u n d aX AN reas Sh sj 2 1 4 Col Panel olor Align None Color clSkyBlue Font Font FontBold No Font Color clWindowT ext Fo n t Font ltalics No A FontName Tahoma S ett l n g Font Size 8 Font Underline No Height 282 Sm Left 117 Ey Parent Color No Fp Verdana Parent Font No i n Order 3 CLON Width Bold Italics Underline ABCabcXYZxyz 01234567 CAS Fig A 1 Setting properties for background Page 91 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support
75. aia AAA AAA AAA AAA 55 3 7 Choose table OF SVIODVI seis o o mc nai 55 Page 98 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig Fig 3 0 Generated J01N i aaa 56 3 9 Edif JONS eat AAA AAA AAA AAA EE ER ERR 57 G7 credting outer jolie a 58 37 Review SOLE Slemen cisma iS AA AAA FR MEE 59 3 8 Cominit MOGHICAUIONS sin mccain 59 3 9 Addilig Fields DV CHOKING ii AAA AAA AA AAA AAA iaia 60 3 10 Adding Field Manually Selecting Table 2 n diii ss suu uuuuuuuuuuuuuuu uu RR RRRRSRRRRREEEESEERERRRERRRRRE 61 3 11 Select Field Manually Selecting Column 2 n nsns uuu uauuuuuu uuu RR RR iii iii iii iii iii iii iii iii iii 61 3 12 Adding Calculated Field ir 61 3 13 SQL Statement for Sample Calculated Field 2 22 eee rana 61 3 14 Adding Description for Calculated Field 2 aoro oooeeee eee uuuuuuuuuuuuuuuuuuuuRREEERRRRRSRRRRR nani 62 3 15 Adding Calc Field using Built in Arg
76. ame Tvpe RASOI o M mE We ll add the table SGBSTDN 2 SGESTDN_TERM_CODE_EFF Char N_TERM_CODE 3 SGBSTDN_STST_CODE Char a LN P di a Another feature of Argos is the ability N CATEGORY nau le s arn to add an alias for the table as well as SGBSTDM TERM CODE AD SGB x Char cce Table columns To adda table alias click on the Edit Properties Icon 2 EE and fill Vsble Fields SELECT Table Name SATURN SGRSTDN in an alias In this example we are i re naming the table A 3 iN WORKLOAD ADJ iN PERCENT SESS Y B lt Visible Fields SELECT Condit Table Field il i ji Table SPRIDEN d i H amp Field SPRIDEN Description Type zunknown Gummi As PIDM pus Description To add a new visible Field double click or drag a field to this area from one of the added tables in the Query Designer Fig 4 4 Create a Sub Query Page 71 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support GetSGBSTDNterm Show Tables Add Table Sub Query SOL Format Oracle A SATURN SGESTDN A Index Mame Tvpe all SGBSTDM PIDM Plurmneric SGBSTDM TERM CODE EFF Char SGBSTDM STST CODE Char SGESTDN_LEWL_CODE Char SGESTON_STYP_CODE Char SGBSTDM TERM CODE MA Char SGBSTDM TERM CODE AD Char SGBSTDM EXP GRAD DATE DBTimeStamp CALTON CARD Frame har HAA XX co w
77. ast Updated 06 13 2006 Click on the Green Plus to add a new server Type in the name of the server If you are logging into MAP Server from the system where the MAP Server is installed you will need to use localhost as the system to connect to If you are logging into MAP Server from a remote system you will need to put the system name or IP address of the system running the MAP Server Click OK to continue You will also need to add the entry to the Server Address line The initial screen is referred to as the Argos Desktop and is comprised of the Explorer Tree on the left and Explorer Detail on the right In addition to the Explore tab there is a Quick Launch tab where end users can store shortcuts to the reports they most frequently run Use of this tab is discussed in the End User Manual The tree is divided into Folders u DataBlocks and Reports Folders are used to organize your work When you are logged in you can see the folders for which you have been given permission Security can be set to limit who has access to which folders This is discussed in more detail in the MAPS Installation and Administrator Guide Folders can be named anything A next to an item indicates this object contains other items Page 7 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 20
78. co E ually or populated by a SQL statement Choo ER NT then open 2 Manual entries O SQL statement Entries can be of two types Manual entries where the designer manually adds entries to the Drop Down Box or a SQL statement where the data is retrieved via a Fig 2 11 Drop Down Box SQL query Editing a manual entry parameter is straightforward By clicking on the green on the horizontal top Choice Entry irs as many columns as necessary which will contain supporting information for each available CE Delete Column Edit Column bar you can add columns The on the Vertical side bar will add FOWS The designer will place the values that they want to be displayed to the user In this simple example the user would be shown the Month Once selected the the OrdinalValue will be available for use in subsequent queries Fig 2 12 Manually Enter Values Page 24 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support This is the SQL statement that will retrieve the choices fq lt the end user Each SELECT field will become a sub variable The associated visual design will not refl st any changes made here SELECT STVTERM CODE AS CODE SIVIERM DESC AS TERM FROM STVIEEH ORDER BY STVIERM CODE DESC I e e gt like or and not is null Fig 2 13 Sample SQL Statement for Dro
79. d Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support When complete the query should look like the following Getting Started Guide Argos Last Updated 06 13 2006 Choice Entry This is the SQL statement that will retrieve the choices for the end user Each SELECT field will become a sub variable The associated visual design will not reflect any changes made here SSBSECT SSBSECT CRSE NUMB COURSE S3SBSECT SSBSECT SEQ NUMB SECTION SSBSECT SSBSECT CRN CRN SATURN SSBSECT SSBSECT SSBSECT SSBSECT TERM CODE SelTerm CODE and SSBSECT SSBSECT SUBJ CODE Selsubject subject by SSBSECT SSB5ECT CRM Ho B St A gt like or and not is nul evi Fig 2 31 completed query Click Next to review the results Again you will be prompted for values for the term and subject On the data review form there is new button that allows you to modify the properties of the column To modify the column click in the column and press the edit Display Caption po pO v Visible Width Alignment Fig 2 32 edit column properties Page 40 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support CRNRoster QV Commit Changes Active Connection DEVL Y a Form Design Query Design 2 selected controls S5 di y Jaw qd lign IN one Parameters Variables 4 x A
80. d for selected vendor We want the item product number product description order status payment terms etc In other words any information about a placed order should be available In addition we want to be able to print off mailing for our vendors From this one Report DataBlock many different reports will be run We will discuss creating these reports in Chapter 5 Page 50 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Purchase rder Form Design Query Design Parameters Variables ListBox Align None Auto Select Mo Choices Choices Description Height bE Left a2 MultiSelect Yes Required Yes TabUrder fH WY op de VariableName ListBox Width 1205 Getting Started Guide Last Updated 06 13 2006 BE Commit Changes Active Connection DEVL aA TEATER ERA Ta iie Iga jh E pl Choice Entry This is the SQL statement that will retrieve the choices for the end user Each SELECT field will become a sub variable The associated visual design will not reflect any changes made here select FTVVEND FTVVEND PIDM SPRIDEN SPRIDEN LAST NAME SPRIDEN SPRIDEN F from SPRIDEN FIVVEND where SPRIDEN SPRIDEN PIDM FTVVEND FTVVEND PIDM and SPRIDEN SPRIDEN CHANGE IND IS NULL and SPRIDEN SPRIDEN LAST NAME IS NOT NULL order by 2 at Edit ADO properties A lt
81. dated 06 13 2006 We want To display all the tables in the scheme that you have access to click the Show Tables Show Tables button PurchaseOrder Commit Changes Active Connection DEVL Ww C peu iil A list of all the tables th ist of all the tables the developer has access to will be m eG DEA i displayed Tables by default will E Tables EXCEPTIONS gt be shown by Schema All the tables we are working with are ini 3 owned by the user FIMSMGR By Pee ec expanding the schema FIMSMGR PT T T IB jaa you will see the objects sorted by F Add Table s F Refresh ES F ES F FAB REBT FABRUIY FARBKTH FARCKMC FARDIRD FARINTX type This display can be changed Play around with the Object Organizer bar Sela SN Ga to see how the objects can be sorted and grouped For example for organizing a large amount of objects you can group by the first letter A I e Fig 3 4 Adding Tables via List BE To add a table locate the table in the list and double click This will pull the table definition to the right hand side of the screen You can either scroll or start Commit Changes Active Connection DEVL Form Design Query Design Y Ba Tables Be tab a FOTRPRG FOTTEXT Hide Tables Add Table Sub Query SQL Index Name FPBAGRH FPBBIDH FPBBIDS
82. dd Table Button ic l Adc Table Don the top tool bar and add the table SSBSECT Click OK to continue Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY x Table Field To add a new visible field double click or drag a field to this area from one of the added tables in the Query Designer Close Fig 2 27 Select Statement for Multi Column Box Page 36 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support BE Choose Table Multiple tables exist that resemble SSBSECT Choose the table that best represents the one you are trying to add Name Catalog Schema Type Description SSBSECT SATURN TABLE SYNONYM Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Table Field To add a new visible field double click or drag a field to this area from one of the added tables in the Query Designer Description Close Fig 2 28 Select Statement for Multi Column Box Page 37 Getting Started Guide Last Updated 06 13 2006 The next form ask if you want to pull in the Table definition or the Synonym There are a few times that the synonym is not pointing to the table with the same name so if you use the synonym make sure that it indeed is pointing to the correct table or object We will select the synoym Press OK to continue Evisions Inc e 14522 Myford Rd e
83. ds to be met To display all available variables click on the k icon on the bottom of the editor Then double click on the varable In this example we manually typed the equal sign and select the variable CUSTOMER ID from the drop down list CUSTOMER ID is the variable we created on the parameter form Note that by default the equal sign is assumed and we really did not need to enter However any other relationship then equal would need to be typed For those of you who do not need the GUI aid for adding a WHERE clause Argos provides expert mode At the bottom left hand corner of the WHERE clause there is an icon that looks like this l an edit form On the edit form the developer can manually type the complete WHERE clause Clicking it opens Note that you can use either the point and click method or manually enter the statement Use either method but not a combination Note that we have added all the conditions desired Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 Order By Finally to present the data in some T readable sequence we want to add a Visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY an order by We will order the return Sox oo values by Customer ID and then by Table FPEPOHD FPRPODT Order Number Field FPBPOHD CODE
84. e of UNION you want to add Query Design Para Show Tables Add Table sub Query SQL Format Unknown Fig 4 1 Show Unions Query Design Parameter Design Unions 0o OO Main Query Fig 4 2 Type of Unions Page 69 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Argos Getting Started Guide Last Updated 06 13 2006 This is the standard union that combines the results of the two queries into one result Duplicate records are excluded Use this for a UNION ALL which combines the results of two queries into one Duplicate records are not removed This is for an INTERSECT union which returns only those records that exisit in both queries Q Use this icon for a MINUS union This removes records that exisit in both queries visible Fields SELECT Conditional Fields WHERE Ordering ORDER BY Y e c 5 5 e3 c5 5 2 e c 5 54 e c Xx Table lt calculated gt calculate PHONE lt calculated gt PHONE_TYPE_S NULL lt e Field NULL NULL ONENUM_S Fig 4 3 Adding a Union We are going to use a UNION ALL so we will click on the icon You create the underlying query as before adding the tables and columns Argos does not check to make sure you have added the correct number of columns or that the datatypes of the columns added are the same That is the responsibility of
85. erature and products Welcome to Argos Enjoy Document Overview This document is NOT intended to be a complete user guide but rather to provide the Argos developer or designer the skills required to create their first DataBlocks in Argos This DataBlock can then be used by end users of Argos to access information and generate reports in varying ways For the purposes of this guide it is assumed that the software has been fully installed and configured i e ADO connections and users have been added If any problems arise in following the examples in this guide please contact our support staff for assistance This can be done by submitting a support request to http helpdesk evisions com or you may choose to first visit our knowledgebase at http www evisions com suport In addition to this manual there are additional manuals and multimedia tutorials for the Administrators and End Users Intended Audience This guide is intended for the Argos developer and assumes that the reader is familiar with writing SQL Structure Query Language statements The samples in this document are written using SQL designed for Oracle Every attempt is made to keep the queries generic enough so they can be transported across platforms Although ANSI standards do exist these standards remain theoretical and differ significantly from implementation to implementation This is NOT a SQL tutorial Sample Database All samples used in this guide
86. ery will be set to the FIRST row or value returned By setting Required to Yes and Auto Select to No the designer will force the user to make a selection s from the values displayed Page 32 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATg0s Select Term Fall 1995 v ED Down Box ACCT Accountir ANTH Anthropc gt I BIOL Biology 4 List Box BUAD Business CHEM Chemistr CHSM Core Hur ECON Economic ELET Electronic ENGL English e Retrieve a maximum 3500 record s Fig 2 24 Test Showing Drop Down vs List Box Page 33 Getting Started Guide Last Updated 06 13 2006 Lets review what we have so far Click on the Test Icon Because we are using the selection for the Select Term box to display the Subjects nothing will be displayed in the Subject box until we select a term Note because of the number of values displayed a scroll bar was automatically added to the List box Note that the user must select from the returned values Several things to note here the List Box is not wide enough to display all the data and the boxes are not aligned We also need to add a text box to prompt the user to Select the subject Press Close to return to the parameter form Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com supp
87. fields are based on security access how they want the columns to be ordered and add calculated fields When a Banded Fully Formatted report is chosen for the output method the designer of the report has the ability to setup report titles headers footers colors fonts and the report style The key to the query design is that the results of the query are only displayed on reports created by the developer And these reports are either a CSV or banded report Summary if there is NO query in the query design form then the ONLY type of report that can be created is a QuickView report Only when you add a query to the query design tab will the other two types of reports be available to build Page 9 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support ATgos Folder Options A Nos Evisions Inc File Edit View Tools Help fs Ea X ib id o Logout Back Cut Copy Delete Import Export Security Publish Site Support Explorer i i vor aim Alumni LJ amp x di Campaign Summary zi 4 Banner amp Major Year Rename A Folder amp DataBlock Cut Ctri xX PEZ Ba Copy Ctrl C Evis B Export 7 Evis Load our 1 Trai 14 TrainingSamples Collapse All Er Er Ec Er Er Er Er Er i_ UniData user ehos Fig 1 7 Folder Options Getting Started Guide Last Updated 06 13 2006 When a user right clicks on a
88. h security Edit the security settings for this DataBlock amp 1 Dev Team Home amp Evisions Training Un lm e amp Cut amp x Evisions University 7 InternalApplication Copy j our training today gA reports under the DataBlock Publish Publish this DataBlock to the Argos Publish server ciated Connection Pool DEVL v lor ArgosDevTeam amp TrainingSamples Delete 2 Created 8 25 2004 5 59 04 PM 9 e m j Last Modified 11 15 2005 10 21 18 AM i UniData a Export e a Security amp University TrainingExamples Collapse All user ehos Fig 1 8 DataBlock Options Page 11 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Argos 2 CREATING FIRST DATABLOCK Adding a QuickView DataBlock Argos Evisions Inc File Edit View Tools Help ta e Ba x amp Logout Back Cut Copy Delete Import Export Security Publish Site Support jFinance amp Budget Report QV amp Budget Report QV New x Dev Team Home 4 Budget Report QV Testing zi Evisions Training University A PurchaseOrder by Vendor query pu A PurchaseOrder by Vendor quickview Rename J AMA 9 amp Cut Ctiax sim 3 Vendor quickview il Copy Ctrl C a LJ y lasd E ia ul dn B Export t boss o a p T a Security T Delete LZ E LU Collapse All 2 e University user ehos
89. iable 2 The name used here should be unique This name is used as the qualifier Align None for all the values returned In our Auto Select Ma example the values Subject and Choices Choices Description are retuned in the SQL Description Sample using listbox lt 1 statement To use these variables niall ee in subsequent queries they should zal a be prefaced or qualified with the Mult Select No i 3 zue OS value entered in the Variable Name TabOrder 7 field i e SelSubject Subject Or Top 194 SelSubject Description V ariableM ame SelSubject Width 103 ListBox Fig 2 23 Attributes for List Box In addition you can allow the end user to select more then one value from the list displayed Notice the attribute that allows a multi selection 3 to be made If set to YES Argos will re write any subsequent SQL statements that use these variables That means you as the developer will not need to be concern if the where clause should be an equal or an in In addition to the description and variable name the other attributes the designer should take note of are Auto Select and Required The Required parameter allows the user to NOT select a value if set to No To force the user to make a selection set the Required to Yes Finally if you want a default value to be selected set Auto Select to Yes If set to Yes then by default the variables defined in the qu
90. iani iaia iii iii iii 76 5 1 Adding New Report to a QuickView DataBIoCk x11110011111000000000000 0000 riviera zine 78 5 2 Select Type of Repoft i nici a 78 5 3 EdIl DescHDe REDONDA 79 5 4 Adding Notes to REDOFL i vciciinii aa 79 5 5 CNOOSING d CONNCCUON ini A AA AA AAA AAA AA AAA AAA 80 5 6 Run and Save QUICK View RepDOLFrt viviietsesntensavcdectesesseensassdescnestdenserndieadewesdesseeends AAA AAA ARALAR AAA 80 5 7 Types of Report DataBlock Reports oocccccccccccccccccc nana 81 5 8 Select Columns to Appear in RePOFblloooocccccccccccccccccc nana 82 5 9 Avalable Bullt in FUNDCUION Sisi AAA AAA ARA AAA AAA 83 5 10 Adding Formatted FICIGS ci e AAA AAA AAA A AAA AAA AA ARANA AAA AAA 83 5 11 Finished Field Definiltlon x 84 5 12 Re arranging FICIGS ai A AAA AAA AAN AAA 84 5 13 Banded Report Definitions ADEIT 85 5 14 Select Dataset for Banded Report iiisissinsasasssaskyksAsyERARREuAERERESEEERARRESRERAAERARRRARRERARRRAEEEEREREKKRARRKKFKKSKERES 86 5 15 Select FICIOS ini 86 5 16 SOTOCEBIDAS aaa de ab EA 87 5 47 Repot ODUONS ia A e 87 5 18 Report Characteristics aC 88 9 19 Preview Report 88 5 20 MOUITVy REPOTI ossxesarkko ibirIDORO ERE Kc aco a ain OCC AAA 89 5 21 Preview Report akin Kan Oo OO EEE EEEE aaa OC lc 89 5 22 Saved as a Excel SDreadsheeBLb sons ivvarasa ew ipaa lire EX YERTERVEVERFESESREECERUSEESVUSUSFEEPEFUFVEYES ES RERFEREFFEERERFKE VE 90 A 1 Setting properties Tor DaCKgroUulnd
91. ig 3 7 creating outer join Similarly we need to join the buyer table using an outer join to the header fpbpohd table based on the fpbpohd buyr code matching the ftvbury code We want to include all the records from the header table and only records from the buyer table where there is a match Page 58 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 B rchase rdag Commit Changes Active Connection DEVL p QO EA IL Form Design Query Design Show Tables Show Tables Show Unions Add Table Add Table Sub Query sub query SQL Format Oracle A FPBPOHLD OME QE rmm im Mim TRL View SOL from SATURN SPRIDEN SPRIDEN FIMSMGR FPEPOHD FPBPOHD FIMSMGR FTYBUYR FIMSMGR FPRPODT FPRPODT FIMSHGR FTVBUYR FTVBUYR FTVCOMM where FPBPOHD FPBPOHD CODE FPRPODT FPRPODT POHD CODE and FPEBPOHD FPBPOHD BUYR CODE FTVBUYR FTVBUYR CODE and FPRPODT FPRPODT COMM CODE FTVCOMM FTVCOMM CODE and FPBPOHD FPBPOHD VEND PIDM SPRIDEN SPRIDEN PIDM ox s Index Mame Tall Y FTVBLI YE CODE FTYBUYR_EFF PTYBUWYR_TER FTVBLI YR ACTI FTVBLIYR LISER FTVBLIYR MATTB FTYBLNYR_PHO FTVBUYR_PHO FTVBUYR_PHO FTWwRIIVR 1 Pri ui oco HH mM E 0 OR f E si visible Fields SELECT Conditional i Table Field Type
92. iie cia xai nO AAA AAA AAA AAA AAA BEIGE GER 39 2 231 COImpDieted dGUeyaa cinica 40 2 92 edit colummn Propert S ia 40 2 33 Select Statement for Multi Column BOX 5 5 52 5 5252s2s525225252252252s5 41 2 34 Set Column Attributes for Multi Column BOX s ss 2 2 2 42 2 35 Test run with M ll Columns a aoa ci C CERO A AAA a a 42 2 20 LIST OP Variabili a 43 2 37 AGGING d SNAPS rina 44 2 230 Completed FOSLOF aui mmm 45 2 39 Adding a New SQL Variable A aaa 46 2 40 renaming Variables dran Or dora ooo ORG AAA AAA AAA AAA AAA GG aao ca 47 2AL SE SU DAV alla CS cca 47 2 42 Setting Data Aware ATTFIDUTO circa CEA IEA AAA AAA CORRER CROACIE ARRE 49 2 43 Final TOS Coi AAA AAA Aena 49 3 2 Customer Query for OFderFRepo circa ida AAA AAA AA AA AAA 51 3 2a adding date fields StartDate 21scccccnnnnnncnsccsncccccnnnnuessseeccnncnuccsonnussseeeccssencccssanuassseesesseeeesssnuues 52 3 2b adding date fields EndtDate s 2 25 5522 5 2255225s22 2225222522522222225222522222222222222222222222222222 52 3 3 access Query design form to write main query s s 5 5 s25252252s52252s522522522522522522522 2 53 3 3 access Query design form to write main query 11100000000 000 0000 GGG GGGGG Guia 53 3 9 Adding Tables via LIST iii ia aaa 54 3 5 Adding Table Definit loli A A EE 54 3 0 Adding Tables Man ally iiuisussauuau ass
93. ing Started Guide bs 205 Last Updated 06 13 2006 Parameter Tools Argos has several tools that allow the user to enter data directly or select the data from values returned from a SQL query or that have been manually entered The developer can also add different controls images or design elements Following is a very brief description of what is available and are used to select or delete the object ca tim EA met gi T H ca 2 d DI zm im F Lu gt Ua are tools that the developer can use to ensure objects are properly aligned and i allow the user to add a background to the parameter window If the parameters will not fit on one screen the second icon will add scroll bars M will be used to add static text to the parameter form In addition it can be used to display variables such as the user id of who is executing the report Gu allows the designer to add shapes to the parameter form ab Edit Box and Memo Box allows the user to manually enter a value An example might be to prompt the user to enter the ID of the customer e Allows the developer to add an image to the parameter form The drop down icon is used to add an object that will display one column of values From the items displayed the user will be able to select one value B The Boolean button is a True False button The developer can assign distinct values depending on if the box is checked or not al i Is similar to the drop do
94. l be automatically set to the correct term code if the user types a value in the Drop Down Boxes This is useful when it is likely that the end user knows the value to manually enter i e the user can manually enter a value or select from the returned values At any time you are working on your parameter make sure you save or commit your work To do so click on the icon on top right of the parameter window This will save all work on the MAPS Server database Page 28 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 In addition to saving your work you can also check your progress and see what the end user will see by clicking on the test icon The Test Run window will be displayed For the end user to actually see any values ina Drop Down Box they will need to click on the expand arrow on the object Another option in displaying the data to the end user would be to use a List box Fig 2 17 Test Parameter Form Parameter Form List Box The List Box is similar to the Drop Down Box in that only one column of values of the underlying query or entries is displayed to the user However with a list box a user can select more than one value Using the ctrl or shift button
95. l be displayed The user can manually type the expression Or you can use the point and click method Click on the to get a complete list of built in Argos functions The Function Builder is point and click The user will be guided through creating new fields We will be formatting the last line of the address and will not need any of these functions Click cancel to return to the Expression Builder form icon to get a the query Asis other forms this icon will pull up all the available fileds Click on the desired column Note that when added the variable will be surrounded by brackets i e To join two fields use the plus sign Here we are concatanting the City and state fields seperating by a comma and space _ The complete string will look like o Cancel Cancel VendorLastName VendorFirstName Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Edit Report Configure the columns that will be added tos comma delimited report PO Number CalcDiscount StartDate EndDate PO Date TRANS Date Clased Completed Printed Date Buver Code Buver Mame COAS COAS Desc Edit Report WendorLasthame 4VendorFirsthame PO Mumber Ez FullMarme Configure the columns that will be added to your comma delimited m no description gt Commodity Code Commodity Des LIONS Unit
96. me parameter to show the difference between the available Parameter Entry and selection tools On a real Parameter form you would not be doing this NAAA In the previous exercise you File Edit View Tools Help ke rr successfully added a DataBlock Logout Back E A 4 Export Publish Security Publish Site Support N OW we need to create the Da rts Explorer Quick Launch xS zum d CRNAverageGPA QV that make up a DataBlock To 1 Bamer Average GPA for selected CRN begin EDITing the DataBlock it Dev Team Home Evisions Training University Quick View Execute this DataBlock 3 QuickView Report p re S S th e E D IT key O r d O u b e C j C k x y Finance Edit Edit this DataBlock d iin on the DataBlock itself zi y Student Delete Delete this DataBlock Alumni Faculty General New Report Create a new Report from this DataBlock t J Rosters Notes View edit the notes on this DataBlock i Specific E Security Edit the security settings for this DataBlock _ Specific Examples amp Advisors query Publish Publish this DataBlock to the Argos Publish server d CRNAverageGPA QV E A sectionGradeAverage QV j Averages Grades Quickview Associated Connection Pool ven v Author ehos Date Created 12 29 2005 2 04 54 PM Date Last Modified 12 29 2005 2 04 56 PM 4 Transaction History it _ Evisions University E InternalApplication 1 o
97. n button to change the caption and or description Hit the Next button one more time Since the Drop Down Box is only capable of displaying one column of data to the end user but our query returns two columns we need to tell Argos what value will be displayed From the Drop Down Box of variables select the variable TERM The CODE variable can still be used in subsequent queries but the end user will only see the term description Click Finish to save the drop down choices CRNRoster QV Commit Changes Active Connection Form Design Query Design Parameters Variables DropDown Ene Select Mo Choices Choices Description Term code selection Free Type Mo Height 21 Left 164 Required Yes SglEntries Yes TabUrder O Top 136 VarableName Sell erm Width 11 Fig 2 16 Drop Down Attributes Page 27 Getting Started Guide Last Updated 06 13 2006 All the objects created on a parameter form have attributes To complete the Drop Down definition you should provide a brief Description 1 of the Drop Down Box In addition you should name the variable 2 The name used here should be unique as it is used as the qualifier for the values returned In our example the values CODE and TERM are retuned in the SQL statement To use these variables in subsequent queries they should be prefaced or qualified with the value entered in the Variable Name field i e SelTerm CODE or SelTe
98. nc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Look in E images J em 598x78 C3 vti cnf E dropshadow jpg E search button j KJ E argoslogin jpg n edit jpa itj search top jpg My Recent Elargos logo jpg E evisions jpg Ij submit jpg Documents fjblocks ipa fj export jpg Ij SUBMIT BUTTOI Lal cancel jpg folder jpg Lal tablebkg2 jpg 3 E category jpg Gi insert jpg E tablebkg jpg Desktop datablock multiple2 org png login jpg E update jpg datablock multiple 24 new png j logo jpg v datablock multiple 24 org png E logout jpg E datablock multiple jpg E minus jpg ES amp i datablock multiple png ij move jpg datablock multiple org png E new jpg j datablock multiple silver jpg rj plus jpg DI E delete jpg rj reset jpg E download jpg lE search jpg My Documents My Computer 3 gt File name search top pg wv Y My Network Files of type All tee po jpeg png bmp ico emt vn e TENES na bmp ico emi wnt AS a A IDIE I le mmm Esla fE m Iis Re a A aa a oa x Se ae ara e 2 277 72 299 aaa a carece a ww Deamel ihmni A M elOOBD AA a eaa aja ade iu cu uns a aa a ulis e e a Ke Fig 2 9 Add an Image Page 20 Getting Started Guide Last Updated 06 13 2006 To start
99. nnection A list of available connections will be displayed The end user will need to make the proper selections until the complete roster for the selected term course is displayed If the user wants to save the data they can right click on the displayed data then choose Save Results By default the columns in the last parameter executed will be checked The end user can select other columns as required To save as a comma delimited file press the Save button Press the Launch button to save the data and then have the data displayed in an Excel spreadsheet Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 CSV Reports A report based on a Report DataBlock provides the user with the ability to not only select what fields they wish to include in the query but also they can manipulate existing columns for example reformat distinct columns into one field A CSV report will extract the data from the report and allow the user to save the data in CSV format The saved data can then be reviewed in Excel for further manipulation Edit Report AE A CSV report can only be created on a Report DataBlock To create a CSV report select the DataBlock Choose the type of report that Argos should generate right click and select NEW Report Displays the parameter entry form configured by the from the
100. ort A Getting Started Guide Argos Last Updated 06 13 2006 We will add the text box similar to how the Select Term was added We can fix the size of the list box several ways gt Manually edit the width attribute of the object gt Drag the side of the box to desired width For the Alignment we will use the alignment tools First select the Drop Down box and the List box by holding down the shift key and selecting both objects Then using the alignment tools make the proper alignment When aligning objects the first object selected will be the guide For example if we want to align on the left edge of the Drop Down Box select that object before selecting the List box Lal and then select the left alignment tool The form should look similar to the following CRNRoster QV Bad Active Connection DEVL v gt a Ls Form Design Query Design Parameters Variables le x A em Ee amn aS we M I Ed Se EA DropDown a ae NEM z pl Auto Select No Choices Choices Description Term code selection Free Type Variablelame SelTerm width M Fig 2 25 Parameter form to date Page 34 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support ATg0s Parameter Form Multi Column Box Getting Started Guide Last Updated 06 13 2006 There are times that the
101. os Functions 62 216 DISDIV ValabDiIes u dnirinaviisekarztuE M EF PFEREFRFEDE EVER EFRERERRTVERRFRNE RERERFFE SERERE SERVDEEREVEVRERVPEEFEERFSKEFERBRN NE 62 3 474 DISDIAV VaHabies AAA ANNAN 63 3 18 Adding Conditional Fields 65 3 19 Adding Table to Conaditional siria AA ORO ORO OL AAA AAA 65 3 20 Adding Fields to Conditional iii AAA AAA AAA 65 3 21 Adding Variables to Conditional s s s 2 22 122 222522222252225222522222252225222522222222222222222222222222222222222225 66 3 22 Expert Mode IcoN narnia 66 3 23 Manually Entering WHERE CAUSE cc AAA 66 3 24 ORDER BY Clause 67 3 25 Icons above Query Data Flelds esses pasa uuu Eua haa pRESEEERERaERERREKRENWRRRERENZRRKWRERTARERZEAERARNERSESRERFRRKRRKARRRREREE 67 3 26 Adding Field Column Level SeCULIty 111111111111111111000000000000 RR uu uu un 68 3 27 Adding User to Field Level Security au nam 68 3 20 Review Field Level SECUFIMV cana 68 AA ShoW UNION Sii AAA ca 69 d TV De OF UNIONS annie AA AAA 69 4 3 Adding d UNION cintia AAA AAA AAA AAA 70 d d Created SUD QUOFy escri AAA A AAA AAA AAA AAA AAA AAA AAA 71 4 59 Ada Condition to SUD QUEFY virirci iaia 72 4 5b Add Condition to SuD Query 3 a aaa 73 4 6 Sub Query Added to Conditional coria 73 4 7 Advance Query Bullder Form aiar 75 4 8 Advance Query Builder Form completed 11111111111111111111110111000000000 rivi iran
102. ox changes For example if you change the font to a larger font size the box will grow accordingly so the text is not truncated If set to NO the box will not grow Data Aware Allows a text box to display the value of a variable This will be discussed in more detail Font Allows the user to alter the attributes of the font being used Height and Width Set the size of the text box Left and Top Set the position of the text box Word Wrap If entering a large amount of text if word wrap is set to YES the text will automatically be broken into set lines so to ensure everything fits within the selected width Page 23 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 Parameter Form Drop Down Box A Drop Down Box is used to display a list of values from which the user can select ONE Even though the underlying query or manual entries might return multiple columns only one column of values will be displayed to the end user To create a Drop Down Box click Commit Changes Active Connection DEVL RR O o er x bee ee ea r 6nh the Drop Down icon and LT IDEST position your cursor on the form w m a To determine what will be in the Gr a parameter select the attribute NN um _ Choices on the left side of the de a form The Choice Entry form will Choices for this
103. p Down Box Page 25 Getting Started Guide Last Updated 06 13 2006 If you choose a SQL statement then it is merely a case of writing the correct statement to retrieve the necessary values Note the use of the AS clause to assign aliases or user friendly names to the data being returned These names will also be the names of the variables that can be used in subsequent queries Once the SQL statement has been entered press the Next button This will perform a syntax check Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Column Properties Following is a list of values retrieved by the qu El Edit Column Fall 2000 summer 2 2000 summer 1 2000 Spring 2000 ME the End of Time Name Display Caption TermCode Column Description This is the term code eios O O Fig 2 14 Data Returned from Test Choice Entry Select the field that will be displayed to the user Fig 2 15 Associate Data Field with Variable Page 26 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 If the query is correct the first five records will be displayed If the coulmn widths are too narrow or too wide the developer can make necessary adjustments by dragging the column bars You can also click on the EDIT Colum
104. r by Vendor quickvi A Transaction History by any FOAP amp 4 Payroll E Student gt 4 Alumni t g Faculty General Rosters J Specific Examples E Ra Advisors query amp CRNRoster QV E A sectionGradeAverage QV Transaction History J Evisions University iJ InternalApplication 34 mur traininn tndav El CRNRoster QV lt click here to set the description gt Quick View Execute this DataBlock as a QuickView Report Edit Edit this DataBlock Delete Delete this DataBlock View edit the notes on this DataBlock New Report Create a new Report from this DataBlock Security Edit the security settings for this DataBlock Publish Publish this DataBlock to the Argos Publish server Associated Connection Pool E o v Author ehos Date Created 12 29 2005 2 04 54 PM Date Last Modified 12 29 2005 4 40 30 PM Type the description University user ehos Fig 2 3 Adding a Description to DataBlock Page 13 Getting Started Guide Last Updated 06 13 2006 A Connection Pool is a group or collection of databases that the administrator has selected to be grouped together The databases are similar in that they should have all the same attributes i e tables Views users etc By selecting a specific connection or database the query is restricted
105. repart layout and go back to this expert afterwards select Finish to close this expert and start editing your repart with the repart designar Page 88 Getting Started Guide Last Updated 06 13 2006 On the next form you can set the default Font for the header labels and detail section In addition you can tell Argos to draw lines around the data fields and or report Click Next to continue After you have made all you selections the final screen gives you an opportunity to Preview or if you want to make some modifications click Finish Click Finish to review the report definitions Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support eg s 4 O da Fia BL go oo OG got b CEM Sen Customer CustName Customer AddressTy CustomerCi CustomerSt CustomerZI CustomerP OrderNum rn rn e ln o oi id ake Py customerlD CustName CustomerA AddressTy CustomerCit CustomerSta CustomerZIP CustomerPh OrderNumb Fig 5 20 Modify Report dose Jt I ow SS E Thumbnails Search Result Customer List Customerl CustName Customer AddressTy 990N BILLING SAN DIMAS CA CA SAN DIMAS CA CA Customer Fig 5 21 Preview Report Page 89 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 0
106. rm TERM Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 We will refer to CODE and TERM as sub variables The complete variable is qualified by the name given to the variable defined in the Attribute window In the above example the select statement was written with the AS clause Note that this will rename or assign an alias to the column It is this alias that the end user will see as the column or field name Using a Drop Down limits the user to the selection of only one value i e in the above example the user will only be able to select one Term When displayed to the end user the selection box will be a list of the values that satisfy the query One column of data will be displayed Even though only one column is displayed the query can be written to return multiple columns of data The data returned in these columns can be used as variables in subsequent queries One attribute that is useful to apply on a Drop Down Box is the Free Type By setting this to YES the user can manually enter a value The value entered will be assigned to the sub variable that was named as the field that will represent the value of the variable In this case that would be the variable SelTerm TERM If that value is valid all other sub variables will automatically be set to the returned value i e the CODE wil
107. rt of building a datablock is the Query Design This is where the developer creates the main sql statement for pulling back data from the datasource based on the choices the end user has made on the parameter form From an end user point of view they only see the Parameter form as designed and the results from the query on the query design if present For the end user to see the results the developer needs to create a report either a CSV report or a banded report A CSV report comma separator value is good for sharing the results between applications or third parties A banded report is good for printing and distributing Even though a QV report can be created from a datablock that contains a query in the query design tab the QV report will still ONLY show what is on the parameter form period The key to the query design is that the results of the query are only displayed on reports created by the developer This type of datablock is often referred to as a Report DataBlock This type of DataBlock uses both the Parameter Design and Query Design forms The Parameter Design is used to allow users any easy way to select criteria in order to limit the information retrieved Their selections are then used as Conditional Fields in the Query Design With this type of DataBlock and appropriate security access users can customize the Comma delimited and Banded report types They can pick and choose which fields they want to include in their report all
108. s Training University E 44 Finance fH Payroll E y Student gt 4 Alumni GF y Faculty t y General fH x _ Rosters Specific Examples amp Advisors query di CRNAverageGPA QV RS sectionGradeAverage QV E _ Transaction History 4 1 _ Evisions University amp 7 InternalApplication J our training today TrainingExamples gt 4 TrainingSamples gt UniData j Averages Grades Quickview El CRNAverageGPA QV lt click here to set the description gt Quick View Execute this DataBlock as a QuickView Report Edit Edit this DataBlock Delete Delete this DataBlock Notes View edit the notes on this DataBlock New Report Create a new Report from this DataBlock Security Edit the security settings for this DataBlock Publish Publish this DataBlock to the Argos Publish server Associated Connection Poo Den Tm DEVL TEST icaro Oracle BETZ6 Oracle PAUL6 orade PROD Oracle TEST Rob_s Connection 1 University user ehos Fig 2 2 Associate Connection Pool Argos Evisions Inc File Edit View Tools Help fa er X ex bob Q5 0 Explorer Quick Launch hi X Banner A E _ Dev Team Home a 1 _ Evisions Training University E poy AR Eh 1 Finance Budget Report QV di Budget Report QV New amp A Budget Report QV _Testing E PurchaseOrder by Vendor query E A PurchaseOrde
109. the detail table for the Purchase orders FPRPODT You will be asked if you wish to bring in the table definition or the Synonym definition Typically in Banner the synonym points to the table There are rare instances however that the synonym points to something else There is no hard and fast rule as to what should be used The synonym might be the safest Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 Defining Joins PurchaseOrder Sees Active Connection DEYL E Po Q Form Design Query Design Ls Tabs Hide Tables Add Table Sub Query SQL Format Oracle A eae EA 3 ES LIMA TTI FIRBDIS AREE Index Name Type FIRBONC all all Y FPRPODT_POHD_CODE Char FPBPOHD_CHANGE_SEQ_N Numeric FPRPODT CHANGE SEQ N Numeric FPBPOHD ACTIVITY DATE DBTime FPRPODT ACTIVITY DATE DETime FPBPOHD_USER_ID Char Char FPBPOHD_PO_DATE DBTime RE Numeric FPBPOHD TRANS DATE DBTime E Char FIRBOND FIRCADC FIRCADT FIRCERC FIRCERD FIRCUDC FIRCUDV FIRCUSC FPBPOHD BLANKET CODE Char s Char FPBPOHD_BLANKET_IND Char FPRPODT_UOMS_CODE Char FPBPOHD BLANKET TERM DBTime FPRPODT UNIT PRICE Numeric 0 FPBPOHD_CLOSED_IND Char FPRPODT_LIQ_AMT Numeric FIRCUUC FIRCUUY i 1 FPBPOHD_COMPLETE_IND Char a FPRPODT_QTY Numeric En IA AATRIT
110. the developer Therefore make sure to test Note that when adding columns in the UNION window there is no spot for the AS or Description fields 1 These will default to the values set in the Main query Page 70 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Ay Getting Started Guide ATOS Last Updated 06 13 2006 Create a Sub Query A sub query is frequently used in the where clause to limit the number of records returned in the main query For example in Banner a student can have multiple records in the Student general information table SGBSTDN Every time the student changes a major or level a new record will be entered When pulling back data from this table you want to make sure you get the correct data based on the term being queried In the example below we have already created a query where we are getting the major for the selected student from the SGBSTDN table The sub query is added to make sure the major is for the selected term First a sub query needs to be created T7 EE a 1 From the Query Form press the Sub N SQL Format ANSI SQL 92 A Quer button 1 SCRCRSE DEPT_CODE A a SCBCRSE CSTA CODE SCRCDSE TITIF how Tables how Unions dd Table ub Quer ormat Oracle EN Utm Qmm lane Lene laser omo AOS EE A new Query Form is displayed Here you can add tables as shown earlier x SATURN SGBSTDN A Index M
111. the variable to list all the sub variables available CRNRoster QV Commit Changes Form Design Query Design Parameters Variables Variable Name Descripti settings i Bldg CourseTitle EndDate Instructor MeetingDays MeetingTime Room StartDate E MultiColumn SelCRN Fig 2 41 list sub variables Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support AT Getting Started Guide 205 Last Updated 06 13 2006 Full SQL Statement select SUBSTR NVL SSBSECT_CRSE_TITLE SCBCRSE_TITLE 1 40 as CourseTitle SSRMEET SSRMEET_BLDG_CODE as Bldg SSRMEET SSRMEET_ROOM_CODE as Room DECODE TO_CHAR TO_DATE SSRMEET_BEGIN_TIME HH24 MI HH MI pm TO_CHAR TO_DATE SSRMEET_END_TIME HH24 MI HH MI pm TBA TO_CHAR TO_DATE SSRMEET_BEGIN_TIME HH24 MI HH MI pm TO_CHAR TO_DATE SSRMEET_END_TIME HH24 MI HH MI pm as MeetingTime NVL SSRMEET_SUN_DAY SSRMEET_MON_DAY SSRMEET_TUE_DAY SSRMEET_WED_DAY SSRMEET_THU_DAY SSRMEET_FRI_DAY SSRMEET_SAT_DAY TBA as MeetingDays NVL TO_CHAR SSRMEET_START_DATE MM DD TBA as StartDate NVL TO_CHAR SSRMEET_END_DATE MM DD TBA as EndDate nvl f format name sirasgn pidm LF30 Staff as Instructor from SATURN SIRASGN SIRASGN SATURN SSRMEET SSRMEET SATURN SCBCRSE SCBCRSE SATURN SSBSECT SSBSECT where SSRMEET
112. to just this connection It is recommended that during development that a single connection be used When the DataBlock is fully tested then the developer can associate it to a connection pool Adding a description to a DataBlock allows the developer to provide more information to the end user To assign a description to this DataBlock click on the Click here to set the description and enter desired text Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 o http www evisions com support Getting Started Guide Last Updated 06 13 2006 berto nine You can further document your File Edit View Tools Help Ga e x L a we DataBlock by creating notes Click NE amp CRNRoster QV on the Notes button To add a new e X gp u note press the green Enter a S 1 Semen PUE EII brief note in the small box and B La France NU more complete text below 2 Budget Report QV sane PEN and TU EE MERE GRON E Budget Report QV New x ESSE IC Up rarae dca Notes are useful in keeping track of ub destape desi why you are in creating a a odes DataBlock or for documenting what vi fad tables are being used G 7 General Rosters gp If you are going to be publishing or MM T sharing this DataBlock with others i elegge HEN this is an ideal place to document ri nece An what tables and functions are being used You could also include
113. udent you would prompt for the student ID and then in another object on the parameter form display the advisor for that ID In this case the parameter form is a complete report Nothing more is needed We refer to this type of report as a QuickView or QV report The intent of a QV report is to quickly get and display information The report does not need to be printed or saved although the results can be saved if needed IF this is all that is required the datablock is complete A QuickView DataBlock is the easiest to build This type of DataBlock gives end users the ability to look at information on their screen with drill down capabilities It is very useful for combining different screen shots from the database application into one Users have the ability within a Quick View report to right click on the information being displayed and dump it into an excel spreadsheet for further manipulation Comma delimited and Banded reports are not options for QuickView DataBlocks In the DataBlock design only the Parameter Design form is used The Query Design form is not used at all in this type of DataBlock An example of a QuickView report can be seen in Fig 2 7 Page 8 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 Key to the above A QuickView report ONLY displays what is on the parameter form The second pa
114. unless otherwise indicated are based on the Sungard SCT Banner administrative suite of student financial aid finance HR and advancement systems Most of the samples will be based on the finance or student modules Page 4 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide n 205 Last Updated 06 13 2006 1 General Overview Argos Architectural Overview Argos is an MAPS application MAPS stands for Multiple Application Platform Server Evisions undertook this aggressive project nearly two years ago and what has come of it is nothing short of spectacular By creating a web based application server Evisions is now able to deploy all of its products via the web By using this common MAP Server for all our products we have incorporated our various applications into an integrated suite of products This allows a single point of administration for the various products via a web based interface The MAP Server software can be installed on Win 32 platforms such as Windows 2000 XP 2003 You may install it on a non server platform but this should only be done for evaluation purposes In a production environment other systems may access this software so it is recommended that MAP Server software be installed on a Windows server level platform and that the system is constantly on and accessible via your network The Argos client is launched from a
115. ur training today J TrainingExamples TrainingSamples iH UniData Deletes the selection user ehos Fig 2 6 Edit DataBlock Page 15 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Fig 2 7 Blank Form Design Page 16 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support Getting Started Guide Last Updated 06 13 2006 The Edit button takes you to the Argos Builder The Builder consists of two windows The Query Design 1 window is used only when creating a Report DataBlock and will be discussed in Chapter 3 of this manual The Form Design 2 window is used to define the parameters that the end user will use to enter or select the selection criteria when the final report is executed It consits of the Parameter tab and the Variable tab To access the Parameter form from the Argos Builder window click on the Parameter Tab on the Form Design tab Ay Getting Started Guide ATOS Last Updated 06 13 2006 Connection Preview or Test Get Student Addresses s i AJ sli e jaj xj Active Connection E DEYL Controls orm Design Query Desg Parameters variables a x W ga abr EH e rz x H da e SI MN LIA a E Properties iuununnuninnningnindninssAHgnment El pb no d h obud
116. web browser However a shortcut to Argos can be created on the user s PC desktop To create the shortcut right click on a blank spot of the desktop and select New Shortcut When prompted enter the full URL for the Argos web server Click Next and assign a name to the newly created shortcut The user can now click on this shortcut to quickly launch Argos Logging in and Argos Desktop A MAPS Product Downloads Microsoft Internet Explorer elle Sele File Edit View Favorites Tools Help ae x Q sad EJ x a A P Search S T Favorites Es ee Ss S a i Open up a web browser TE Fem Ee aes ints gt Internet Explorer and go to http localhost 8080 It should then display this screen MAPS Product Downloads Click on the link that points to Welcome to Argos and MAP Server by Evisions Inc Following is a list of Argos Reporting Tool products that this MAP Server serves i gt MAP Seve contri i NOTE If you have another HS application that uses port 8080 and Argos does not launch see your
117. wn box in that only one value is displayed to the user However the end user will be able to select multiple values The drop down icon limits the user to only one selection l EH icon is used to add an object that will display multiple columns of data to the end user The user will be able to select one or multiple values El Icon will allow the designer to add a date field s Using the OK button on a background allows items on the background to be refreshed Page 18 Evisions Inc e 14522 Myford Rd e Irvine CA 92606 e Phone 949 833 1384 e Fax714 730 2524 e http www evisions com support AT Getting Started Guide ATOS Last Updated 06 13 2006 Parameter Form Images and Text A parameter form is used to ask the end user for input as well as display data to the user As discussed a QuickView report is run completely from the Parameter form In our example the user will be asked to select a term from a displayed list of terms Once the term is selected a list of CRNs taught that term will be displayed Any value that is returned from a query or is manually entered will be stored in variables that can be used in subsequent queries Argos is smart enough to NOT execute a query until it has values for any variable that might be used in the SQL statement The following will show how to add the object that will allow the user executing the report to select the term and subsequently CRNS for that term Page 19 Evisions I
118. x714 730 2524 e http www evisions com support Getting Started Guide Argos Last Updated 06 13 2006 To generate all the data we want we will need to add additional tables SPRIDEN Person ID table FTVBUYR Validation table for all buyers FTVCOMM Validation table for commodities The header fpbohd table needs to connect to the SPRIDEN table based on the fobpohd_vend_pidm equal to spriden_pidm inner join The commodity table needs to be joined to the detail fprpodt table based on the fprpodt_comm_code matching ftvcomm_comm_code However it is possible that there is not a match therefore we want to do an Outer join pulling in all records from the detail table and only those in the commodity table where there is a match We do this by creating the join first and then editing the join to be an outer left join if you drew the connection from FPRPODT to FTVCOMM or outer right join if connected from FTVCOMM to FPRPODT PurchaseOrder Active Connection DEVL Y eN Y Form Design n Query Design Tables E Hide Tables Hide Tables show Unions Add Table Add Table Sub Sub Query SOL Format Oracle A 2 ES El EE se FIMSMGR FPBPOHD FPBPDHD FIMSMGR FPRPODT FPRPODT iu wd Index Name Tvpe Pos Index Name Type zblank s FFPBPOHD TRONS DAIE DB Ime Z Y FPRPODT CHAMGE SEQ M Numeric ALUMNI Y FPBPOHD BLAMKET CODE Char 17 FPRPODT CLOSED IMD Char BANIMGE KET TMD m n en ES E MI

Getting Started Guide

Contents

Download Pdf Manuals

Related Search

Related Contents