Filter and paging through data - InfoPath Dev
in

InfoPath Dev

Filter and paging through data

Last post 05-21-2008 06:15 AM by rbowles. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-20-2008 09:28 AM

    Filter and paging through data

    Reply Contact
    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   
        datafields   
                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 in mine I want to filter the detail as indicated by Cashapp and the fields below it.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 AdvanceRandy

     

  • 05-20-2008 10:02 PM In reply to

    Re: Filter and paging through data

    Mark as Answer
    Reply Contact

    With 2007 you can right click a field in the dat source and copy the xpath to get the exact syntax to the field.

    As far as performance, by default a secondary data source cannot be queried. You have to load the entire data set and then filter it within InfoPath.

    This can often be an issue with large data sets.

    Best practice is to use web services so that you can dynamically query with secondary data sources.

    So unfortunately, no, performance will not improve other than if you hide the data in the view by default which can speed up the page display but not the data load.

    Clay Fox / Microsoft InfoPath MVP

  • 05-21-2008 06:15 AM In reply to

    Re: Filter and paging through data

    Mark as Answer
    Reply Contact

    How would that work in 2003.  That is what I have.  I do not have a secondary data source in mine.  I have only one how does that impact performance.

     

    Thanks 

    Randy
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.