Reportviewer is perfectly work in Internet Explorer 8.0
so Install IE 8.0
Saturday, February 5, 2011
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
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
Thursday, February 3, 2011
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 ;
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 ;
Subscribe to:
Posts (Atom)