CWA – Advisor Advisorclass Report Generator

YOU'RE NOT AUTHORIZED!
Goodby

Advisor Advisorclass Report Generator V1

Indicate which fields should be on the report

Select Output Format
Table Report
Tab Delimited Report

Delimited by tabs
Delimited by commas
Delimited by semicolons

Which Mode
Production
TestMode

Enter the 'Where' clause:

Enter the 'Orderby' clause:

Save the report configuration?
Do not save report configuration
Save report configuration (enter report name:)

Verbose Debugging?
Debugging off
Turn Debugging on

Save Report to Reports Table?
Do not save
Save the report



Sequence: If you want the output fields to be in a specific order, enter the sequence numbers for each field to be displayed. If any fields are sequenced, all of the selected fields need to have a sequence number, otherwise the order the fields will be displayed is indeterminate. Recommend numbering the sequence numbers by 10's to allow for changes


Examples of the 'where' clause:
To include advisors for a particular semester: advisor_semester = '2025 Jan/Feb'

To include advisorclasses at a specific level: advisorclass_level = 'Fundamental' and advisorclass_semester = '2025 Jan/Feb'

To find a specific advisor: advisor_call_sign = 'WR7Q'

To find classes with students: advisorclass_number_students > 0

To find active classes for future semesters: advisorclass_class_incomplete = '' and futureSemester

To include all future semesters, use futureSemester. For example: advisorclass_level = 'Fundamental' and futureSemester

To search current or upcoming semester use proximateSemester



Prepared at 2026-04-12 21:44:25

Report pass 1 took 1,776,030,265.4561 seconds to run