Randon selection of records

I had this question after viewing Random Record Selection.

I thought this was working ok
I have 2 sites that need to use this report
One seems to work ok the other only returns 6 records instead of 20
Any ideas
Have included the rpt file
Gordon HughesDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If this is the problem report, then it looks like you put it on correctly

If you take the suppression off how many records do you get?
Just trying to make sure you are getting at least 20 records with the selection criteria.

Also unsuppress the random number and make sure it is returning values


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gordon HughesDirectorAuthor Commented:
Hi Mimcc
If I remove the suppression I get lots of records for GRH but still only get 6 for HULL-RI
Had a look at the data in the database and cannot see any issues
Gordon HughesDirectorAuthor Commented:
Hi Mimcc
Think I have sorted it. Changed the linkage
Gordon HughesDirectorAuthor Commented:
Great support also right
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.