Hiding of columns in Web I

system · September 24, 2008, 4:21pm

Hi,

I took cross tab , I applied formula to each cell(Varies for each cell). If any cell have no data for the formula then I should hide that cell…!!

Is it possible??

Can you please help me…

Thanks

BOCP (BOB member since 2007-07-02)

system · September 24, 2008, 4:23pm

You may be able to test for nulls and white it out with an alerter.

The details you have given are quite sparse, so I’m unable to elaborate further…:).

Mak 1 (BOB member since 2005-01-06)

system · September 24, 2008, 4:29pm

Ok…!!

Let me explain clearly::

I applied formula to a cell like follows:

=Sum(If(=“US” and =“2007”)then )

If the formula results “” then am getting cell with no data. I should hide this cell if it contains no data.

I think its clear and you understood…!!

Thanks

BOCP (BOB member since 2007-07-02)

system · September 24, 2008, 4:36pm

Hi Kishore,

As Mak said,

Create an aleter.
Define the condition as when the Sum(…) is null
Then, define format section.
To hide the column make the border as None and set the color as the background color of your report.

GowthamSen (BOB member since 2006-08-31)