Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should display max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible...

ASHOK KUMAR GUNTUPALLI

• Jun 14th, 2012

1.Drag a list report 2.Add the query items you need for the list report 3.Add a Query Calculation to the list report and name it as Running total,In the Expression Definition Type in running-count...

Ashish Sharma

• Apr 17th, 2012

Instead of doing this at cognos level, try to do it at SQL level using rownum function. Take the max of mod(rownum,5). then save the rownum value in a ?variable? and then take all the records where rownum>? Variable?

Answer Question  Select Best Answer