Report Functions

Functions that can be used to modify reports

* Use specially designed functions to add specifically formatted fields to reports

Function – fnDispDate

Call	Example	Returns
fnDispDate(date, 'a')	April 01, 2009	Supply any date format and returns full month name followed by 2 digit day a comma and 4 digit year

Function – fnDispName

Call	Example	Returns
fnDispName('BOTH',50)	JOHN and JANE DOE	50 chars Member's First Name and Spouse First Name Last Name
fnDispName('M&M',50)	JOHN and JANE DOE	50 chars Member's First Name and Spouse First Name Last Name
fnDispName('PFNMLS',60)	Dr JOHN "THE HAMMER" D DOE, JR	60 chars Prefix space First Name space Nick Name in Quotes space Middle Name space Last Name, Suffix
fnDispName('PFNMLST',80)	Dr JOHN "THE HAMMER" D DOE, JR, EXALTED RULER, POY, PEY	80 chars Prefix space First Name space Nick Name in Quotes space Middle Name space Last Name, Suffix, Elk Titles and Checked Titles separated by commas
fnDispName('PFNMLSE', 80)	Dr JOHN "THE HAMMER" D DOE, JR, PDDGER, ER, EETTTD	80 chars Prefix space First Name space Nick Name in Quotes space Middle Name space Last Name, Suffix, Elk Titles separated by commas
fnDispName('PFNMLS-T',80)	Dr JOHN "THE HAMMER" D DOE, JR EXALTED RULER, POY, PEY	80 chars Prefix space First Name space Nick Name in Quotes space Middle Name space Last Name, Suffix new line Elk Titles and Checked Titles separated by commas
fnDispName('PFMLST',80)	Dr JOHN D DOE, JR, POY, PEY	80 chars Prefix space First Name space Middle Name space Last Name, Suffix, Elk Titles and checked Titles separated by commas
fnDispName('PFMLS-T',80)	Dr JOHN D DOE, JR EXALTED RULER, POY, PEY	80 chars Prefix space First Name space Middle Name space Last Name, Suffix new line Elk Titles and Checked Titles separated by commas
fnDispName('LFM',40)	DOE, JOHN D	40 chars Last, First Middle
fnDispName('LSTPFNM',80)	DOE, SR, EXALTED RULER, Dr JOHN "THE HAMMER" D	80 chars Last Name, Suffix, Titles separated by commas, Prefix First Name Middle
fnDispName('LSTPFNM', 80)	DOE, SR, PDDGER, EETTDD, Dr JOHN "THE HAMMER" D	80 chars Last Name, Suffix, Elk Titles and Checked Titles separated by commas, Prefix, First Name Nick Name in quotes, Middle Name
fnDispName('LSEPFNM', 80)	DOE, SR, PDDGER, EETTDD, Dr JOHN "THE HAMMER" D	80 chars Last Name, Suffix, Elk Titles separated by commas, Prefix, First Name Nick Name in quotes Middle Name
fnDispName('FML',40)	JOHN D DOE	40 chars First space Middle space Last
fnDispName(''SAL',40)	JOHN	40 chars FIRST
fnDispName('',40)	JOHN D DOE	40 chars First space Middle space Last

Function – fnDispSpName

Call	Example	Returns
fnDispSpName('LFM',40)	DOE, JOHN	Last, First Middle
fnDispSpName('FML',40)	JANE DOE	Spouse First space Last
fnDispSpName('SAL',40)	JANE	Spouse First Name
fnDispSpName('F',40)	JANE	Spouse First Name
fnDispSpName('FM',40)	JANE	Spouse First space middle

Function – fnDispTitles

Call	Example	Returns
fnDispTitles()	CHAPLAIN, PER, PEY	Titles Separated by commas

Function – fnDispAddr

Call	Example	Returns
fnDispAddr('ALL',80)	425 W DIVERSEY UNIT 2 CHICAGO, IL 60613-1111	From the Current Address Tab, Address new line Address1 new line City State, zip Country (if entered)
fnDispAddr('BOTHLINE',80)	UNIT 2 425 W DIVERSY	Address space and Address1 on one line
fnDispAddr('BOTH',80)	425 W DIVERSEY UNIT 2	Address new line Address1
fnDispAddr('CSZ',80)	CHICAGO, IL 60613-60613	City, State and Zip Country (if entered) All on one line

Function – fnDispPhone

Call	Example	Returns
fnDispPhone('HOME')	### ###-#### h	area code space phone number including dash and h
fnDispPhone('WORK')	### ###-#### w	area code space phone number including dash and w
fnDispPhone('CELL')	### ###-#### c	area code space phone number including dash and c
fnDispPhone('FAX')	### ###-#### f	area code space phone number including dash and f
fnDispPhone('ALL')	### ###-#### h ### ###-#### c ### ###-#### w ### ###-#### f	home phone new line cell phone new line work phone new line fax number

Function – fnDispBC11D

Call	Example	Returns
fnDispBC11D()		11 digit barcode to be used with "Postnet_10_Point_only 1, 8, N, 2"

Function – fnDispBC4S

Call	Example	Returns
fnDispBC4S()		4 state barcode

Function – fnDispLodgeNA1

Call

Example

Returns

fnDispLodgeNA1()

LODGE NAME #5555

PO BOX 555

CITY NAME, ST #####-####

Lodge Name and Lodge Mailing Address from the Lodge settings screen

Function – fnDispLodgeNA2

Call

Example

Returns

fnDispLodgeNA2()

LODGE NAME #5555

PO BOX 555

CITY NAME, ST #####-####

Lodge Name and Lodge Mailing Address from the Lodge settings screen

Function – fnDispLodgeName

Call

Example

Returns

fnDispLodgeName()

Lodge Name Line 1

Lodge Name Line 2

Line 1 card imprint new line

Line 2 card imprint

from the Card & Dues Tab on the Lodge Settings Screen

Function – fnDispDues

Call	Example	Returns
fnDispDues('NOTIC1')	###.##	Determines dues for what is Notice1
fnDispDues('NOTIC2')	###.##	Determines dues for what is Notice2
fnDispDues('notic3')	###.##	Determines dues for what is Notice3
fnDispDues('notic4')	###.##	Determines dues for what is Notice3
fnDispDues('notic5a')	###.##	Notice 5 Line 1
fnDispDues('notic5b')	###.##	Notice 5 Line 2
fnDispDues('notic6')	###.##	6 month Delinquent Reg or Life Dues
fnDispDues('noticl')	###.##	New Life Dues

Function – fnDispDuesType

Call	Example	Returns
fnDispDuesType()	REGULAR MEMBER DUES or LIFE MEMBER DUES	Used on dues statements

Function –fnDispMemberType

Call	Example	Returns
fnDispMemberType()	blank, LIFE MEMBER, HONORARY LIFE MEMBER OR ASSOCIATE MEMBER	Identifies the type of member blank if regular member. Use on Cards

Function –fnCalcMbYears

Call	Example	Returns
fnCalcMbYears()	##	correct number of years as member used on cards, labels, etc