Thanks for the create table/insert scripts. That helps a lot. One more thing, though. Could you post your expected output? Is the age of the dog significant...

where? Why not re-post the whole thing?

<DDL statements to create tables>

<DML to get at least part of the way there>?

If you're only using one dataset, you could have several tablixes on your report and do different summaries in each one. No need to nest at all. I did...

one option is to use subreport(s).

if (the validkey in error table is present in the lookup table)

then

update the record

else

exit

UPDATE Table1

SET Field = <something>

WHERE Table1.Field1 = Table2.JoinField

This worked for me:

=RIGHT(Fields!School.Value,LEN(Fields!School.Value)-InStr(Fields!School.Value," - ")-2)

the easiest way is to sort in descending order (and maybe filtering out unplayed games). Something like:

-- top 4 could be ANY number...

SELECT TOP 4 *

FROM (

SELECT 'W'...

You have to create a new dataset (option 1).

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