Showing posts with label displays. Show all posts
Showing posts with label displays. Show all posts

Monday, March 26, 2012

Report Viewer Problem

Hi there,

I hope someone can assist with this ?

My Report viewer takes ages to load then displays in the following format :

localhost/WayneServer - /

 Monday, November 20, 2006 1:32 PM <dir> AW
 Monday, November 20, 2006 11:07 AM <dir> Data Sources
 Monday, November 20, 2006 11:44 AM <dir> export_UWCM
 Monday, November 20, 2006 11:06 AM <dir> Report Project2

Microsoft SQL Server Reporting Services Version 9.00.1399.00

This view exist in IIs, report manager and all previews

I wish to view the HTML versions.

are you navigating to http://reportserver/reportserver ? if this is the case you will get a view as above, I suggest you navigate to http://reportserver/reports to get the publised nice html / CSS reports.|||

Nope, still getting problems,

Have uninstalled SQL Server completely plus .Net Framework and reinstalled all.

I still cannot get the reports page to display. The error that keeps appearing is shown below.

From the various messages I have read , I shouldn't be concerned by an occasional appearence of this error, however it is happening every time I try to view reports.

The report server is running and visible if I browse within IIS , but when I try with the Reports page, this is what I get.

The page will take forever to load , then this appears.

Server Error in '/Reports' Application.

Thread was being aborted.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[ThreadAbortException: Thread was being aborted.]
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +483
 System.Web.HttpApplication.ResumeSteps(Exception error) +539
 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +144
 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +403

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

|||

This is the debug information for the error.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd\msvcm80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\App_global.asax.pa_-rz_z.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00394ed1_9bd0c501\ReportingServicesWebUserInterface.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00860e60_9bd0c501\Microsoft.ReportingServices.Diagnostics.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\002f6849_9bd0c501\Microsoft.ReportingServices.Interfaces.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\498aee86\00aa0b9e_9bd0c501\ReportingServicesCDOInterop.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00b832a5_9bd0c501\ReportingServicesEmailDeliveryProvider.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\006cf7a9_9bd0c501\ReportingServicesFileShareDeliveryProvider.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00e563a6_9bd0c501\ReportingServicesNativeClient.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4b08bd78\00f2abb7_99d0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\eadd2b09\00e484b0_99d0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\e3d1a29b\003ee7b2_99d0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\753885f1\00dcd580_99d0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\f6b220db\007683cf_99d0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4cce8f77\00c4f522_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\03e0eba8\00e3ff1c_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\7ac4a147\003d621f_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\ec2c2e87\000b3eda_99d0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\9f3b9c1a\00c13937_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\25bd35d6\001dd391_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\e979f37b\00fec897_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\65426dcc\00b28d9c_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3d8370dc\00bbc15f_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\5bcc180c\009383a2_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\1f72add9\00690e8d_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\c4359e5b\005d1ede_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\d785aca6\005d1ede_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\52a99564\007fe4c3_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\418a71ff\0095bafa_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\b4b974fc\008793f3_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\c94ea495\00d68ada_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\457280b4\003e14e4_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\a49f2774\00cb1fbf_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\64c3cee7\00c2ebfb_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\bff44b85\004e7243_9bd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\335adad0\0016d626_9bd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\250e7417\00f7cb2c_9bd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\9f7916c3\0084d707_9bd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\80fa321c\0059dd5e_9bd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\0f159e7c\0091a6ac_9cd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3949ea0c\001bf69b_9cd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\414c7f51\00cfbaa0_9cd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\51e658af\001eb287_9cd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\5e60063e\0023a5cb_9cd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\70ac46a9\0085b6fd_9cd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3326da35\008872e9_9cd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\ce35052b\000f06ed_9cd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\cb3df8e5\00f3b7de_9cd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\eef34066\001a7108_9dd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\App_Web_psamwgh1.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'cibw0fcm', No symbols loaded.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Management\2.0.0.0__b03f5f7f11d50a3a\System.Management.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

The thread 0xd64 has exited with code 0 (0x0).

The program '[4476] aspnet_wp.exe: Managed' has exited with code -532459699 (0xe0434f4d).

Posted by profoundnmqp at 9:09 AM 0 comments
Labels: , , , , , , , , , , , , , , ,

Wednesday, March 21, 2012

Report to show current year revenue only if last year has no reven

