I have a report that shows ticket numbers and who created the calls. Is there a way to write a formula to take a random sample for each person that logged the ticket. I am trying to do an audit for the people that log the tickets. So i want to take 5 random tickets created by them. Is this possible in crystal reports?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
random formula
- Thread starter draacor
- Start date
Yes. Adapt the approach described in my FAQ to your situation: faq149-3261
- Ido
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Ido
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #3
Thanks for the information. I seem to be having a problem though. When i do the formulas the way you describe it only give me 5 total records at random, is there a way so that for each agent it does 5? Right now i am grouping by the agent who logged the call, i want to be able to show 5 tickets for every agent.
Adapt the logic to "within group".
- Ido
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Ido
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question