Hide a Column which has Customised Headear

I have a column which has a customised user friendly Column Header . Now as per my requirement, user will do the Hide/Show on this Coumn.
Isuees are:

  1. Customised Header spanning across 2 rows then while hiding Datas goes off but not the Header ? Any solution .

  2. When unhide the Column, it showz the default Header rather than the header which I have given. Any Soution.

Any Ideas on these issues how to implement.

I guess this is not possible, just checking if anyone have come across like this.

Thanks


vikas :us: (BOB member since 2002-12-04)

Try:
Create a new local report variable, name it like you want the column header to be named. Use this variable to create your table.


Andreas :de: (BOB member since 2002-06-20)

Yeah it would be nice if there were functions for this - show/hide column and column name - but alas , I think not. Maybe someone else has an idea

But Andreas - if you hide a column thru pivot and then show again, the column header reverts to Name of …

edit 2 - wait I see where you are going. yes - simple solution it is.


scott copeland (BOB member since 2002-08-15)

Scott, should it not work if I use the local report variable instead, name it the way I want and add it to my table? I tried it and it works for me…


Andreas :de: (BOB member since 2002-06-20)

yes of course - I read thru too fast. A very simple solution - the kind I like. :lol:
Hopefully it works for Vikas and their user.

I was trying to think of show/hide functions or workarounds . . .


scott copeland (BOB member since 2002-08-15)

But what if I have to display the Column Header in 3 Lines … same way user wants to see
something like we have a Amount field
so User wants to see it like this

Amount
($)

 3.02
 4.33
 5.5
 ....
 ....
 ....
 ....

Hopefully I am clear in saying


vikas :us: (BOB member since 2002-12-04)

I don’t think this will work on multiple header lines or crossing more than 1 data cell. Maybe you could get fancy trying a table or free cell outside the main table and then aligned to be just above so it looked like a header - or something. Without seeing the report and knowing what you are doing, it’s hard to come up with any other ideas.


scott copeland (BOB member since 2002-08-15)