We don't have your tables and data in our database so It is better for us if you have codes to generate those NEXT TIME when asking for help. That...

I am facing the same issue. The "back to parent report" icon was missing once I deployed my reports to the server. Here's a workaround http://elonblackman.wordpress.com/2010/07/31/adding-a-back-button-to-a-ssrs-drill-through-report/. I...

update dbo.kipp

set [desc] = (select distinct b.[desc] from dbo.kipp b where substring(a.proj_id, 1,5) = b.proj_id )

from dbo.kipp a

Try that, Others might have a better way