The count shows non zero value in reports on a table created using 'Database view'

Rama Chandra D
Kilo Guru

Hello everyone,

I have created a 'Database view' to join Problem and associated Problem task table to run a report that displays all the open problems along with their tasks if any. The Database view runs well so does the report. However, when I group the report using 'Problem Number' it shows the count against each problem with no tasks as '1' and when expanded it shoes 'empty' in all the fields. I was expecting that count would be zero if there are no tasks associated with the problem.

Is there any way, I can avoid the misleading count of '1' when there are no tasks?

Regards,

Darshak

1 ACCEPTED SOLUTION

Yep. To be clear, going back to your question



Is there any way, I can avoid the misleading count of '1' when there are no tasks?



the answer is NO - the "1" is by design, since when you use a LEFT JOIN, there's always 1 record for Problem even if there's no tasks.


View solution in original post

11 REPLIES 11

Yep. To be clear, going back to your question



Is there any way, I can avoid the misleading count of '1' when there are no tasks?



the answer is NO - the "1" is by design, since when you use a LEFT JOIN, there's always 1 record for Problem even if there's no tasks.


Would you mark our replies as Helpful / Answer as appropriate? Thanks.