Ashish Sharma
Answered On : 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?
Login to rate this answer.
ASHOK KUMAR GUNTUPALLI
Answered On : 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([Query Item])
4. Add a Query Calculation to the list report and name it as Rows Display,In the Expression definition type in
floor([Running total]/17)
5. Go to the page Explorer and drag the page set to the page are
6. Change the Query of the page set to your list query
7. In the properties of the page set,click on the ellipses of sort and grouping
8.Drag the Row Display data item under grouping
9.Save and run the report.
Login to rate this answer.