Limiting Rows in a Straight Table

[#1]

Hi - this is probably a very newbie question, but I have a straight table  that has over a million rows.

How can I limit the table to only show the top 1000?

[#2 · Accepted solution]

Hi,

    if you are using Straight table,go to "Presenation" tab there you can see radio button will help you to show no of

rows,it deponds on your "Expression" values. And also by using "Sort" tab you can select Top N "Max" or "Min"

values...

-Jen

[#3]

Thanks - would you be able to help me with the code? Select top(1000) ... ?

See screen shot attached as well..

[jagan]

Hi,

The image you attached is using Table Box not a Straight Table.  In Straight table you have the option of setting the number of rows to be displayed.

Regards,

Jagan.

[#5]

Found it - thanks!

[krishnaroopa]

But the option available is to display only 1-100 records?

What is purpose of "Show others Row".

I have 10,00,000 and need to display in sets of 10000 with previous, next buttons,,, is it possible.

Thanks

KRS

[#7]

Has anybody found a straightforward solution to this?

- for example, loading a table page by page, each page being x rows