Display X number of records per page

Hi
I have a report which displays skills per staff, I have placed staff details
in the textbox with a list and also I have placed a table of skills for
grouped by staffid. Basically I need to print out certificates like :
Staff X
--
then skills listed
1.skill A
2.skill B
--
footer which has a signature.
I have got everything working except if any staff has more than 10 skills it
just blows out of the page size and everything goes crazy. My question is how
can I display only 5 skills per page with header and footer and if the skills
exceed more than 5 then create a new page with header and footer and the
remaining skills.
I have used this function in the visibility of the skills table
=iif(rownumber(nothing)>5,False,True) but it just stops displaying anyskills
if the skills exceed more than 5 skills.
Please any advice or direction be most appreciated.
CheersCreate a grouping on the list as follows:
=Ceiling(RowNumber(nothing)/5)
and designate a page break after the group.
This will split the list into 5 per page.
--C17
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:4C9E5928-5BA9-49D0-B0C7-0F85EF42B927@.microsoft.com...
> Hi
> I have a report which displays skills per staff, I have placed staff
> details
> in the textbox with a list and also I have placed a table of skills for
> grouped by staffid. Basically I need to print out certificates like :
> Staff X
> --
> then skills listed
> 1.skill A
> 2.skill B
> --
> footer which has a signature.
> I have got everything working except if any staff has more than 10 skills
> it
> just blows out of the page size and everything goes crazy. My question is
> how
> can I display only 5 skills per page with header and footer and if the
> skills
> exceed more than 5 then create a new page with header and footer and the
> remaining skills.
> I have used this function in the visibility of the skills table
> =iif(rownumber(nothing)>5,False,True) but it just stops displaying
> anyskills
> if the skills exceed more than 5 skills.
> Please any advice or direction be most appreciated.
> Cheers|||Thank you very much it worked.
merry xmas
"C17" wrote:
> Create a grouping on the list as follows:
> =Ceiling(RowNumber(nothing)/5)
> and designate a page break after the group.
> This will split the list into 5 per page.
> --C17
>
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:4C9E5928-5BA9-49D0-B0C7-0F85EF42B927@.microsoft.com...
> > Hi
> > I have a report which displays skills per staff, I have placed staff
> > details
> > in the textbox with a list and also I have placed a table of skills for
> > grouped by staffid. Basically I need to print out certificates like :
> > Staff X
> > --
> > then skills listed
> > 1.skill A
> > 2.skill B
> > --
> > footer which has a signature.
> > I have got everything working except if any staff has more than 10 skills
> > it
> > just blows out of the page size and everything goes crazy. My question is
> > how
> > can I display only 5 skills per page with header and footer and if the
> > skills
> > exceed more than 5 then create a new page with header and footer and the
> > remaining skills.
> >
> > I have used this function in the visibility of the skills table
> > =iif(rownumber(nothing)>5,False,True) but it just stops displaying
> > anyskills
> > if the skills exceed more than 5 skills.
> > Please any advice or direction be most appreciated.
> > Cheers
>
>