Pagebreaks

• Søren

  SSChasing Mays

  Points: 628

  More actions

  February 20, 2009 at 5:16 am

  #200113

  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

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  February 20, 2009 at 6:41 am

  #947452

  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