Hi All,
I have come up with the issue that I have one value prompt where I have given static choices like 10,20,...till 100 so basically 10 static choices and based on that I want that much rows on my report page .Lets say If I have selected 10 then 10 rows should be display in the report likewise.
If someone can guide me on that ..
Hi Karnag,
You can use a rank funtion and then order it by asc/desc then pass the prompt value to the report.
Regards
Raj
If the query is sorted the way you want using running-count with a filter will also work.
Hi,
the solution of using a running-count on a rank function may lead to different results then filtering on the the rank function.
The following example shows the different results
Value Rank Running-Count on Rank
10 1 1
20 2 2
25 3 3
30 4 4
40 5 5
40 5 6
When you filter for the top 5 values now, a filter on the rank functions will include the second value 40 while it will be filtered out by using a filter on the running-count. You should consider which approach to choose based on your requirements.
Best regards,
Thanks Guys Running count worked in my case I just change the detail filter property 'After auto aggregation' and it worked.
Cheers