How to specify the constant number of details in table.

Could you please teach me how to control the number of details in the table? What I am trying to achieve is to set some constant number of table-details in each page regardless the number of detail records the database returns.

For exmple, I always want to have 5 record details in the page even if my database returns only 4 detail records. Probably, for the last detail row, NULL value might be inserted.

|HEADER|

1. One
2. Two
3. Three
4. Four
<-- empty Detail Row

|FOOTER|

Likewise, if the Database returns 7 detail records, I will have two pages and each page will have 5 detail records; however, the second page will have only two actual returned values and three details with NULL values.

I am looking for your advice.
Thanks

Find more posts tagged with

Comments

thuston

Well the table rows per page is in the Table Properties - Page Break - Interval.

I'm not sure how you would get the extra rows.
Seems like you should be able to script the DataSet OnFetch to track the number of rows and at the end add 7%5 == 2 rows with blank/dummy values. At least that's how I would have done it in an Actuate eReport.

Kenichi

<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="71868" data-time="1294153620" data-date="04 January 2011 - 08:07 AM">
Well the table rows per page is in the Table Properties - Page Break - Interval. 
 
I'm not sure how you would get the extra rows. 
Seems like you should be able to script the DataSet OnFetch to track the number of rows and at the end add 7%5 == 2 rows with blank/dummy values. At least that's how I would have done it in an Actuate eReport. </blockquote>
 
 
thuston 
 
Thanks for your comments. That gave me great start first of all. 
 
I understood the logic about the dummy/break value, but could you please show me the script on the DataSet OnFetch. Otherwise, that will be great help. 
 
Thanks again.