Post reply

SSRS 2008 R2 page break after every 4th person in group

  • October 29, 2012 at 1:33 pm

    #269436

    Hi Everyone,

    I need to add a page after the 4th Patient in a report.

    The report has two groups. Organization and patient.

    Each patient will have 7 detail rows.

    For the organization group I have the page break set for between each instance and the end.

    The second group...it will group on each patient but will put only one patient per page. that makes for a lot of pages that are grouped by Organization and then by patient.

    So how do I put in a page break in after every 4th patient record in the Organization group?

    Larry

  • October 29, 2012 at 1:53 pm

    #1553892

    Use an expression like:

    =CInt(Ceiling(RowNumber(Nothing)/4))

    Then put this into a group and set your page break as you wish for that grouping.

    HTH,

    Rob

  • October 29, 2012 at 3:19 pm

    #1553926

    Thanks for the quick response!

    I had tried several of those, but none worked. I'm attaching some screen shots so hopefully that will help you to help me understand.

    Larry

  • October 29, 2012 at 3:23 pm

    #1553927

    [/URL]

    [/URL]

  • October 30, 2012 at 1:32 pm

    #1554354

    Bump...:-D

    Beuler...Beuler?

  • November 29, 2012 at 12:05 pm

    #1563963

    Got it...thanks!

    Was putting it in the wrong place. 🙂

  • December 10, 2012 at 12:09 pm

    #1567139

    Only works if I choose one hospital...I'm attaching a dummy table and .rdl file.

    If you choose "All", then the first hospital will work fine, the second hospital has 3 then 2, the 3rd hospital has the same.

    Could anyone help? this is the only report still on the 2005 server and we need to close it so we can move everythying to the 2008 server.

    Frustrating... to say the least.

    Any help would be great!

    larry

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply