Forms authentication slow!

Anyone else have this problem? I deployed a custom forms authentication
library with a ASP.NET login page when I go to http://server/reports it just
sits there for a minute with the progress icon spinning in IE then
eventually I get a Threading timeout from Reporting services (in the
attached debugger) and after that the page shows up... anyone else get this
with forms auth? anyone know why it does it or how to stop it?
here is the trace output from my remote debugging session from the time the
page starts to load until it shows the login page.. thanks!
========================== 'w3wp.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.
'w3wp.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.
'w3wp.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.
'w3wp.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.
'w3wp.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.
'w3wp.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.
'w3wp.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.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.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.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.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.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.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.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
Symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
No symbols loaded.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait to
default value of '1' second(s) because it was not specified in Configuration
file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing RunningRequestsAge
to default value of '30' second(s) because it was not specified in
Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing CleanupCycleMinutes
to default value of '10' minute(s) because it was not specified in
Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WatsonDumpOnExceptions to default value of
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to default value of
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
symbols loaded.
'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server started
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsSchedulingService
to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval to
'10' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to '60'
percent as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaximumMemoryLimit
to '80' percent as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaxQueueThreads to
'0' thread(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsWebServiceEnabled
to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaxScheduleWait to
'5' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RunningRequestsAge
to '30' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing CleanupCycleMinutes
to '10' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing WatsonFlags to
'1064' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!4/20/2007-09:17:06:: i INFO: Reporting Services
starting SKU: Developer
w3wp!resourceutilities!1!4/20/2007-09:17:06:: i INFO: Evaluation copy: 0
days left
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Running Requests Scavenger
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\f792c3fd\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
Symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
setconfiguration
setconfiguration: exit
Start GetuserInfo for null
*** End GetUserInfo
w3wp!library!1!04/20/2007-09:17:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at
Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String
item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest(Boolean&
transferedToViewerPage)
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)
-- End of inner exception stack trace --
The thread 0x7ec has exited with code 0 (0x0).
The thread 0x1734 has exited with code 0 (0x0).
w3wp!library!1!04/20/2007-09:17:10:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!04/20/2007-09:17:10:: i INFO: Catalog SQL Server Edition = Developer
w3wp!ui!5!4/20/2007-09:17:12:: e ERROR: The report server is not responding.
Verify that the report server is running and can be accessed from this
computer.
w3wp!ui!5!4/20/2007-09:17:13:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
setconfiguration
setconfiguration: exit
Start GetuserInfo for null
*** End GetUserInfo
w3wp!library!a!04/20/2007-09:17:13:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at
Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String
item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest(Boolean&
transferedToViewerPage)
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)
-- End of inner exception stack trace --
w3wp!library!a!04/20/2007-09:17:43:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!ui!5!4/20/2007-09:17:44:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)Yes, I am having the same problem.
"Smokey Grindle" wrote:
> Anyone else have this problem? I deployed a custom forms authentication
> library with a ASP.NET login page when I go to http://server/reports it just
> sits there for a minute with the progress icon spinning in IE then
> eventually I get a Threading timeout from Reporting services (in the
> attached debugger) and after that the page shows up... anyone else get this
> with forms auth? anyone know why it does it or how to stop it?
> here is the trace output from my remote debugging session from the time the
> page starts to load until it shows the login page.. thanks!
> ==========================> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.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.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.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.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.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.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.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.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
> Symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
> loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
> No symbols loaded.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait to
> default value of '1' second(s) because it was not specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not specified
> in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because it
> was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing RunningRequestsAge
> to default value of '30' second(s) because it was not specified in
> Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing CleanupCycleMinutes
> to default value of '10' minute(s) because it was not specified in
> Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
> default value of '1064' because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WatsonDumpOnExceptions to default value of
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WatsonDumpExcludeIfContainsExceptions to default value of
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not specified
> in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink to
> 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was not
> specified in Configuration file.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server started
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType to
> '0' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsSchedulingService
> to 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService to
> 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval to
> '10' second(s) as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
> WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to '60'
> percent as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaximumMemoryLimit
> to '80' percent as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing|||anyone know why this is?
"RSAdmin" <RSAdmin@.discussions.microsoft.com> wrote in message
news:20D5AEF8-C030-4960-8AE7-5F7256ED04A0@.microsoft.com...
> Yes, I am having the same problem.
> "Smokey Grindle" wrote:
>> Anyone else have this problem? I deployed a custom forms authentication
>> library with a ASP.NET login page when I go to http://server/reports it
>> just
>> sits there for a minute with the progress icon spinning in IE then
>> eventually I get a Threading timeout from Reporting services (in the
>> attached debugger) and after that the page shows up... anyone else get
>> this
>> with forms auth? anyone know why it does it or how to stop it?
>> here is the trace output from my remote debugging session from the time
>> the
>> page starts to load until it shows the login page.. thanks!
>> ==========================>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.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.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.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.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.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.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.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.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
>> Symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
>> loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
>> No symbols loaded.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait
>> to
>> default value of '1' second(s) because it was not specified in
>> Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> DatabaseQueryTimeout to default value of '30' second(s) because it was
>> not
>> specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> ProcessRecycleOptions to default value of '0' because it was not
>> specified
>> in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsScavengerCycle to default value of '30' second(s) because
>> it
>> was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsDbCycle to default value of '30' second(s) because it was
>> not
>> specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsAge
>> to default value of '30' second(s) because it was not specified in
>> Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> CleanupCycleMinutes
>> to default value of '10' minute(s) because it was not specified in
>> Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
>> default value of '1064' because it was not specified in Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WatsonDumpOnExceptions to default value of
>> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WatsonDumpExcludeIfContainsExceptions to default value of
>> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> SecureConnectionLevel to default value of '1' because it was not
>> specified
>> in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink
>> to
>> 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WebServiceUseFileShareStorage to default value of 'False' because it was
>> not
>> specified in Configuration file.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server
>> started
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType
>> to
>> '0' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> IsSchedulingService
>> to 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> IsNotificationService to 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService
>> to
>> 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval
>> to
>> '10' second(s) as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> WindowsServiceUseFileShareStorage to 'False' as specified in
>> Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to
>> '60'
>> percent as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
>> '720' minute(s) as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> MaximumMemoryLimit
>> to '80' percent as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializingsql

