Straight Table Dimension Limit

[#1]

Dear All,

I have a straight table with 40 rows.

The dimension limit allowed me to display 'FIRST' N number of row. but i would like to find out is there a method to specify to display row 30-40?

[tresesco]

Hello,

Row number changes with sort order and selection, so my idea would be to use rank() function as in the attached file.

PFA

[#3]

now i have the row number in the table. 'NOT THE ROWNO AT RUNTIME'

already given in table

row number should put under dimension or expression??

For example i want the straight table to show only the row number from 20-30

Please refer attached

thank you

[#4]

Hi,

Use the calculated dimention for the field rowno1 as below.

=

if(rowno1 >= 20 and rowno1 <= 30, rowno1

)

[tresesco · Accepted solution]

PFA

Update: you can simply write the calculated dimension as

=

If(rowno1>9 and rowno1<31,rowno1)

with the 'Supress When Value is Null' checked

[#6]

Hi. Dont mind can you use my product.qvw to show me? Cause i don't really understand

One i added in the things.

the result shown in the table below

[#7]

Hi Tres,

Just a quick one. If the rowno1 row is not exist in the table.

Any way for us to specify display the first 30 records based on alphabetical order or the employee name?

[tresesco]

Set the sort order based on Alph order/Employee (Sort tab), then limit the rows in the dimension limit tab. right?

[#9]

ok.. but the dimension limit can set range. Am i right? It can either first, largest, smalles. or specify the value.

Is it allowed specify the range like record 30-40?

[tresesco]

If rank() function can't be used as i showed in my first post here, i guess you have to create a field in the script and use that for the same. Script would look like:

Load

          rowno() as Row,

          Employee

From  <> Order By Employee;