I would like to get the department totals to list just like they do in a Batch close when a Z Reports is taken at the close of the day in a Crystal Report format.
I want all the departments listed and not just the ones with sales dollars grater then $0.00.
I have setup up a department report in report Crystal Report based on closing time for all closed batches.
This is my what I have in my formula editor @DepartmentName
IF IsNull ({Department.Name}) OR Length({Department.Name}) = 0 THEN "Unknown" ELSE {Department.Name}
Open to any suggestions. Report works but not listing all the departments. Only the ones with sales for that closing time.