February 20, 2009 at 5:16 am
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
February 20, 2009 at 6:41 am
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