Steve. This is brilliant. One thing I forgot to mention is that I am doing a delete from the table of the dups. So this deletes all the good ones....

Hmm. not sure I follow

I am try to work Recurrance into the mix. Like I said in the original question

There is one other table. That is the email table. I tried to fix this up a bit. Sorry. My SQL sucks. The Coalesce was messed up. The EndDate could...

This fixed it

http://blogs.msdn.com/b/vijaysk/archive/2009/01/14/report-viewer-toolbar-does-not-render-properly-on-iis-7-0.aspx

<TablixMembers>

<TablixMember />

...