Crystal Reports Department Sales how to show all departments listi

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.

Reply to
fabiano
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.