Summarize by count including non existing data on report definition
Hi,
I have a requirement that work items should be displayed as grouped by their status. However non existing work objects for a status should also be displayed on report definition. For this, I created a data type which includes all the possible pyStatusWork value, and I joined my base report with status table. However it only displays existing statuses. As a result I would like my report definition to be displayed as following;
New 1
In Progress 1
Resolved-Completed 0
How can I achieve that ?
Accepted Solution
EIB
PL
Thank you for your comment. I am be able to display non existing data on report definition but it also shows 1 blank column and count as 1. How can I avoid that ? It should be 0.
Edit: Ok I solved the issue. I joined my base report with my status class as right outer. Then I used status.WorkStatus in column to display. Also counted pyID. No need grouping.
Accepted Solution
EIB
PL
Thank you for your comment. I am be able to display non existing data on report definition but it also shows 1 blank column and count as 1. How can I avoid that ? It should be 0.
Edit: Ok I solved the issue. I joined my base report with my status class as right outer. Then I used status.WorkStatus in column to display. Also counted pyID. No need grouping.
