I have a monthly report that gives back used parts that month.
I wanted to give a montly report that groups the part number so we can easily see how many parts x are used that month.
Problem now is that the first date field is set to monthly, the second group field is set to partnumber, but the report makes difference for every day (standard mysql sorting) , but if 2 days after that someone used the same part it is not grouped by eachother. I can mail you an example if you want. Is there a way around to this problem ?
Someone is ordering the used spare sparts after each month so it would be easier to retrieve this information.
Someone have any suggestions ?
Kind Regards
Ewold