locked
How to Paginate on a child group RRS feed

  • Question

  • User248267340 posted

    I'm mimicking a Crystal Report, where the parent group is a doctor, and the report lists data about all his patients for the day (child group).

    In CR, for a particular doctor, 41 patients shows a total 18 pages.

    When I created the SSRS, I am able to show the report just like CR, but the pagination isn't the same. My report shows 1 of 1 pages,

    where the data for 41 patients just shows as one long continuous page. Can I paginate it like in CR?

    I'm using a List Region for the whole report, and it calls a sub-report.

    Friday, January 5, 2018 6:03 PM

All replies

  • User347430248 posted

    Hi coreysan,

    please refer the steps below.

    To add a page break to a row group in a table, matrix, or list

    1. In the Grouping pane, right-click a row group, and then click Group Properties.

      Note

      Page breaks are ignored on column groups.

    2. On the Page Breaks tab, select Between each instance of a group to add a page break between each instance of a group in the table.

    3. Optionally, select Also at the start of a group or Also at the end of a group to specify that a page break be added when a group starts or ends in the table.

    Reference:

    Add a Page Break (Report Builder and SSRS)

    Regards

    Deepak

    Monday, January 8, 2018 1:21 AM
  • User248267340 posted

     I don't know if my reply to this was received.

    I tried as you mentioned but nothing changed. I noticed if I print the report to a PDF, the PDF will

    break it into 18 pages. But SSRS only shows one long logical and physical page.

    Wednesday, January 10, 2018 9:38 PM
  • User347430248 posted

    Hi  coreysan,

    You had mentioned that,"I tried as you mentioned but nothing changed."

    Can you post the picture of your both reports.

    It will help us to understand the issue in better way.

    So we can provide more accurate suggestion to solve the issue.

    Thanks for your understanding.

    Regards

    Deepak

    Friday, January 26, 2018 7:35 AM
  • User248267340 posted

    Scrubbed imageDeepak,

    How in the world to you include an image? I clicked the image icon and filled out the path, but it refuses to load the image.

    It asks for dimensions but doesn't clarify if its in pixels or inches.  I tried both, and it won't load it.

    Friday, January 26, 2018 4:54 PM