forming where clause

I wonder if I could write a dynamic where statement in a store procedure.
I have a web page that will pass following information to the store procedur
e.
Lets say I have a parameter @.typeid that can be 1 for rent, 2 for sale, 1 or
2 for either. My store procedure looks like this
create select_apartment_details
(
@.typeid nvarchar(50) -- @.typeid ='1' or @.typeid ='2' or @.typeid='1, 2'
)
AS
SELECT * FROM tbl_apartments WHERE typeid IN (@.typeid)
GO
By the way typeid field in the tbl_apartments is integer.
However, this doesnt work. Can anyone help me pls?If the values in the TypeID Column in the tbl_apartments table are indeed
limited to
1 or 2, then I suggest the following
Pass in @.TypeID = 1 When you want only the 1s,
@.TypeID = 2 When you want only the 2s,
and @.TypeID = 3, when you want 1s and 2s
Then in your where clause, you can do this
Where TypeID ^ @.Type <> 0
This will do a bitwise And comparison such that
Database TypeID
@.TypeID | 1 2
-- | -- --
1 | 1 0
2 | 0 2
3 | 1 2
"regaliel" wrote:

> I wonder if I could write a dynamic where statement in a store procedure.
> I have a web page that will pass following information to the store proced
ure.
> Lets say I have a parameter @.typeid that can be 1 for rent, 2 for sale, 1
or
> 2 for either. My store procedure looks like this
> create select_apartment_details
> (
> @.typeid nvarchar(50) -- @.typeid ='1' or @.typeid ='2' or @.typeid='1, 2'
> )
> AS
> SELECT * FROM tbl_apartments WHERE typeid IN (@.typeid)
> GO
> By the way typeid field in the tbl_apartments is integer.
> However, this doesnt work. Can anyone help me pls?
>|||Sorry Memory tricked me... The bitwise operator yu want is bitwise AND, and
the operator symbol is an Ampersand as in
Where TypeID & @.TypeID <> 0
"regaliel" wrote:

