Hide a column in BPS layout ?

[Former Member]

Hi,

Is it possible to hide a column in a BPS layout (Web Excel) ?

When I hide a column in the layout definition, saving it resets the hidden column.

Any idea if it will be included in a future release ?

Thanks

[Former Member · Accepted solution]

Do you mean the 'Publish for web' setting ? I tried and did not work ?

I am on SEM 3.1B

[Former Member · Accepted solution]

david,

there is an icon in the third screen of the layout definition (similar to a puzzle, orange and blue) to on the right.

alessandro

[Former Member · Accepted solution]

When the 'always fit to column' indicator is unselected, you can save the hidden column ok. However, when you execute the layout, the hidden column is displayed.

Thanks

David

[gerd_schoeffl · Accepted solution]

Hello David,

For technical reasons whenever you hide a column in Excel the system will expand it again - just as you have noticed. The only way to get around this is to use Excel macros (in GUI) or Java script in the Web Interface.

Best Regards,

Gerd Schoeffl

SAPNetWeaver RIG BI

[Former Member · Accepted solution]

Hi,

Have you an example to hide a column in web thanks to Java ?

We have to do it but we don't know how.

Regards

[Former Member · Accepted solution]

Boujema,

don't hide the coloum but post lenght eq '0'.

alessandro

[Former Member · Accepted solution]

Thanks for your answer.

What do you mean by lenght eq '0' ?

In the web interface, I cannot interfere directly on the columns of a layout. Is there a specific code to include in a text component ?

regards

[Former Member · Accepted solution]

boujema,

you create your layout from bps0?

alessandro

[Former Member · Accepted solution]

Alessandro,

I create in BPS0 all the customizing I need (functions, layout...). After that, I create a web interface with these components (variables, functions, layout).

That 's why I wonder what could be the java code to hide a column in web interface.

regards

[Former Member · Accepted solution]

boujema,

in bps0, in your layout, your coloumn doesn't have to be hidden but with widht zero.

alessandro

[Former Member]

David,

when you hide a column in layout definition you must to flag the option that not modify the coloumn.

alessandro