Useful tip here on the IBM website about changing the default number of rows and columns that appear before paging takes affect:
http://www-01.ibm.com/support/docview.wss?uid=swg21461148&myns=swgimgmt&mynp=OCSS9RXT&mync=R
Blog of IBM Cognos TM1, Cognos BI, Cognos Express, CDM and other related stuff.