1 / 26

Chuck’s Academy of Function Anatomy

Explore intricate formatting functions and specialized features in Chuck’s Academy Part 2 webinar. Learn to format text, dates, phone numbers, and more. Discover cool functions like Age, Whazzis, and Justdoit for advanced data manipulation.

bcastillo
Download Presentation

Chuck’s Academy of Function Anatomy

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chuck’s AcademyofFunction Anatomy Part 2 An ACEware Webinar

  2. Function Academy – Part 2 • Formatting Functions • Function Categories • Especially Cool! • Advanced and Specialized

  3. Formatting Functions NAMER – formats name namer(rgid);nmfirm;nmaddr1;nmaddr2;nmcity,nmstate,nmzip

  4. Formatting Functions NICEDATE – formats date nicedate(cobegdate,coenddate) nicedate(cobegdate,coenddate,3)

  5. Formatting Functions SHOWPHON – formats phone number showphon(indphone,"Day: ");showphon(inhphone,"Eve: ")

  6. Formatting Functions CSZR – concatenates city, state and zip (frequently combined with other functions) namer(nmid);nmtitle;nmaddr1;nmaddr2;cszr(nmid);nmcntry

  7. Other Function Categories

  8. Especially cool! AGE– Calculates the number of years between two dates AGE(nmbirth)

  9. Especially cool! GETDATA – Opens a message box in which you can enter a temporary message to be used in a report. (Used in a JUSTDOIT) Required Parameters: Character title expression (i.e. text that will display at the top of the message box) Input variable. Variable can be a date, (e.g. ctod('//') ), a number (e.g. 0.00), or character. If character, use the SPACE() function to specify desired length (i.e. SPACE(50) creates a data entry field 50 characters in length). Note: if you wish to enter a large text block (i.e. a memo), enter a space value 251- SPACE(251). This will let you enter large blocks of text in a scrolling data window.

  10. Especially cool! GETDATA (continued)

  11. Especially cool! JUSTDOIT with GetData Function GetData Function

  12. Especially cool! WHAZZIS – Displays query used on report whazzis(.t.) Optional Parameters: "A" = Query Name, Query Field and Query Value "Q" = Query Name Only "V" = Query Value Only "QV" = Query Name and Value "+" = Query Name and Report Name "++" = Query Name, Report Name and Report Title

  13. Especially cool! QuikCode – shows code description (instead of code) iif(empt(rgtrack),'NO CODE',quikcode(RGTRACK))

  14. Chuck’s Favorites Sometimes we have to humour the boss!

  15. SHOWEXP SHOWEXP Don’t forget to add your formatting!

  16. ADDOMNI When it absolutely, positively has to be there! Returns any field from any table in the system (key value must be in cursor). Required Parameters: Table you want to return a field from in quotes (i.e. "NAMES", "COURSE", "REGISTER") Key from above table in quotes (i.e. "nmid" or "nmid+rgcrse") Key from report cursor, NO quotes (i.e. nmid or nmid+cocrse) Field from specified table to return (i.e. "nmsalut", "cosubcode", "rggrade")

  17. FINDINST FINDINST can display more than a name! 1= Name and SSN 2= Name only 3= Name, day phone, and eve phone 4= Name-Last Name, First Name 5= Name and Address in block form 6= Name, Address and Phone #'s in block form 7= Name and user defined char string (enter char string as parameter 3) 8= Name, SSN, and Pay description

  18. Justdoit JUSTDOIT is a specialized report function that uses SQL to request and manipulate information from the data tables. What can a JUSTDOIT do? • change the sort order of data in a report • filter out unwanted data • execute specialized report functions • gradspec • getdata

  19. Writing a Justdoit All JUSTDOIT’s that change the output order, eliminate duplicates or filter begin the same: justdoit(‘select *,0 as marker from (cursor5) And continue with Order, Group, or Where

  20. Writing a Justdoit And finishes with . . . Into cursor (cursor?) Tells the system to place the data back into the cursor once it has finished executing all the select statements,

  21. Justdoit Examples Change the Sort Order of Report with "Order By" Statement justdoit(‘select *,0 as marker from (cursor5) order by nmname3,nmname1 into cursor(cursor5)’) Eliminating Duplicate records with the "Group By" Statement JUSTDOIT(‘select *,0 as marker from (cursor5) group by nmid,nmname3 into cursor(cursor5)’) Filter the report with "Where" Statement JUSTDOIT(‘select *,0 as marker from (cursor5) where due-paid>0.00 into cursor(cursor5)’)

  22. Justdoit The JUSTDOIT expression box may be placed anywhere on the report template butwe recommend placing it in the header band of the report.   It's a non-printing element and will not display on the report itself.

  23. Adding a field with a JUSTDOIT Add a field to the Cursor and then Sort by it JUSTDOIT(‘select *,addcrse(cocrse,"cobegdate") as date, 0 as marker from (cursor5) order by date into cursor(cursor5)’) Use the ADDCRSE function & add “as date” which identifies the new field for the cursor and continue with the justdoit

  24. Additional Help A plethora of additional information on all functions is available in the online help or . . . Call your tech!

  25. Questions???

  26. Our next webinar . . . Wednesday, June 30th 1:00 Central When we unveil the all new 7.2!

More Related