> I wonder if I could write a dynamic where statement in a store procedure.
> I have a web page that will pass following information to the store proced
ure.
> Lets say I have a parameter @.typeid that can be 1 for rent, 2 for sale, 1
or
> 2 for either. My store procedure looks like this
> create select_apartment_details
> (
> @.typeid nvarchar(50) -- @.typeid ='1' or @.typeid ='2' or @.typeid='1, 2'
> )
> AS
> SELECT * FROM tbl_apartments WHERE typeid IN (@.typeid)
> GO
> By the way typeid field in the tbl_apartments is integer.
> However, this doesnt work. Can anyone help me pls?
>|||Try this:
SELECT * FROM tbl_apartments WHERE CHARINDEX(CAST(typeid AS CHAR(1)), @.test)
> 0
"regaliel" <regaliel@.discussions.microsoft.com> wrote in message
news:9B49F533-89B9-492D-B556-96B2199585C9@.microsoft.com...
>I wonder if I could write a dynamic where statement in a store procedure.
> I have a web page that will pass following information to the store
> procedure.
> Lets say I have a parameter @.typeid that can be 1 for rent, 2 for sale, 1
> or
> 2 for either. My store procedure looks like this
> create select_apartment_details
> (
> @.typeid nvarchar(50) -- @.typeid ='1' or @.typeid ='2' or @.typeid='1, 2'
> )
> AS
> SELECT * FROM tbl_apartments WHERE typeid IN (@.typeid)
> GO
> By the way typeid field in the tbl_apartments is integer.
> However, this doesnt work. Can anyone help me pls?
>

Formatting values being passed to Sql

I have a generic page with some fields on it, I would like to be able to "groom" the values so that the data is nice and consistent.

Example: input 1 -- user types in "bob" or "BOB" or "Bob" or "JOE" etc...

the resulting record in Sql would be "Bob", "Fred", "Joe"
nice and formted out.

Any suggestions?string str1, str2 , formattedname
str1 = (name.ToUpper()).SubString(0,1)
str2 = (name.ToLower()).SubString(1)

formattedname = String.concat(str1,str2)

wher name is the string that contains the name to format. hope this helps

formatting of reports and blank pages

Why whenever I create a report that is more than 1 page long, do I get a blank page between every page of my report? In VS for example if I create a 3 page report, I get a 6 page report and every other page is blank.

How do you prevent this?

Cheers,

Mike

The culprit is ration of Page Heigth and Page Width. Check in Report-Properties-> Page Width and Page Height. Try setting Width = 31cm and Height = 28cm.

-kushpaw

Formatting database content

Hi
I have set up a SQL database to contain alist FAQ's for our company and
then plan to pull this info off using a web page.

So far I have entered the data but I am unable to control how it is
displayed inside SQL ie I cannot enter new blank lines I have tried
using lots of spaces but this does not work when I use the website to
display the info.

Is there a way of formatting and editing the data in the sql database
as I am unable to do this, if I try to edit the data in the database I
have to copy it to notepad delete what is in the database, edit the
text in notepad then paste it back in.

There must be a better way.

Please help

alamb200Sounds as if you need to convert your carraige return / line feed into the
HTML <BR> tag which will then give you the correct formatting on the screen.

If you want to do it in the database then use REPLACE( <col>, char(13) +
char(10), '<BR>' ) - check, it might be 10, 13 :)

Tony

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

<alamb200@.hotmail.com> wrote in message
news:1147771818.200249.269650@.j55g2000cwa.googlegr oups.com...
> Hi
> I have set up a SQL database to contain alist FAQ's for our company and
> then plan to pull this info off using a web page.
> So far I have entered the data but I am unable to control how it is
> displayed inside SQL ie I cannot enter new blank lines I have tried
> using lots of spaces but this does not work when I use the website to
> display the info.
> Is there a way of formatting and editing the data in the sql database
> as I am unable to do this, if I try to edit the data in the database I
> have to copy it to notepad delete what is in the database, edit the
> text in notepad then paste it back in.
> There must be a better way.
> Please help
> alamb200|||I have just had a look at the parameter tag but as I am new to SQL I am
not sure how I would put this place.

