limit # of rows for straight table export

[kmstephenson]

Hi All,

I'm hoping to limit the number of rows (100) an end user can export from a specific table at a time. I tried using dimension limits, showing only first 101 values with Show Others checked and Collapse Inner Dimensions checked. However, I am allowing interactive sort for my straight table so if a user sorts on anything other than MRN (the first dimension), it shows the first 100 MRNs for each value of the field sorted by instead of still showing only 100 total rows.... Any way around this to either show always first 100 MRN (and sort on this) or first 100 of the field sorted by?

[kmstephenson]

Yes, I responded above, sorry it took so long I was looking at the code Has anyone tried using RowNo(TOTAL) as an Expression and using the first 100 rows this way? It fixes the sort issue but just not sure how to show the next 100....