Few records are missing

building reports webintelligence
1

Hi

I have a report which includes null values inorder to avoid the null values i have applied the block filter which is working fine.But i need to display the top n records based on user response.If user selects “all” option in prompt its displaying the records correctly(eg:10),but when the user select top 5 its displaying only 2 records instead of 5 and these 5 records need to be picked up from 10 records(from above ex.).How can i solve this problem?

Knr123 (BOB member since 2011-05-08)

2

Nofilter() is what I guess can help you in your formula … You can try it.

aniketp :uk: (BOB member since 2007-10-05)