in the "Column Filter Prompt Properties" dialog box used in 10g, there was an option called "Limited Values" for "What values should be shown to the user" question. So the users could only see those choices allowed by a filter.
Is there such thing in 11g? I could not find it anywhere. Please help!
At Value field Click Triangle icon and then you see there is Limited Values besides other options.
In the Prompt you might expand the Options to see that.
Edited by: Srini VEERAVALLI on Jan 31, 2013 2:18 PM
when I click on the triangle icon, there's no "Limited Values" option.
In the "Edit Prompt" window, I can see the "Limit values by" select box which just lists other prompts, but that's not what I need. I waht the prompt to show only those values which would satisfy report's filter conditions.
Am I looking at the right stuff?
Oh I see what you mean. You're talking about the column filter. But it's not actually what I mean.
I mean that it 10g when you click not Criteria tab, but Prompts tab - that's where you can create what they call "Column Filter Prompt". And in that tab you can bring up the "Column Filter Prompt Properties" window and select "Limited Values". Hope I now made it clear what I needed.
Thanks for the reply, Srini. Do you remember where that option is? I can see the "Limit values by" checkbox with attached select box, but the only choice it offers is to limit by another prompt (if you have several prompts). I don't see any way to limit by a filter that already exist in the request. Thanks!