For example if my prefix charecter was / and my suffix charecter was \
for the sake of argument nad i wanted a new line after the full stop
in the following text how would I enter the information.

If your printer is no longer printing your logo's or overlays it may
have lost the images that have been "Flashed" on to it, to reflash your
printer follow the following instructions. Log on to SB Client and go
into the Company Files section. Next goto Runtime then Maintenance and
System Manager Menu.

Also I seem to be unable to edit text already in the database and have
to delete it and reenter it every time, is there an easier way of doing
that.

Thanks

Anthony

Tony Rogerson wrote:
> Sounds as if you need to convert your carraige return / line feed into the
> HTML <BR> tag which will then give you the correct formatting on the screen.
> If you want to do it in the database then use REPLACE( <col>, char(13) +
> char(10), '<BR>' ) - check, it might be 10, 13 :)
> Tony
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> <alamb200@.hotmail.com> wrote in message
> news:1147771818.200249.269650@.j55g2000cwa.googlegr oups.com...
> > Hi
> > I have set up a SQL database to contain alist FAQ's for our company and
> > then plan to pull this info off using a web page.
> > So far I have entered the data but I am unable to control how it is
> > displayed inside SQL ie I cannot enter new blank lines I have tried
> > using lots of spaces but this does not work when I use the website to
> > display the info.
> > Is there a way of formatting and editing the data in the sql database
> > as I am unable to do this, if I try to edit the data in the database I
> > have to copy it to notepad delete what is in the database, edit the
> > text in notepad then paste it back in.
> > There must be a better way.
> > Please help
> > alamb200|||On 16 May 2006 04:13:58 -0700, alamb200@.hotmail.com wrote:

>I have just had a look at the parameter tag but as I am new to SQL I am
>not sure how I would put this place.
>For example if my prefix charecter was / and my suffix charecter was \
>for the sake of argument nad i wanted a new line after the full stop
>in the following text how would I enter the information.

Hi Anthony,

wiith the right front-end, there's no need to use parameters. For
instance, copy and paste the following into Query Analyzer and execute;
you'll see that the output has exactly the lline breaks yoou asked for:

