Pagebreaks

  • I am desperate, and I have used a lot of time trying to figure out what I am doing wrong, but I AM LOST..

    I have a datasource in a report, that returns 3 rows:

    Person A

    Person B

    Person C

    I want a page for each, so I have added a group on Personname. That works fine.

    Now I have 2 different subreports, that should be connected to each person, they are:

    1) BankTransactions

    2) Relatives

    I want to show them for each person. I have add two rows to my tabel in SSRS, and it works fine.

    PROBLEM: I want to have three pages for each person:

    1) Name (Person A)

    2) Banktransactions

    3) Relatives.

    That means I want total 9 pages in the current setup.

    No matter where I put pagebreaks, no matter if I put the subreport into a rectangle. I will not make pagebreaks.

    I have tested for keep together and what else I can figure out.

    Any help, links to ressources or???

    Søren,
    MCITP SQL 2008 (administration / programming), MCITP SQL 2005 (BI), MCT

  • Hi There Mr or Mrs Desperate!

    First, I wouldn't try to put the whole thing into a single table, you'll struggle to make this work the way you want to. I built an example which I attached so you can take a look, but the process is:

    1. Create a list box

    The list box should be assigned to your person name dataset, should be grouped on the person name and set the property to throw a page at beginning or end of each group.

    2. Create a text box

    Add a text box inside the list box, this will contain the person name.

    3. Create a rectangle

    Add a rectangle inside the list box and set the property of the rectangle to throw a page at the beginning.

    4. Drop the sub-report inside the rectangle

    The first sub-report should go inside the rectangle, which is in turn inside the list box.

    Repeat steps 3 & 4 for your next two sub-reports.

    This should do the trick for you.

    Good luck,

    Nigel.

    Nigel West
    UK

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

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