BusinessObjects Board

Display records where object is blank

I have a report with a prompt for Owner, but sometimes the Owner is blank. How can I select all those records where the Owner is blank?


TrevR :uk: (BOB member since 2014-03-05)

Is this really a Deski question? Do you want to select something from the prompt to allow you to choose null owners or do you just want them always to appear?


Nick Daniels :uk: (BOB member since 2002-08-15)

I think it’s a Deski question as I’m working in Deski, but sorry if I’m wrong.
I am wanting to select Null from the prompt, I do not always want them to appear.


TrevR :uk: (BOB member since 2014-03-05)

Found the answer: Owner Is Null
Which I’m sure you all knew all along!


TrevR :uk: (BOB member since 2014-03-05)