DEADDUMP

Used with a JUSTDOIT to replace the report cursor with a specific data set (see Notes section for fields) and allow exporting to a file. This basically returns an abbreviated set of fields from the default "Deadbeat" report.

Reporting Area(s):

Deadbeat

Required Parameters:

None

Optional Parameters:

Sort Order for output. Enter Field name(s) separated by commas (e.g. "cobegdate,cocrse"). Defaults to nmname3,nmname1.
Additional Fields list. May list field individually (e.g. “NMINC” ) or add field with an alternate name (e.g. "loccounty as County"). Can also use Functions for special formatting. (you may add multiple fields by separating them with commas)
Target Drive/Path/Filename where file is to be written. If none is specified, a “Save As” dialog box allows you to specify the location and file name.
Character string to set type of export file. Options are: 'CSV', 'FOXPLUS', 'SDF', 'DELI', 'XLSX', and 'XML'. (Defaults to 'XLS'.)

Example(s):

JUSTDOIT("deaddump()") Replaces Cursor with new data set and allows exporting to Excel.

JUSTDOIT("deaddump('COCRSE')") Replaces Cursor with new data set in Course Code order and allows export to Excel.

JUSTDOIT("deaddump(,'cdow(cobegdate) as BeginDay'))") Replaces Cursor with new data and adds the character value of the day the course starts as BeginDay column and allows Export to Excel.

JUSTDOIT(" =deaddump(,,'c:\Rosters\Myroster') " ) ))") Replaces Cursor with new and allows Export to Excel with default destination folder as C:\Rosters\ and target file name as ‘Myroster’. NOTE: you may just list target drive/folder.. ie: ‘C:\Rosters\’

JUSTDOIT("deaddump(,,,'CSV’)") Allows export to CSV.

Notes:

These are the fields exported:

Cocrse

Cocrsnm

Cobegdate

Coenddate

Loclocat

NMID

Nmsalut

Nmname1

Nmname2

Nmname3

Nmsuff

Nmbadge

Nmtitle

Nmfirm

Nmaddr1

Nmaddr2

Nmcity

Nmstate

Nmzip

Nmcounty

Nmcntry

Nmdphone

Nmhphone

Nmcellph

Nmfphone

Nmemail

Nmcode1

Nmcode2

Nmmembnum

Nmchar1

Nmedlevel

Nmbirth

Nmsex

Nmethnic

Nmorg

Nmocc

Nmspec

Rgaddate

Rgregnote

Rgfeedesc

Rgcrsefee

RgCEUS

Rghours

Rgcredit

Rggrade

Rgptcert

Rgcomplete

Rgcancel

Rgwaitlist

Rgstatus

Rgcode

Rgmisc

Due

Paid

All NameUDFs fields

All RegUDFs fields