>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
John,
what's your data model ? All data in one or more tables, relations between them ? I need more info ....
Vlad-Georg