How to design Cognos interactive reports 14 - Make report freeze column

Check list of all posts

Again, space is very important for interactive reports, as business users will look at data on screen. How to make report be user friendly is a very important topic. Freeze column is very useful when there are many records. This idea is actually from IBM (http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page641/index.html?ca=drs), and added here to provide us a comprehensive concept of interactive report in this context. Please see attached report specification for review (version 10.2 with sample Package GoSales)

<style>

.freezeCorner{

font-weight: bold;

vertical-align: top;

text-align: center;

padding: 4px 5px 4px 6px;

background-color: #FFFFFF;

color: #444444;

border: none;

top: expression(parentNode.parentNode.parentNode.parentNode.scrollTop-1);

left: expression(parentNode.parentNode.parentNode.parentNode.scrollLeft);

position: relative;

z-index:10;

}

.freezeRows{

vertical-align: top;

padding: 4px 5px 4px 6px;

background-image: url(../reportstyles/images/silver_grad.png);

background-position: left top;

background-repeat: repeat-x;

background-color: #E7E5E5;

color: #333333;

border: 1px solid silver;

left: expression(parentNode.parentNode.parentNode.parentNode.scrollLeft);

position: relative;

}

.freezeColumns{

vertical-align: top;

padding: 4px 5px 4px 6px;

background-image: url(../reportstyles/images/silver_grad.png);

background-position: left top;

background-repeat: repeat-x;

background-color: #E7E5E5;

color: #333333;

border: 1px solid silver;

top: expression(parentNode.parentNode.parentNode.parentNode.scrollTop-1);

position: relative;

}

</style>