I am trying to create an employee cash out report that will allow for paperless reporting. The issue that I am having is that the finance department has asked that the denominations being dropped are showing on the report and not just the total amount. Is there a way to achieve this?
For example if the amount of cash to be dropped is $100.00. Is there a way for Crystal to determine that the employee should drop 5 $20's?
Using Crystal XI

Edited by Brenmac - 20 Jan 2018 at 6:35pm

At this point no. What I am planning on doing is having the employees enter their cashier ID into the parameters, which will pull all of their transactions for the day, and also enter their float count into the parameters ( 10 $5's, 20 $10's etc.). If their drop for the day is $100 but all they have is 5 $20's then obviously we don't want them to empty their float of $20's. Is there a way for CR to distinguish what would be the best option for the employee based on what is in their float?

Thank you for the input. I have started out with a few if then formulas and it seems to be working at this point.

Thanks again for your help.