I'm creating report (CrystalReport X) which is showing stock of different warehouses. Warehouse is a parameter introduced by user and also is grouped by warehouses. As a condition is that only items, which Balance is more than 0, are appearing (so as a Record Selection formula I have Balance>0). As a result, if there is warehouse which all related items have Balance=0, he is not appearing, even not just with no records.

So is it any easy method to project such a group anyway, for example with message "No records/No items for this warehouse."

 

I was looking in the internet for sth like that but I couldn't find. I thought also about using condition RecordNumber=0 but I have no idea where and how to use it.

 

So thank you in advance for any help.

 

Lukas