I need to create a report that correctly displays ONLY accounts that have
revenue for the current year and no revenue at all for the previous year
(calendar year). The sql below does not do it.
SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
GROUP BY a.ACCTNBR, a.ACCTNAME
Please Help
--
DCounttry something like:
SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
FROM FORD.dbo.DATA f
join FORD.dbo.ACCOUNT a on whatever
join FORD.dbo.DATE d on whatever
left outer join (
SELECT a1.ACCTNBR
FROM FORD.dbo.DATA f1
join FORD.dbo.ACCOUNT a1 on whatever
join FORD.dbo.DATE d1 on whatever
WHERE (d1.YEAR = '2004')
GROUP BY a1.ACCTNBR, a1.ACCTNAME
having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
subquery that returns all the accounts you don't want
WHERE (d.YEAR = '2005')
and oj.ACCTNBR is null --this gets rid of the unwanted accounts
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
FROM FORD.dbo.DATA f
join FORD.dbo.ACCOUNT a on whatever
join FORD.dbo.DATE d on whatever
WHERE (d.YEAR = '2004')
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"DCount17" <DCount17@.discussions.microsoft.com> wrote in message
news:469690F5-456F-4B07-9610-29646B7A81A5@.microsoft.com...
>I need to create a report that correctly displays ONLY accounts that have
> revenue for the current year and no revenue at all for the previous year
> (calendar year). The sql below does not do it.
> SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
> FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
> WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
> GROUP BY a.ACCTNBR, a.ACCTNAME
> Please Help
> --
> DCount|||Thanks for your help Mary. However, I'm not sure how to use the "oj"
statement you placed in the sql statement (see below). I thought you meant
outer join, but I get an error when doing that. I'm not good at complex
queries, so I really appreciate your help. Thanks again.
having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
subquery that returns all the accounts you don't want
WHERE (d.YEAR = '2005')
and oj.ACCTNBR is null --this gets rid of the unwanted accounts
GROUP BY a.ACCTNBR, a.ACCTNAME
having SUM(f.REVENUE)>0
"Mary Bray" wrote:
> try something like:
> SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
> FROM FORD.dbo.DATA f
> join FORD.dbo.ACCOUNT a on whatever
> join FORD.dbo.DATE d on whatever
> left outer join (
> SELECT a1.ACCTNBR
> FROM FORD.dbo.DATA f1
> join FORD.dbo.ACCOUNT a1 on whatever
> join FORD.dbo.DATE d1 on whatever
> WHERE (d1.YEAR = '2004')
> GROUP BY a1.ACCTNBR, a1.ACCTNAME
> having SUM(f1.REVENUE)>0) oj on a.ACCTNBR=oj.ACCTNBR --this is a
> subquery that returns all the accounts you don't want
> WHERE (d.YEAR = '2005')
> and oj.ACCTNBR is null --this gets rid of the unwanted accounts
> GROUP BY a.ACCTNBR, a.ACCTNAME
> having SUM(f.REVENUE)>0
> SELECT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE
> FROM FORD.dbo.DATA f
> join FORD.dbo.ACCOUNT a on whatever
> join FORD.dbo.DATE d on whatever
> WHERE (d.YEAR = '2004')
> GROUP BY a.ACCTNBR, a.ACCTNAME
> having SUM(f.REVENUE)>0
> --
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
> "DCount17" <DCount17@.discussions.microsoft.com> wrote in message
> news:469690F5-456F-4B07-9610-29646B7A81A5@.microsoft.com...
> >I need to create a report that correctly displays ONLY accounts that have
> > revenue for the current year and no revenue at all for the previous year
> > (calendar year). The sql below does not do it.
> >
> > SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
> > FORD.dbo.DATA f, FORD.dbo.ACCOUNT a, FORD.dbo.DATE d
> > WHERE (d.YEAR = '2005') AND (d.YEAR <> '2004')
> > GROUP BY a.ACCTNBR, a.ACCTNAME
> >
> > Please Help
> > --
> > DCount
>
>
Posted by profoundnmqp at 12:48 PM 0 comments
Labels: , , , , , , , , , , , , ,

Monday, March 12, 2012

Report size distplays incorrectly

I have a report that I have generated in VS and using the push method I'm sending the data to the report when it displays in the web page on localhost.

When the report displays only the topleft corner of the report can be viewed, also the report taskbar has a horizontal scroll bar attached to it as the width of the report is too small. If I use any of the buttons on the report taskbar when its running, when the page is refreshed I get the crystal reports viewer object instead of the report.

I have tried to change the size of the report in code but it doesn't affect it.

Has anyone come across this before?

TIADid you set the proper Printer settings?
Posted by profoundnmqp at 7:02 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Monday, February 20, 2012

Report Results Spread Out In Report Manager View

I have one report that displays the result spread out when viewed in Report
Manager. The report has several fields that are arranged on the same line. I
have many others reports with the same basic format that view as expected.
If the problem report is exported, the result is formatted correctly. The
problem seems to be only on the View tab.
Any ideas on what is causing this?On Fri, 25 Mar 2005 10:09:10 -0800, "TomS"
<TomS@.discussions.microsoft.com> wrote:
>I have one report that displays the result spread out when viewed in Report
>Manager. The report has several fields that are arranged on the same line. I
>have many others reports with the same basic format that view as expected.
>If the problem report is exported, the result is formatted correctly. The
>problem seems to be only on the View tab.
>Any ideas on what is causing this?
The view/preview mode is essentially an HTML rendering of your report.
When you use multiple textboxes, labels and such and try to position
them exactly, they get converted to HTML <DIV> and <SPAN> elements.
This model is quite flawed, that's why your positioning doesn't work
as expected.
A a general rule of thumb, you may consider the following:
1) Always tailor your reports towards a single format (Adobe Acrobat
PDF works the best, especially if your reports must be printed at some
point) Most likely, you'll never get the same results in different
formats, so don't worry about the others.
2) Avoid using textboxes and labels at all costs, especially if they
have to be close to each other, otherwise you'll always get formatting
surprises here and there. Use tables instead, whenever possible: no
unexpected results with formatting, plus they are much more effective
when it comes to HTML rendering (no more <DIV>s and such).
Posted by profoundnmqp at 10:37 PM 0 comments
Labels: , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)