Cognos Report Studio and prevent page breaks in HTML report

I made reports in IBM Cognos Report Studio, version was 10 but it has only slight changes compared to version 8. (If you are new with Cognos you might wonder if I have typed number wrong but I haven't because previous version was 8.) Software was in Finnish and that makes it sometimes more difficult to find the right settings for objects's properties because translations can be so weird sometimes and use terms wrong. I wrote these instructions here because for me these settings weren't logical.. :) This page break example picture has Finnish texts.

Desired report layout had crosstab first and after that a couple of graphs and these all had to be in one HTML-page without page breaks.

At first I set rows per page number for the crosstab big enough to prevent page break then I checked that all possible properties which could affect to page breaks.

[ 1 ] Go to File / Tiedosto and in the Report Properties / Raportin ominaisuudet menu set ”Page break by data container for interactive HTML” / ”Tietosäilön sivunvaihto vuorovaikutteiselle HTML:lle” à Yes (default setting is No)
[ 2 ] Deselect ”Paginate saved HTML output” / ”Sivuta tallennetut HTML-tulokset” --> OK.

Report Properties

* Here is updated picture of the properties in English. (Report Studio version is 10.2.2). Instructions above still apply :) (pink spots in the pic)

Bottoms up! Finally simple bottomN report is working

I had difficulties to create simple Top N or Bottom N report in SSRS but finally it's working :) ! Here's the example how use bottom N filter in a tablix report. In this case I wanted to have list of the oldest jobs from the database table and the prompt where user can choose how many records are shown in the list.

[ 1 ] I made Report Parameter p_bottomN that is Visible to user.
[ 2 ] In its properties Available Values tab I specified values 5, 10 and 20 for user to choices. Label and value were both same. In Default Values tab I added value 5.
[ 3 ] Then in report's Dataset Properties and Filters tab I added filter:

• Expression [JobDate]
• Operator Bottom N
• Value [@p_bottomN]

Report looked fine when previewing it an I even didn't need to pre-order my data in dataset query. But after I deployed the report to the report manager, publishing site - bottomN prompt wasn't visible and default record amount wasn't 5. This was because at first I had this parameter hidden and default value was 10. Problem was solved in report manager. I looked to report's properties and parameter tab where I needed to put this prompt visible and change the default value.

Report Manager - Parameter tab.