JUSTDOIT

Passes a SQL statements to reports which runs prior to report generation.

Reporting Area(s):

General

Required Parameters:

  1. SQL statement

Optional Parameters:

None

Example(s):

JUSTDOIT('select *,0 as marker from (cursor5) order by nmname3,nmname1 into cursor(cursor5)') changes the Sort Order of Report to last name, first name.

JUSTDOIT('select *,addcrse(cocrse,"cobegdate") as date, 0 as marker from (cursor5) order by date into cursor(cursor5)') adds the course begin date field to the Cursor and then Sort by it.

JUSTDOIT('select *,0 as marker from (cursor5) group by nmid,nmname3 into cursor(cursor5)') eliminates duplicate Name records from the report.

JUSTDOIT('select *,0 as marker from (cursor5) where due-paid>0.00 into cursor(cursor5)') filters the report--only include individuals who owe money for the registrations.

 

Related Topics Link IconRelated Topics