Static Choice- Value Prompt

[kellog1]

I have to create a report with value prompt with static values. For example when user runs the report ,it should ask user to select from 3 prompt values --> Future students, Current students and Past Students.

Functionality
Future Students = Start date > current date
Current Students = Start Date < current date and End date > current date
Past Students = start date < current date and end date < current date

How do I create this type of prompt page?

Thanks
KS

 

[plevey]

Add a Prompt Page.
From Toolbox add a Value Prompt. Check 'Create a new parameter' eg PStatus. Click <Next> Uncheck 'Create a paramiterized filter' Click <Next> Uncheck 'Create a new query' Click Finish. Add static choices. Then add a filter.
In my case I have an employee status flag of 'A' = 'Active', blank = 'Left' but the same logic applies

My filter is
[Employees].[Status] =
CASE
WHEN (?PStatus? = 'Current') THEN 'A'
WHEN (?PStatus? = 'Left') THEN ' '
END