Hide Column

system · November 9, 2009, 7:18pm

Hi Guys,

Is there any way i can hide a column only on first day of the month, I searched the forum but i didn’t get any idea. Can anyone please help me out

Thanks
Diggy

Diggydee (BOB member since 2009-08-27)

system · November 9, 2009, 7:37pm

Create an alerter that does this for you. Essentially the alerter would change the font and cell format to transparent when a date is equal to the first day of the month.

SteveBickerton (BOB member since 2002-08-15)

system · November 9, 2009, 8:14pm

Hi Steve,

Thanks for reply, Only font is available for format, I didn’t see Cell for format. Can you please explain me how to make cell transperent. I will be very grateful to you

Thanks
Diggy

Diggydee (BOB member since 2009-08-27)

system · November 9, 2009, 9:00pm

you change the background also notonly font. check in the “edit format” by selecting the cell

rajkiransri (BOB member since 2005-04-07)

system · November 13, 2009, 8:44pm

Can you guys please help me how to make column transparent using Alter, Any hint is appriciated

Thanks

Diggydee (BOB member since 2009-08-27)

system · November 13, 2009, 10:39pm

I am not suggesting alerts.
Put the column end of left-side or right-side.
Select no borders for the cell which you want to hide and with white colour for the border.
Paint the back ground with white colour, select the text colour white.
Try it will works.

Arjun (BOB member since 2008-07-28)

system · November 13, 2009, 11:51pm

To selectively hide the column based on a day of the month, you can use Alerters (which can get tricky if you want alternating row colors) or just use variables and formulas.

Create a variable such as vDayNumber

=DayNumberOfMonth(CurrentDate())

Then for the columns, create a formula like

=If([vDayNumber]=1;"";[yourColumn])

You can do something similar to display the column heading. This won’t change the width of the column, however. The Rich Client manual says “You can
choose to display or hide empty tables, rows or columns” but I can’t find that check box in the properties tab. If you select Autofit Width, the narrowest you can go is 4 px.

charlie (BOB member since 2002-08-20)

system · November 14, 2009, 6:33am

U cannot hide any column in Business Objects . If u want to hide u have tochange cell properties by changing background to white with no borders and font color white

yalisis (BOB member since 2009-07-27)

system · November 14, 2009, 6:44am

You can hide the column in DeskI report

Arjun (BOB member since 2008-07-28)

system · November 14, 2009, 5:29pm

AFAIK, you can’t change cell properties selectively, based on a condition such as day 1 of month, without resorting to the SDK. The OP had a requirement to hide the column on the first day of the month.

Using Alerters or formulas, you can selectively display another object, or even text such as “N/A” or “Day 1” when the condition is met. This doesen’t really hide the column; rather it replaces it with something else.

charlie (BOB member since 2002-08-20)

system · November 17, 2009, 3:11pm

Guys,

I appreciate the time you spent, i used Alert as Charle suggested…it works for me…thanks a lot for your help guys

Diggydee (BOB member since 2009-08-27)

system · November 18, 2009, 1:58am

Good Day,

It seems that you have solved your problem, but for the additional info for those who are looking for some workaround in hiding a column in webi THIS trick might help.

Regards,

-John Vincent

jvmauricio (BOB member since 2009-08-03)

system · November 18, 2009, 6:06am

Good day. Thanks for the link.

Arjun (BOB member since 2008-07-28)