I have a db that contains list of clients assigned to specific staff. Our audit team needs to randomly select a number of records on a period basis. I can run this report in SQL using the below code. I want the user to be able to run a Crystal Report. Any suggestions?
Select Top (5) percent cclientid, csalesrepcode
Order by Newid()