COGNOiSe.com - The IBM Cognos Community

Im having a rank column,i want to filter the report using rank prompt.

eg:
prompt will be a static choice
1 to 5
6 to 10
11 to 15

depending on user selection the report should be filter.

it should show only the range selected.

Thanks in advance.

create a query(Query1) with all required fields including Rank field.
create a another query(Query2) and drag Query1 into Query2 as shortcut.
now create a filter in Query2 using the Rank field of Query1

Thanks a lot for repaly

can you please explain in detail.

do i need to write(somthing like below logic) in filter

if (ParamDisplayValue('para') = 1)
then([Query1].[Rank]>=1 and [Query1].[Rank]<=5)
else([Query1].[Rank]>=6 and [Query1].[Rank]<=10)

my static choice prompt is

Use value         Display value       
1                      1 to 5
2                       6 to 10
3                      11 to 15   


Thanks.

This is solved.

we can do in easy way by having case statement in filter.

Thanks  for replay.

her is the logic for the filter

create a query and a static choice, give name as para

case
when ?para? = 1
then ([Rank] in_range {1:2})
when ?para? = 2
then ([Rank] in_range {3:4})
when ?para? = 3
then ([Rank] in_range {5:6})
end

Thanks.
for feature users