| Report Viewer [message #200090] |
Thu, 09 November 2006 21:14  |
Eclipse User |
|
|
|
Originally posted by: brad.lwsi.com
I have a report displayed in the Report Viewer. There are about like 100
records generated. How can I set it to display only 10 records at a time
in the listing? So in other words, there would be 10 pages of 10 records.
Thanks!
|
|
|
| Re: Report Viewer [message #200114 is a reply to message #200090] |
Fri, 10 November 2006 01:37  |
| Eclipse User |
|
|
|
Originally posted by: jjdscss.fastmail.fm
On Thu, 09 Nov 2006 21:14:03 +0000, brad wrote:
> I have a report displayed in the Report Viewer. There are about like 100
> records generated. How can I set it to display only 10 records at a time
> in the listing? So in other words, there would be 10 pages of 10 records.
>
> Thanks!
I tried it using the Page Break Interval in the Table Property
but it didn't work.
The solution that worked for me was to add a new computed column
with the expression row["0"]/10. This creates a column with the
value 0 for the first 10 rows, 1 for the next 10 rows, etc.
Now you can use this new column as a group. Just set the page
break after group "Always Except Last" to make force a next page
after every group. This technique also allows you to have
page subtotals.
|
|
|
|
| Re: Report Viewer [message #200198 is a reply to message #200174] |
Fri, 10 November 2006 11:31 |
| Eclipse User |
|
|
|
Originally posted by: jgngo.yahoo.com
To do break a page by a certain number of rows, you need to do the
following steps:
1. In the Bindings tab of the table, add a new data binding with the
following parameters:
Name: pagenum
Data Type: Integer
Expression: row[0]/10
The value is 10 because we want to break a page by 10 rows each.
2. In the Groups tab, add a new group with the following parameters:
Name: GroupByPage
Group On: pagenum
Page break After: Always Excluding Last
That should give you the desired result.
|
|
|
|
Powered by
FUDForum. Page generated in 0.06281 seconds
] 
Search
Help
Register
Login
Home
