Visibility Condition

Hi all,

I have a report in which I have an auto-number column based on aggregation function. I want to display only the top 10 rows in the start and then allow the user to click a hyperlink if they want to view the entire report..

in the visibility of the cells, I added this following expression:

if ( row["Aggregation"] > 10)
{
true
}
else
{
false
}

This is working nicely by only displaying rows with numbers up to 10.

But, how to do the other part.. i.e, displaying the entire report..

Any help would be highly appreciated..

Many Thanks,

Abhi

Find more posts tagged with

Comments

mwilliams

Hi Abhi,

You could also create a computed column that computes the total rows in the result set. You could then use your first runningCount aggregation to filter your table to the top 10. When the hyperlink for the whole report is clicked, you would just change the filter to allow the total count from your second aggregation. Hopefully this makes sense.

Let me know if you have questions.