none
page break after certain number of group display

    Question

  • how can I do a page break after displaying 10 group collapsed lines ?

    i am showing collapsed groups and want to page break after displaying 10 group lines (in collapsed view)


    • Edited by izran Sunday, May 29, 2016 10:53 AM
    Sunday, May 29, 2016 10:39 AM

Answers

All replies

  • You can use an expression to control a page break

    http://stackoverflow.com/questions/28086679/conditional-pagebreak-on-a-group-in-ssrs-2008


    Thanks! Josh

    Sunday, May 29, 2016 2:35 PM
  • Hi Josh,

    i did use this but its not working 

    = IIF(RunningValue(Fields!WS_Job_Number.Value, CountDistinct, Nothing) mod 10=0, True,False)

    http://prnt.sc/b9ufto

    so any idea why its not working for me ?

    or can i share my screen at skype so you can check it ? (sjype id :izrankhattak)

    Thanks

    

    


    • Edited by izran Sunday, May 29, 2016 4:26 PM
    Sunday, May 29, 2016 4:25 PM
  • Hi Izran,

    I have created detail level blog on this requirement.

    Please follow below blog link:-

    https://msbitips.wordpress.com/2016/05/29/ssrs-page-break-after-certain-number-of-group/

    Still any issue, let us know.

    Thanks

    Prasad

    • Marked as answer by izran Sunday, May 29, 2016 5:41 PM
    Sunday, May 29, 2016 4:43 PM
  • Hi Parsad

                still same issue.

    http://prnt.sc/b9v1i4

    any chance you share my screen and get help at skype (izrankhattak)

    Thanks

    Sunday, May 29, 2016 5:15 PM
  • Hi Izran ,

    You want after 10 groups right then use 10 in your expression , I added your image.

    Can you share the output you are getting.

    Thanks

    Prasad

    Sunday, May 29, 2016 5:26 PM
  • Hi Prasad,

                  it worked by adding another group at the top of that group and then added this expression to it.

    so look to me its working fine mean now show 10 groups per page  .

    =CEILING(Fields!pagebreakrow.Value/10)

    Thanks


    • Edited by izran Sunday, May 29, 2016 5:40 PM
    • Marked as answer by izran Sunday, May 29, 2016 5:40 PM
    • Unmarked as answer by izran Sunday, May 29, 2016 5:40 PM
    Sunday, May 29, 2016 5:40 PM