Random Record Selection
I have a report where I would like the system to randomly make a selection of 20 records within the parameters I have set
Is the possible and if so how do I do it?
Is the possible and if so how do I do it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well, not sure is this is giving me the first 20 records rather than a random selection
ASKER
I think the issue may be that I cannot sort by @Random_Number
It does not appear in the sort options
It does not appear in the sort options
Sorry, change
WhilePrintingRecords;
to
WhileReadingRecords;
WhilePrintingRecords;
to
WhileReadingRecords;
ASKER
Ok have changed it and I think all good now
ASKER
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
Customer-Survey-Data.rpt
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
Customer-Survey-Data.rpt
ASKER