Show Count as Zero in Level Break Footer even if no Rows Exist

Rauf

VIP Member
For a number of B/P, I have items with specific category. The category list is from a UDC. So to get count of items by category, I use level break footer.
So the data sequence is B/P, Cat. Code.
The output look like,
Code:
Branch/Plant 1
	White	20
	Black	30
	Red	10

Branch/Plant 2
	White	80
	Black	100
	Red	1
Now, for example, if no rows exist for category 'Black' for B/P 1, it will not be printed.
The output will be,
Code:
Branch/Plant 1
	White	20
	Red	10

Branch/Plant 2
	White	80
	Black	100
	Red	1
How can I print this category even no rows exist ?

I need the following output
Code:
Branch/Plant 1
	White	20
	[b]Black	0[/b]
	Red	10

Branch/Plant 2
	White	80
	Black	100
	Red	1
 
Last edited:

DSauve

Legendary Poster
Your report is likely breaking on the category code in the data record. Try changing the level break to be based on the UDC record instead, and then sum up records within that (maybe another level deeper or through ER code).
 

Rauf

VIP Member
I hope I can do left outer join F0005 with the table in subject. And in the data selection I will select only the UDC code of color (55/CO)
 
Top