Filtering and Paging through Data

rbowles — Thu, 22 May 2008 02:53:14 GMT

I posted this earlier but have not received a follow up to my last post so I am posting it again.

I am cutting and pasting from Greg Collins Paged Master-Detail Table to get my idea to work. What I want to do is to have some icons that will advance the data forward and backward. I am having trouble getting the filter to work. Here is the layout from Greg’s DB.

Page(secondary)
    NumberOfRows
    StartingRows
    ShowFullLastPage Here are the filters
position() >= xdXDocument:GetDOM("Page")/Page/StartingRow andposition() < xdXDocument:GetDOM("Page")/Page/StartingRow + xdXDocument:GetDOM("Page")/Page/NumberOfRows  Here is my layout.

Main(primary)
        TOTALS
            NumberOfRows
            StartingRows
            CashApp
                Field1
                Field2 etc

My question is how do I modify the above filter to work on my layout? In gregs example he was filtering the master record on a secondary source. Iin mine I want to filter the detail as indicated by Cashapp and the fields below it.Mine is on the primary Datasource and I have no secondary.

A secondary question I have is my data loads rather slowly. Will setting it up with a filter and the ability to page through my data improve speed?

Thanks in Advance Randy

General

Filtering and Paging through Data