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:

JOB CODE                      REGISTRANTS
100                                        22
200                                        0
201                                        5
202                                        0
301                                        18

But the only thing i can get is

JOB CODE                      REGISTRANTS
100                                        22
200                                        5
201                                        18
202                                       
301                                       

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.

or are you using a sub report?

ah, that is obviously different. I assume you that the value under count is from a subreport linked on a job code.

in the report set up you can set it to use defualot values for all suammry types.