Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Page Wise Straight Table & Associated List box with Rank Function

Dear All,

I have data of Targets , I want to display this data Page Wise ( Page 1,2,3,4.... etc)  and list box associated with straight table records using rank function.

Please can any one help me to achieve the same.

Thanks in advance.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Vikas,

Check this link below

Paging Implementation for Straight table


Hope it helps you.


Regards,

jagan.

vikasmahajan
Author

Thanks Jagan  I have 13 records per page will group with 13 work with your solution ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
jagan
Luminary Alumni
Luminary Alumni

Hi,

Change the script like below

LOAD [IP Address],

     [1WK],

     [9WKS],

     [07WKS],

     div(rowno(), 13) + 1  as Group

FROM

\\TB01_20120927_110402.xls

(biff, embedded labels, table is Sheet1$);

Then it work as you expected.

Regards,

jagan.