Freezing columns and rows in Web reports

[Former Member]

Hi Gurus,

We are trying to freeze the scrolling of first two columsns and the first row for a web report. Could you please guide me how can we do this for a analysis web item.

Appreciate your help.

Thanks

Raj

[Former Member]

Below is a working prototype of what your are looking for -

Cheers, Joe

<style type="text/css">

div#tbl-container

table {

background-color: WhiteSmoke;

}

div#tbl-container table th

thead th, thead th.locked {

font-size: 14px;

font-weight: bold;

text-align: center;

background-color: navy;

color: white;

border-right: 1px solid silver;

position:relative;

cursor: default;

}

thead th

thead th.locked {z-index: 30;}

td.locked, th.locked{

background-color: gold;

font-weight: bold;

border-right: 1px solid silver;

left: expression(document.getElementById("tbl-container").scrollLeft); /* IE5+ only */

position: relative;

z-index: 10;

}

div#tbl-container td {

font-size: 11px;

border-bottom: 1px solid silver;

text-align: center;

border-color:#787878 ;

padding: 2px 5px 2px 2px;

}

</style>

[Former Member]

This is possible with SPS 13 only in BI 7.0.

Use the property USE_SCROLLBARS.

http://help.sap.com/saphelp_nw70/helpdata/en/76/489d39d342de00e10000000a11402f/content.htm

[Satyabrata_Basu]

Hi Deepu,

Is it possible to freeze header row and certain number of Left-most columns while Scrolling through the report in SPS13 (using Scrollbar) ?

We are looking for Freeze-pane functionality in WAD (BI Web report) similar to Excel.

Thank you !

Satya.