Post reply

How to display a group of items without breaking into pages

  • April 2, 2007 at 1:29 am

    #116830

    Hi All,

    Similar to the labels query i have another one!

    In grouping i have certain cases which break into two pages ...i.e if i group say an employees under a particular client then you will have some eg.5 or 10 employees under single client. this is getting broken in two pages if it comes at the end of the page..if it exceeds the page length then it should be displayed in a new page.

    Is is possible ?

    can anybody help me?

    Regards,

    Thiyagarajam

  • April 2, 2007 at 8:32 am

    #698100

    I had a similar situation where the user community required a complete detail section to show on a page without bleeding to the next page. My detail lines range from 1 to 5 rows for each grouping. Since there is no conditional page breaking in reporting services, I had to calculate when to page break in the stored procedure and pass that through a field called DetailPageBreak. I added a footer to my grouping with a rectangle and an empty table pointing to the same recordset as the report. I set the rectangle's visibility to:

    =iif(Fields!DetailPageBreak.Value="Y",False,True)

    Now when the stored proc tells the report to page break, it does.

    I couldn't get any other way to work... it looks wierd in the report.... ...but it works.

    I'm curious if anyone else has other solutions...

    Scott

Viewing 2 posts - 1 through 1 (of 1 total)

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