WHAZZIS

Used in a report header to display the query value used to generate the report.

Reporting Area(s)

General

Required Parameters

None

Optional Parameters

1. Character return value:

"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

"fieldname" = field from reports table to return. Available fields are rptname, rptdesc, rptlastuse, rptuser, rptcount, rptwhoused

Example(s)

WHAZZIS() returns COCRSE="04F" (queried field was Course Number and entry was '06F'))

WHAZZIS("A") returns "Course Number Begins with COCRSE ='06F'" (query name 'Course begins with', queried field was cocrse and entry was '06F')

WHAZZIS("Q") returns "Course Number Begins with" (query name only)

WHAZZIS("V") returns "06F" (query value only--what was entered in the query field)

WHAZZIS("QV") returns "Course Number Begins With 06F" (query name and value)

WHAZZIS("+") returns "Course Number Begins with (reportname, e.g. DEADBEAT)" (query name and report name)

WHAZZIS("++") returns "Course Number Begins with (DEADBEAT) Outstanding Balances" (query name, report name and report title--in this example the report is titled Outstanding Balances and is being run from the Reports | Accounting | Special 1 Reg/1 Line (Deadbeat) report area)

WHAZZIS("rptlastuse") returns the date the selected report was last used