I run in Details A with information on open or closed reports, and I show in Details B the report # if it is equal to "Open" or "In Process", so I created a formula and it is the only item in Details.

 

If {command.Status} = "Open" or {command.Status} = "In Process"
Then {command.JobID}

 

So this shows the report # (command.JobID) if it is "Open" or "In Process", but it shows a 0 if is is not "Open" or "In Process". Is there anyway for it to not return anything so I don't have rows of 0's? Else NULL does not work.

 

So what I tried to do was go into the formula editor for Surpress, and use:

 

IsNull({command.JobID}) or {command.JobID}=0

 

but this is not surpressing Details as I still get a 0 for a row.

 

Can anyone help me to not show a 0 on a row?

 

thanks

 

EDIT:

The simple way of saying this is I have two details sections A and B, A has all open and closed info, but I just want 'open' info to show up in deatails B.

 

How can I do that?

 

thanks! 

 

 

{command.Status} = "Open" or {command.Status} = "In Process"

 

This should suppress the entire section if the status is not Open or In Process.  If by chance it suppresses the section for the other statuses instead of Open or In Process, try unchecking the Suppress checkbox.

 

-Dell