Choosing every Nth record to create a "random sample"
Posted on 2013-01-28
Is there a way to chose every Nth record in Crystal Reports? I need to perform an audit where I need to generate a sample population from over 22,000 records. I would like to create a formula that only displays every 35th record in order to create a sample size of closer to 640. I need a sample from all parts of the records, so the Nth percentile, or Nth smallest or largest wont work. I have done similiar things in Excel, but I am asked to do this a lot and I would like to do it in Crystal with out exporting it. Any help would be appreciated. I am using Crystal Reports XI.