1 Reply Latest reply on Jun 3, 2015 3:40 PM by philmodjunk

    Reducing number of found set



      Reducing number of found set



      i want to sort my records based on "three(3) of the most active customers", note..(i can sort my data by the most active customers but then i want to be able to only have 3 records in my found set. How do i achieve this.?

        • 1. Re: Reducing number of found set

          Once you have sorted the records so that the ones you want to keep are at the top of your found set:

          Go to Record/Request/Page [ 4 ; no dialog ]
          Omit Multiple Records [ Get ( FoundCount ) ; no dialog ]

          Note: any number = to or greater than the number of records from record 4 to the end of the found set will omit that record and all that come after it in the found set so Get ( FoundCount ) will always be a number large enough to work.