I am creating a PV to create a report for a school app. The user specifies the parameters as follows:

The user must specify the Term (?vTerm). The other parameters are optional: Student Name (?vStuFKey--one student only), Level (?vLevel--all classes for that level), Level + Section (?vSection--all activities for that level+section) OR Level + Section + Activity (?vActivity--one class only). I'm having trouble with the SQL WHERE clause. Let's take the simplest example: the user wants the report for the entire Term (all classes, all students). In that case I want all the other ?v-parameters ignored:

1. Is there a wildcard character that I can use for the other ?v-parameters so that they will be ignored or be all-inclusive?

2. If not, how can I write the SQL to scratch where I itch?

TIA,
John