Rnd() created a random number between zero and 1. Multiply it by say 100, and use the int() function to turn it into an integer. Multiply it by a larger number if desired.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
To add to that, you can create a new formula {@random}:
rnd()
Add this to your detail section, and then use it as your sort field. You can then suppress (for example) all but the first record and you will have a randomly selected record.
Each time you refresh though, the formula will change and a different record will appear.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.