Solution : Print button is not displayed in reportviewer

Reportviewer is perfectly work in Internet Explorer 8.0
so Install IE 8.0

Solution For ReportViewer In local system Working ,But In (SERVER) Remotely Not Working

Solution to this problem
1.Download Microsoft Report viewer version 10.0
2.Install Microsoft Report viewer version 10.0 in server
3.change weconfig as
<system.webserver>
<modules runallmanagedmodulesforallrequests="true">
<validation validateintegratedmodeconfiguration="false">
<handlers>
<add type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" path="Reserved.ReportViewerWebControl.axd" verb="*" precondition="integratedMode" name="ReportViewerWebControlHandler">
</handlers>
</SYSTEM.WEBSERVER>
4.Its perfectly work only in IE8 so install IE8.
5.and change settings of IE8 as fallows
*. Tools -> InternetOptions -> Security Tab -> Custom Level button
*. Enable all ActiveX contrlos and plugins

ROW NUMBER in SQL SERVER 2005

SELECT EMPID, row_number() over (order by EMPID) Sno FROM EMPLOYEE

MULTIPLE ROWS WITH SAME DATA EXCEPT ONE COLUMN , THEN WE CAN CONVERT INTO ONE ROW WITH COMMA SEPERATOR

select p.assignNum, p.description, p.startDate,
stuff((select ', ' + cast(employeeNum as varchar(512))from #TableChild c where c.ASSIGNNUM = p.ASSIGNNUM for xml path('')),1,2,'') as employeeList
from #TableParent p ;