JUSTDOIT
Passes a SQL statements to reports which runs prior to report generation.
Reporting Area(s):
General
Required Parameters:
- 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.