CREATE TABLE test (KeyColumn int NOT NULL PRIMARY KEY,
DataColumn varchar(1000) NOT NULL)
INSERT INTO test (KeyColumn, DataColumn)
VALUES (1, 'If your printer is no longer printing your logo''s or
overlays it may have lost the images that have been "Flashed" on to it,
to reflash your printer follow the following instructions.
Log on to SB Client and go into the Company Files section.
Next goto Runtime then Maintenance and System Manager Menu.')
go
SELECT * FROM test
go
DROP TABLE test
go

(Note: beware of extra line breaks inserted by Usenet software. In the
intended code, there are line breaks after the periods, but no other
line breaks in the VALUES clause.)

>Also I seem to be unable to edit text already in the database and have
>to delete it and reenter it every time, is there an easier way of doing
>that.

That, too, is a problem with your frontend.

May I ask you what tool you are using as your frontend?

--
Hugo Kornelis, SQL Server MVP|||Hi

I am using a web page as my front end using ASP to pull the info from
the SQL database so I am in the position of either having multiple
columns with small bits of info in my database so I can format them how
I want

The other option is to have some commands built into the text in the
database entry which will be read by the system and control the
formatting when it is read.

Is this possible?

When I am trying to edit the info in the database all I am doing is
right clicking on the table in Enterprise manager and display all
columns and working on it from there.

Is this the right way to do this?

Anthony

Hugo Kornelis wrote:
> On 16 May 2006 04:13:58 -0700, alamb200@.hotmail.com wrote:
> >I have just had a look at the parameter tag but as I am new to SQL I am
> >not sure how I would put this place.
> >For example if my prefix charecter was / and my suffix charecter was \
> >for the sake of argument nad i wanted a new line after the full stop
> >in the following text how would I enter the information.
> Hi Anthony,
> wiith the right front-end, there's no need to use parameters. For
> instance, copy and paste the following into Query Analyzer and execute;
> you'll see that the output has exactly the lline breaks yoou asked for:
> CREATE TABLE test (KeyColumn int NOT NULL PRIMARY KEY,
> DataColumn varchar(1000) NOT NULL)
> INSERT INTO test (KeyColumn, DataColumn)
> VALUES (1, 'If your printer is no longer printing your logo''s or
> overlays it may have lost the images that have been "Flashed" on to it,
> to reflash your printer follow the following instructions.
> Log on to SB Client and go into the Company Files section.
> Next goto Runtime then Maintenance and System Manager Menu.')
> go
> SELECT * FROM test
> go
> DROP TABLE test
> go
> (Note: beware of extra line breaks inserted by Usenet software. In the
> intended code, there are line breaks after the periods, but no other
> line breaks in the VALUES clause.)
> >Also I seem to be unable to edit text already in the database and have
> >to delete it and reenter it every time, is there an easier way of doing
> >that.
> That, too, is a problem with your frontend.
> May I ask you what tool you are using as your frontend?
> --
> Hugo Kornelis, SQL Server MVP|||On 17 May 2006 02:01:41 -0700, alamb200@.hotmail.com wrote:

>Hi
>I am using a web page as my front end using ASP to pull the info from
>the SQL database so I am in the position of either having multiple
>columns with small bits of info in my database so I can format them how
>I want
>The other option is to have some commands built into the text in the
>database entry which will be read by the system and control the
>formatting when it is read.
>Is this possible?

Hi Anthony,

I'm not an ASP guy, so I don't know. Are you saying that linebreaks in a
long character data column are not displayed properly by ASP? Have you
consiedered asking for alternatives in one of the ASP groups?

>When I am trying to edit the info in the database all I am doing is
>right clicking on the table in Enterprise manager and display all
>columns and working on it from there.
>Is this the right way to do this?

No, definitely not. Data entry through Enterprise Manager is broken in
far more ways than I care to remember. Some of these errors are listed
by Aaron Bertrand at http://www.aspfaq.com/show.asp?id=2455.

--
Hugo Kornelis, SQL Server MVP|||Hi

Go to http://212.50.191.220/techfaq and enter restart in the search box
in the bottom center this pops up a new page of info pulled from my SQL
database. As you can see it can be difficult to read so I would like to
add some line breaks and if possible some other formatting.

When I pull the info in it comes as one big lump of text so ASP cannot
format it what I beleive from one of my earlier replies is that I can
embed some commands into the text held in the entry to be pulled out of
the database that ASP can read and turn into html formatting when it is
displayed on the page.

Is this correct and if so how do I add them.

Anthony
Hugo Kornelis wrote:
> On 17 May 2006 02:01:41 -0700, alamb200@.hotmail.com wrote:
> >Hi
> >I am using a web page as my front end using ASP to pull the info from
> >the SQL database so I am in the position of either having multiple
> >columns with small bits of info in my database so I can format them how
> >I want
> >The other option is to have some commands built into the text in the
> >database entry which will be read by the system and control the
> >formatting when it is read.
> >Is this possible?
> Hi Anthony,
> I'm not an ASP guy, so I don't know. Are you saying that linebreaks in a
> long character data column are not displayed properly by ASP? Have you
> consiedered asking for alternatives in one of the ASP groups?
> >When I am trying to edit the info in the database all I am doing is
> >right clicking on the table in Enterprise manager and display all
> >columns and working on it from there.
> >Is this the right way to do this?
> No, definitely not. Data entry through Enterprise Manager is broken in
> far more ways than I care to remember. Some of these errors are listed
> by Aaron Bertrand at http://www.aspfaq.com/show.asp?id=2455.
> --
> Hugo Kornelis, SQL Server MVP|||On 18 May 2006 06:53:21 -0700, alamb200@.hotmail.com wrote:

>Hi
>Go to http://212.50.191.220/techfaq

"The page cannot be found"

>When I pull the info in it comes as one big lump of text so ASP cannot
>format it

I can only repeat my previous suggestion: if ASP has trouble retaining
embedded CR/LF combinations from a varchar column, then the best place
to seek help is an ASP group.

--
Hugo Kornelis, SQL Server MVP|||(alamb200@.hotmail.com) writes:
> When I pull the info in it comes as one big lump of text so ASP cannot
> format it what I beleive from one of my earlier replies is that I can
> embed some commands into the text held in the entry to be pulled out of
> the database that ASP can read and turn into html formatting when it is
> displayed on the page.

Neither do I know much ASP, but I would assume that if you get some
text from the database, and spit it out between regular <P> tags,
that any line breaks will be blissfully ignored, as that is how HTML
works.

You could use the <PRE> tag to maintain the line-breaks, but the text
would be presented in a monospaced font, so it may look a bit ugly.

You could run this:

SELECT replace(col, char(13) + char(10), <BR />)

to change line breaks to <BR /> tags. The <BR /> introduces a line break
in the text.

You could also store the text in HTML format.

But as Hugo says, asking in an ASP group is probably a good idea.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

formatted invoice line item report

I am trying to make a report that show invoice line items using a table with
groups. We what the table to fill the page no matter how many line items are
on the invoice. For example the invoice my only have three items on the last
page so the group footer ends up in the middle of the page. The group footer
has the invoice total. How can we place group footer at the bottom of the
last page? Even in the case of a small invoice that only has one page ?I'm going to take a stab at this but I hope someone comes up with a better
way. I could use it myself. Anyway here goes:
Insert a row in your above your totals in the group footer.
Figure out the number of line items that fit on a page.
Make the row height of the just inserted row an expression equal to
(MaxLineItemsPerPage - (LineItemCount MOD MaxLineItemsPerPage)) *
LineItemRowHeight)
This will give you the number of "blank" lines on the last page of the
invoice and make your empty footer row that height to fill in the space. The
expression will get a little more complicated if pages 2 on have more rows
than page 1 (i.e. no invoice header) but I think the calculation can be done.
Let me know if this works...Or if someone comes up with a better way!
"DJJIII" wrote:
> I am trying to make a report that show invoice line items using a table with
> groups. We what the table to fill the page no matter how many line items are
> on the invoice. For example the invoice my only have three items on the last
> page so the group footer ends up in the middle of the page. The group footer
> has the invoice total. How can we place group footer at the bottom of the
> last page? Even in the case of a small invoice that only has one page ?

Formating Reports To Print

How can I fixa report that displays correctly on the web page (Report
manager) but when I either print or convert to .pdf, some of the text boxes
shifts to a second and maybe a third ?
The report is actualy smaller than a regular letter page.
Any ideas ?You will have to build the report to render as a pdf. In doing so the
web formatting may look out of allignment but the pdf file will look
right. It is very difficult to get them both to look good.
Also, sometimes placing rectangles behind your report items will
prevent them from going outside the report boundries.
Another thing to check is to make sure the "report" page size and
"body" size properties are matching or similar (ie. set the report page
size to 11 x 8.5 for a Landscape print and set the body size to 10.75 x
8 to fit within the page boundries) and only work with in these
boundries. Take some time to try out different margin settings as
well. Work with it a little and usually you can come up with something
that works in the web and pdf worlds.
Let me know how it goes!

format print range when converted to Excel?

I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.

How can I get Excel to format the print version just as I have on the RS site?

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||

Anyone else?

Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?

|||

KimberlyL wrote:

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.

I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.

Has anyone got a solution or work around for this problem?

Thanks

/Mats

|||

I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.

format print range when converted to Excel?

I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.

How can I get Excel to format the print version just as I have on the RS site?

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||

Anyone else?

Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?

|||

KimberlyL wrote:

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.

I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.

Has anyone got a solution or work around for this problem?

Thanks

/Mats

|||

I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.

format print range when converted to Excel?

I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.

How can I get Excel to format the print version just as I have on the RS site?

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||

Anyone else?

Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?

|||

KimberlyL wrote:

I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.

I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.

Has anyone got a solution or work around for this problem?

Thanks

/Mats

|||

I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.

|||You can report the same in connect site by referring to Http://connect.microsoft.com.
FYI