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