Objects having no data

system · July 12, 2004, 4:55pm

Hi

Is there any way we can hide objects on the fly in report those donot contain data (null).

Please suggest

Thanks
KRG

krgodbole (BOB member since 2003-02-24)

system · July 12, 2004, 5:20pm

You can apply filters using NOT ISNULL() operators to remove the rows with null values for an object.
But if you are asking to hide a column which have all Nulls, I don’t think thatz possible.

mkumar (BOB member since 2002-08-26)

system · July 12, 2004, 5:23pm

Thanks for your reply.

Yes…i meant for hiding column which are null.

Thanks
KRG

krgodbole (BOB member since 2003-02-24)

system · July 12, 2004, 5:24pm

It’s technically possible but an extreme work-around. Dwayne presented some of it at the user conference in Phoenix… it’d take a heckuva lot of if-then statements in all the columns and headers…

JennFisher (BOB member since 2002-06-25)

system · July 12, 2004, 5:41pm

Can you use a crosstab format? It will only show “columns” for data where there are values.

Dave Rathbun (BOB member since 2002-06-06)