Topic: Display zero count Posted: 19 Jul 2010 at 10:19am
I am working on a report that counts registrants for a particular event.
Currently we use a parameter that allows for multiple inputs by a job code. the goal of the report is to break down the number of registrants by their job code.
the job codes are in number format, and idea results would be something like this:
I need zero registrants to show on the report. But since the sql doesn't return any registrants with those job codes for the particular event the group feature doesn't know they exist. I just can't for the life of me figure out a way around this. I'm sure this has been done a million times before. Let me know if you need any more information.
count(jobcode) doesnt work. It doesn't count anything if nothing is returned. so it doesn't even really know that there were parameters passed in that aren't returned.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 19 Jul 2010 at 10:37am
there has to ea a row with NULL in it in iorder for the job code to appear as your sample does, correct?
if you change the report setting to use default values for null or in a formula field you can change that setting for only that formua.it will return 0 instead of nothing
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum