You need INSTR

=Right(Variables!TheSchool.Value,Instr(Variables!TheSchool.Value," - ")+3)

Looks like all you need is a deliberate cross join... it will multiply one table by the other (all possible combinations of the two)...

Something like this:

SELECT nt.ID

, cp.City

...

What if you remove the page break on the last report?

Problem solved?

This looks like a matrix or tablix from your description. Could you post some sample data so we can mock up what you're working with? It's just really hard...

What happens if you set a page break after each tablix except the last one?

maybe like this?

http://stackoverflow.com/questions/15513313/conditional-page-breaks-at-group-level-in-ssrs2008-r2-reports

The first item selected would be Parameter(0). So the number would be (ListIndex-1)

If I have a multi-value parameter @OrderID, I can get the number of items selected using [@OrderID.Count]. Is that what you were looking for?

Now we're starting to get somewhere... We still need a couple of things: The create table scripts for the tables referenced in the views. Without them, it's impossible to...

Looks like if you had a ParentID (the ID of the parent/family of the child) in each of the queries you listed, you could just inner join them on ParentID,...

If you're trying to create a database on your local machine, then when you log into SQL Server, the instance should be something like YOUR_MACHINE_NAME\INSTANCE_NAME. Can you log in...

You owe it to yourself to make friends with Books On Line ( the help file for SQL Server ). Hidden very carefully under the F1 key. ...

What happened when you tried it using rectangles?

it would help a lot of you posted some dummy data for your tables. (CREATE TABLE and INSERT scripts).

Also, do the UNIONS and the NOT EXISTS separately. Maybe...