Hi,

How do I include items with a null value in my reports?  I am bringing back information on a certain number of variables.  But I want to show an item that meets the conditions even if the value of the item is zero or null.

CR will not truncate records with null values, so I dont see the problem with displaying them. Is it the query that doesnt rerturn all records you want to include. Do you join your tables in your query? A little bit more info can be helpful.

____________________________
If you find the answer helpful, please mark this topic as solved.

The only way to give you more information is to describe the whole report. The report is based on our IT helpdesk records. With the company being so large, each call that is logged to the helpdesk is assigned to one of ten assignment groups (departments). I want to see how many calls each assignment group has in its queue at any one time and how many they have resolved each month. If that assignment group doesn't have any calls currently in its queue, I would like to have zero next to that assignment group. With the current set up, any assignment groups that have null values are missing from the results. I have used the selection expert to list the assignment groups that I would like to appear in the report. But it only shows those assignment groups that have values against them.

But you didnt say what is the SQL statement that is generated by report, what are table structures that are used in report, cause I think the problem is how do you create relationships with tables.  For instance, lets say you have two tables Departement and Calls. If CR linked these two tables with INNER JOIN command, you wont see any Departement that doesnt have any call, or to be more precize, departements whose primary keys dont exist in Calls table (as foreign keys) will not be shown. you need to create this kind of relationship

Departement LEFT JOIN Calls

____________________________
If you find the answer helpful, please mark this topic as solved.