Conditionally Dynamic Parameters
Is it possible to apply a condition to the values returned for a dynamic paramter? For example, I want users to select from a list of groups, but the table includes both student and teacher groups. How can I make the list of groups include only student groups?
Who's got a new gig...
I think we cannot add a filter condition for a dynamic prompt in designer. We can do it using business view by adding filter condition or If you want to add the condition at the designer level then add new command like
select data from table where field="students"
and remove the links between this command and the existing tables from your report and create a dynamic parameter using the field from your command.
I hope this helps!