constituent detail report not working (timeout)
How many activities do you have (i.e. the number of rows in the activity table)
Where are you hosting the site
Is your database on the same server as the web server


If i had to guess, i suspect your activity table is quite large and the left join with the contact tables is basically causing the query to take forever and hence the timeout