Report on Null Values

[Yeseniah]

Hi.

I would like to run a report that pulls all the records that do not have any data. To be more specific, I am running a report on user activities, for those that were assigned a date prior to current date AND do not have a complete date in {COMPLETEDATE} field, I would like to see the activitiy list. Does someone have an idea of what I am missing? Current formula without parameter is:

{PICKLIST.TEXT} <> "Closed" and
{TICKETACTIVITY.ASSIGNEDDATE} < CurrentDate

Thanks.

 

[lbass]

Not sure how the picklist fits in, but try:

isnull({table.completedate}) and
{TICKETACTIVITY.ASSIGNEDDATE} < CurrentDate

-LB

 

[Yeseniah]

Picklist was so that I was only looking at open tickets, however took that out to test formula...

isnull({TICKETACTIVITY.COMPLETEDDATE}) and
{TICKETACTIVITY.ASSIGNEDDATE} < CurrentDate

This gave me a report with no data. I'm testing the report and made a point to enter a record with missing Completed Date, so am sure this exists in database. Thank you for taking the time to look at this.

)Yesenia

 

[lbass]

Go to file->report options and see if you have left "convert null values to default" unchecked. If not, uncheck it. Then try:

(
isnull({TICKETACTIVITY.COMPLETEDDATE}) or
trim({TICKETACTIVITY.COMPLETEDDATE}) = ""
) and
{TICKETACTIVITY.ASSIGNEDDATE} < CurrentDate

-LB

 

[lbass]

PS. If you are using more than one table, then you should be using a left join from the table that has all records to the one that might have the null completed date.

-LB

 

[Yeseniah]

THANKS so much!! Works perfect!

) Yesenia