Block Level Filter Not Working

building reports webintelligence
1

Hi all,

I need help limiting the number of rows displayed (Top N Rows) based on user input.

I have:

  1. Sorted the column which I wanted to Rank in desecending order
  2. Created a universe-level variable (“Top N Ranking”) to capture the user reponse of Top N rows desired.
  3. Created a report-level variable using LineNumber() that gives me unique ID for each row in the report.
  4. Created a reported-level variable (“Row Filter”) that says If User Responses <= Top N;1;0.

I then added a report filter by limiting the value of the “Row Filter” variable to 1. BUT IT ISN’T WORKING!! Even though a filter is set to limit the value to 1, all the rows with value of 0 (where line # is greater than the top N # user specified) are still showing up.

I’ve attached a screenshot (see attachment).

Help please?
BOScreenShot.JPG

kkliu (BOB member since 2010-03-25)

2

This thread may help.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Thanks for the response, Nick.

I have no issue capturing user response. If you look at the screenshot, the 3rd column (Top N Ranking) was the user response (10 in this case).

My issue is filtering out the unwanted rows (row 11 and on, since the user only specified 10 rows). My “Row Filter” variable returns the correct value (1 if the Line Number < Top N Ranking, 0 if Line Number > Top N Ranking). However, I can’t get the report filter to work. As you can see from the screenshot, even though the filter is set to =1, all the rows with 0 values are still showing up. :frowning:

kkliu (BOB member since 2010-03-25)