Repeat Group 2 per page

I have a table with a group. I can set RepeatOnNewPage = true on the group
properties to have it page break for each item, but is it possible to put 2
items and then a page break?
ThanksOn May 2, 10:52 am, AndyG <A...@.discussions.microsoft.com> wrote:
> I have a table with a group. I can set RepeatOnNewPage = true on the group
> properties to have it page break for each item, but is it possible to put 2
> items and then a page break?
> Thanks
This might work:
1. In the 'Layout' view of BIDS, select the table.
2. Right click the table and select 'Properties.'
3. On the 'Groups' tab, select the 'Add...' button.
4. Below 'Group on:' and 'Expression' enter the following:
'=Ceiling(RowNumber(Nothing)/2)'
5. Select 'Page break at end'
5. Select 'OK' and 'OK' again.
Regards,
Enrique Martinez
Sr. Software Consultant