Can we limit the report page to display only 10 rows?

system · April 14, 2011, 10:45am

Hi,

Can we linit the report page to display first 10 rows in the page No 1 and next 10 rows in the page No. 2 so…on in Web Intelligence.

Thanks.

jayad (BOB member since 2008-07-11)

system · April 14, 2011, 1:25pm

I think we can not set the rows per page

Please refer the link below

http://forumtopics.org/busobj/viewtopic.php?t=140142&sid=1a9a2ca956f4106a75ba60aa1f5778f9

kolla99 (BOB member since 2005-11-15)

system · April 14, 2011, 10:01pm

You sure can!
Go to the properties of the Page and you will find “Vertical Records per page” option under the Page Content. You can set it per your requirement.

Thanks,
Sowmya.

sowmyabatchu (BOB member since 2009-10-14)

system · April 15, 2011, 12:22am

I don’t think this will work. Don’t think you can set it to less than 100, and it only applies to Quick Display Mode.

weaver (BOB member since 2008-10-17)

system · April 15, 2011, 4:36pm

Thanks Weaver!
I should have tried if that setting even works for less than 100
Learnt something new!

Thanks,
Sowmya.

sowmyabatchu (BOB member since 2009-10-14)

system · April 15, 2011, 9:25pm

Yes, we have a work around

[var1]=Floor(RowIndex()/10)

Include this variable in your report and apply break on it and go to properties-> Page layout section and turn on start on a new page.

Thanks,
Zaif

zaif235 (BOB member since 2010-06-15)

system · April 25, 2011, 11:46am

Thaks zaif
It works well.

kolla99 (BOB member since 2005-11-15)

system · January 11, 2012, 8:25pm

Hi,
I am beginner.
Can you help me? Where shall I insert - [var1]=Floor(RowIndex()/10)?

Thank you for your help

hanz008 (BOB member since 2012-01-04)

system · January 11, 2012, 9:00pm

Welcome to B:mrgreen:B!!

Insert the new variable in the report block where you want to limit the rows.

Thanks,
Zaif

zaif235 (BOB member since 2010-06-15)

system · February 1, 2012, 7:03am

Hi Zaif

I tried this function but if there are 22 records in all first 4 pages it display 4 records as desired but last 2 pages it displays 3 records However it shud be first five pages needs to be dispalyed as 4 and the last one shud display 2 records its because of round off can we work with some other function

county (BOB member since 2011-08-04)

system · February 1, 2012, 7:51am

Hi Zaif

I tried this function but if there are 22 records in all first 4 pages it display 4 records as desired but last 2 pages it displays 3 records However it shud be first five pages needs to be dispalyed as 4 and the last one shud display 2 records its because of round off can we work with some other function

county (BOB member since 2011-08-04)

system · February 1, 2012, 9:09am

Hi, How many rows you want limit the report page to display?

Thanks,
Zaif

zaif235 (BOB member since 2010-06-15)

system · February 1, 2012, 9:18am

4 records per page.Its not a requirement but was trying how to get rid of it.As floor function is giving an integer value so its rounding off .I tried with ceil function too but it gives 1 record on the first page later on it displays 4 records.It needs to be sorted out with some function.I f you got this sorted let me know i am also doing R & D on it.

Regards,
Princy kHandelwal

county (BOB member since 2011-08-04)

system · February 1, 2012, 6:08pm

That is how it works if we use Ceil . This one will work.

[var1]=Floor(RowIndex()/4)

Thanks,
Zaif

zaif235 (BOB member since 2010-06-15)