I'm glad I'm making progress then.  Odd about the double hop error though.
So, I am using IE and the security zone "Local intranet" is set to LOW.  If I...

I had read about all the double hop stuff, but not sure that is my case.  I could be compeletely wrong on this mind you.
The SSRS web instance hosts...

Glad I could help 🙂

Sometimes all it takes is a fresh pair of eyes on the problem to get a solution.  It's funny how many times I spend...

I am assuming these are 2 different queries returning these.  So you want a 3rd query then I presume?

How about using a CASE statement and COUNT()?

I'm...

The original query didn't do it for me.  It was giving odd results like saying a TimesExecuted is 2 but ExecutedBy lists 7 distinct users.  That makes no sense.  I...

Another thing you could try is to load up profiler and see exactly what is being sent to the database.  I would suggest extended events, but this is 2008 and...

Are you sure it is SQL that is cutting off the data and not your web process?  I've seen oddities in websites where they had their email forms cutting off...