Forms security deploy problem and email-subscription

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

Forms security deploy problem and email-subscription

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

sql

Forms security deploy problem

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

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

Forms Authentication for reporting

Hello
I have a web application that uses forms authentication.
Ideally I would like to be able to make some reports from my Reporting Services server available BUT I would also like to be able to pass authentication data through as I would like the reports available to be dictated by who the user is and the roles that they have within the application.
So for example if I have user A and user B then there are some reports that only user A will want to be able to see and some that only user B will want to see

There are also some reports that will vary the data according to who the user is e.g. user A will want to see their data only and User B will want to see their data only but on the same report
Is this possible? If anyone has any suggestions on where I can look to find out how to do this I would be grateful
thanks
steveI'd suggest doing the authentication before ever getting over to the reporting services server. Let the application control which reports each person can see based on their authorization in the application. Hopefully you will already have this information available, and if not it should not be hard to add.
And... even though it is more work now I'd also consider streaming the reporting services data back from the reporting services server to your application. Your server builds all of the correct parms including user specific required information, passes the request to the reporting services server, it processes the report data and comes back with a report, the report is streamed back to your application which displays it in a web browser or makes it available for download.|||

Thanks Patrick

The authorization information is available as you suggest.
I'm not sure I'm absolutely clear on what you mean bystreaming the reporting services data back. Do you mean some sort of HTTP handler or web service call? Ideally I would like something fairly simple that maintained much of the functionality of Reporting Services - particularly the ability to subscribe and to have different output formats

steve

|||What I am talking about is sending the data to the reporting server torun the report and getting the data back, but not actually using thereporting server to display the report. You'd lose some of thefunctionality of RS, but gain as much flexibility as you can code in.
I know reporting services can restrict report view by userids anddomains,but that is all configured on the reporting services side atthe report and the report folder level. The way that comes to mindfirst doing what you are talking about (passing credentials at reportrun time) is to have the report at a high level look at what is beingpassed and conditionally hide the page.
One thing I don't understand - how will somebody ever haveauthorization to see a report is even available if they are notauthorized to view it? Shouldn't you not even make the option availableto them? Display a report list for the current user, but that list is asubset of ALL of the reports available. They only see what they cantruly get to. I don't have your original post in front of me so I don'tknow if you have some restriction that prevents that. But that routeseems to be the best long term solution for anyone that is planning onusing reporting services and wants authentication.
FYI... in VS2005 there is a control you can put in your applicationthat looks/feels just like the reporting services website. So it willbe easier to stream reports back while keeping alot of thefunctionality.
|||Thanks patrick

steve|||My pleasure. I can't believe I was actually able to help somebody.
Report back with what you finally do and how it worked. I am interestedin seeing your solution and the code that goes along with it.
|||OK, no problems but don't hold your breath it may take a while
steve

Forms authentication and report publishing from Visual Studio

Hello,
I am using forms authentication to access RS. I can publish reports from the
RS interface, but I somehow can not publish reports from within the VS2000.
It asks me for a password and username and I supply those, but without an
error message it asks me again and again, with no success.
Any ideas on how to publish from VS?
ThanksDid you solve this or anyone else for that matter? I have the sam
problem. :

Formatting text in crystal reports

hi,
is it possible to format the size, font, color of the text displayed in the report?just right click on that text and click format text :sql

Formatting subtotals in Matrix reports

I am trying to alter the color of a cell of a subtotal based on the value of the subtotal.
Example: =IIF(Subtotal.Value < 20 ,"Brown","Blue")
This doesn't work. How do I refer to the value of a subtotal inside an expression' I think it has something to do with InScope(). I have definitely clicked the little green tab and am getting the correct properties window.Please see this posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c9b1dcda-cd35-4669-bb9b-4076ad21ed43
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Getting started and liking it" <Getting started and liking
it@.discussions.microsoft.com> wrote in message
news:5BC824BC-61A2-44A8-BA0B-FD0163954F8E@.microsoft.com...
> I am trying to alter the color of a cell of a subtotal based on the value
of the subtotal.
> Example: =IIF(Subtotal.Value < 20 ,"Brown","Blue")
> This doesn't work. How do I refer to the value of a subtotal inside an
expression' I think it has something to do with InScope(). I have
definitely clicked the little green tab and am getting the correct
properties window.

Formatting reports in SQL PLUS

I having trouble formatting a report for a particular table. The table is quite large and has 20+ columns. Im trying to do a select * from the table, but the output is really bad. I know it has something to do with wrap around, but im not sure how to fix it. Ive increased the LINESIZE and PAGESIZE which helped, but its still impossible to read. The output looks like this:

APP_ID SSN AREA_CODE TEL_NO QUE QUE QUES_LEAVEREASON APPLY_POSITION START_DAT AMTHOURS_
---- ---- ---- ---- -- -- ------- ----- --- -
HIGH_NAME HIGH_CITY HIGH_STATE COLLEGE_NAME COLLEGE_LOCATION COLLEGE_MAJOR COL
------- ------- ----- ------- -------
EXTRA_ACTIVITIES OFFICES_HELD OTHER_SCHOOLING QUE
-------- -------- -------- --
80000 443264455 561 6548890 no no NULL Greeter 04-APR-04 40 yes yes walk-in
Chase HS Bloomfield IL NULL NULL NULL NULL NULL
NULL NULL NULL yes

80001 887651109 772 7817764 no no NULL Manager 12-DEC-05 40 yes yes friend
Broward County HS Palm Beach FL FAU Boca Raton Management Business NULL
NULL NULL NULL yes

80002 198667112 772 5443234 no no NULL Stocker 08-AUG-05 40 yes yes TV
Centiennal Port St. Lucie FL NULL NULL NULL NULL NULL
NULL NULL NULL yes

80003 332690823 561 7734456 no no NULL Security guard 01-JAN-04 40 yes yes
George OLeary Callamajo MD NULL NULL NULL NULL NULL
NULL NULL NULL yes

80004 557751123 772 2601973 no no NULL Cashier 07-JUL-07 30 yes yes friends
St.Lucie County Port St. Lucie FL FAU Boca Raton Dentistry Business NU
NULL NULL NULL yes

80005 554321123 561 7812238 no no NULL Manager 01-JUN-04 40 yes yes newspap
Martin County Stuart FL FAU Boca Raton MIS Business NULL
NULL NULL NULL yes

Quote:

Originally Posted by Mateo

I having trouble formatting a report for a particular table. The table is quite large and has 20+ columns. Im trying to do a select * from the table, but the output is really bad. I know it has something to do with wrap around, but im not sure how to fix it. Ive increased the LINESIZE and PAGESIZE which helped, but its still impossible to read. The output looks like this:

APP_ID SSN AREA_CODE TEL_NO QUE QUE QUES_LEAVEREASON APPLY_POSITION START_DAT AMTHOURS_
---- ---- ---- ---- -- -- ------- ----- --- -
HIGH_NAME HIGH_CITY HIGH_STATE COLLEGE_NAME COLLEGE_LOCATION COLLEGE_MAJOR COL
------- ------- ----- ------- -------
EXTRA_ACTIVITIES OFFICES_HELD OTHER_SCHOOLING QUE
-------- -------- -------- --
80000 443264455 561 6548890 no no NULL Greeter 04-APR-04 40 yes yes walk-in
Chase HS Bloomfield IL NULL NULL NULL NULL NULL
NULL NULL NULL yes

80001 887651109 772 7817764 no no NULL Manager 12-DEC-05 40 yes yes friend
Broward County HS Palm Beach FL FAU Boca Raton Management Business NULL
NULL NULL NULL yes

80002 198667112 772 5443234 no no NULL Stocker 08-AUG-05 40 yes yes TV
Centiennal Port St. Lucie FL NULL NULL NULL NULL NULL
NULL NULL NULL yes

80003 332690823 561 7734456 no no NULL Security guard 01-JAN-04 40 yes yes
George OLeary Callamajo MD NULL NULL NULL NULL NULL
NULL NULL NULL yes

80004 557751123 772 2601973 no no NULL Cashier 07-JUL-07 30 yes yes friends
St.Lucie County Port St. Lucie FL FAU Boca Raton Dentistry Business NU
NULL NULL NULL yes

80005 554321123 561 7812238 no no NULL Manager 01-JUN-04 40 yes yes newspap
Martin County Stuart FL FAU Boca Raton MIS Business NULL
NULL NULL NULL yes

It depends on where and what you want to achieve. If you're in Query Analyzer, go to Query (menu) -> Results in grid. If you use it from some code, you'll have to work it out yourself - depending on what and where you need (sorry). Alternatively select fewer columns by listing the ones the you really need. Screen has limited width... ;-)|||I think you posted at the wrong section.
Sql plus is an oracle tool.
Just run the command from the prompt with the sqlplus.exe and redirect (>) it to an output file.

You should the be able to read the files more clearly (use the pspad viewer, it's free and it can handle long records)sql

Formatting Reports

I have created a report but I want to format it and put in headers and a bit of colour to it.
Does anyone know how I can do this.
Thanks,
macca

This is easy thing in reporting service read those tutorila to know how they are great ones on msdn

http://msdn2.microsoft.com/en-us/library/ms170623.aspx

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

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 of Reports

I'm new to reporting services, My company is trying to evaluate the
service to see if we can use it to replace some legacy reports. I'm
able to get most of it done but there is one problem I haven't been
able to solve in the last several days.
Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
Table2.columnB
>From Table1 inner join Table2 on Table1.id = Table2.Table1_id
That's giving me the result set I need
AAA AAA AAA BBB BBB
AAA AAA AAA CCC CCC
AAA AAA AAA DDD DDD
The requirement for the report is that data on the report not be
duplicated, so the output should be formatted like
AAA AAA AAA BBB BBB
CCC CCC
DDD DDD
I have tried groups, that seems to do what I want but if I don't have
a header of for the group I'm unable to change it again later, any
advice or direction is appreciated.Hey Lance,
Each cell in your table has a property "Hide Duplicates", so if the
previous field is the same as the current field it doesn't show. You should
simply need to access the property page and then set this field to "True"
Michael C
"lance.sanchez@.gmail.com" wrote:
> I'm new to reporting services, My company is trying to evaluate the
> service to see if we can use it to replace some legacy reports. I'm
> able to get most of it done but there is one problem I haven't been
> able to solve in the last several days.
> Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> Table2.columnB
> >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> That's giving me the result set I need
> AAA AAA AAA BBB BBB
> AAA AAA AAA CCC CCC
> AAA AAA AAA DDD DDD
> The requirement for the report is that data on the report not be
> duplicated, so the output should be formatted like
> AAA AAA AAA BBB BBB
> CCC CCC
> DDD DDD
> I have tried groups, that seems to do what I want but if I don't have
> a header of for the group I'm unable to change it again later, any
> advice or direction is appreciated.
>|||OK, i can get it to do what I want in the report builder from the
webpage but i cant seem to get the formating to work correctly in SQL
Server Business Intelligence Development Studio. any sugestions?
On Aug 20, 10:45 am, "lance.sanc...@.gmail.com"
<lance.sanc...@.gmail.com> wrote:
> I'm new to reporting services, My company is trying to evaluate the
> service to see if we can use it to replace some legacy reports. I'm
> able to get most of it done but there is one problem I haven't been
> able to solve in the last several days.
> Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> Table2.columnB
> >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> That's giving me the result set I need
> AAA AAA AAA BBB BBB
> AAA AAA AAA CCC CCC
> AAA AAA AAA DDD DDD
> The requirement for the report is that data on the report not be
> duplicated, so the output should be formatted like
> AAA AAA AAA BBB BBB
> CCC CCC
> DDD DDD
> I have tried groups, that seems to do what I want but if I don't have
> a header of for the group I'm unable to change it again later, any
> advice or direction is appreciated.|||Are you saying when you deploy it to Report Manager it works, but when your
using preview in BID it doesn't? Thats strange...have you tried closing out
the solution, and restarting ti?
"lance.sanchez@.gmail.com" wrote:
> OK, i can get it to do what I want in the report builder from the
> webpage but i cant seem to get the formating to work correctly in SQL
> Server Business Intelligence Development Studio. any sugestions?
>
> On Aug 20, 10:45 am, "lance.sanc...@.gmail.com"
> <lance.sanc...@.gmail.com> wrote:
> > I'm new to reporting services, My company is trying to evaluate the
> > service to see if we can use it to replace some legacy reports. I'm
> > able to get most of it done but there is one problem I haven't been
> > able to solve in the last several days.
> >
> > Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> > Table2.columnB
> >
> > >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> >
> > That's giving me the result set I need
> >
> > AAA AAA AAA BBB BBB
> > AAA AAA AAA CCC CCC
> > AAA AAA AAA DDD DDD
> >
> > The requirement for the report is that data on the report not be
> > duplicated, so the output should be formatted like
> >
> > AAA AAA AAA BBB BBB
> > CCC CCC
> > DDD DDD
> >
> > I have tried groups, that seems to do what I want but if I don't have
> > a header of for the group I'm unable to change it again later, any
> > advice or direction is appreciated.
>
>

formatting numbers in Crystal Reports

:confused:

Hello,

I need to format my numbers as follows:
In my ttx file I have a field called Quantity with a datatype of Number and the value that i used is 1.00
I need to know how to how to get the value of 1 and not 1.

I also have another line
Quantity number 1.500

and when i simply put that on the report, it prints the number 2. What am i doing wrong? This is what I have as code so far.

if int({tester.quantity2}) = {tester.quantity2} then
formula = totext({tester.quantity2}, "#####.#####")
else
formula = totext({tester.quantity2})
end if

Thanks
NadishaHi,

Try to set the format at design time. Right Click the formula/database field. Goto Format option, there you can find info about formatting under "Number" tab.

Formatting Issues

Hi all,
Im using the custom code to format the string returned by the
stored procedure in the reports.
Public Function ResourceCategory(ByVal stat As String) As String
Dim str As String
Dim arr As String()
arr = stat.Split(",")
Dim i As Integer
For i = 0 To arr.Length -1
If arr(i) = "'PART'" Then
str = str & "Partner/"
End If
If arr(i) = "'ADM'" Then
str = str & "Administration/"
End If
If arr(i) = "'DIR'" Then
str = str & "Director/"
End If
If arr(i) = "'ENG'" Then
str = str & "Engineer/"
End If
if arr(i) = "'PM'" Then
str = str & "Project Manager/"
End If
if arr(i) = "'SE'" Then
str = str & "Senior Engineer/"
End If
if arr(i) = "'VALGRE'" Then
str = str & "Validation Engineer Greenville/"
End If
if arr(i) = "'VALSEN'" Then
str = str & "Senior Validation Engineer SFO/"
End If
if arr(i) = "'VALSFO'" Then
str = str & "Validation Engineer/"
End If
if arr(i) = "All" Then
str = str & "All/"
End If
Next
str = str.Remove(str.LastIndexOf("/"), 1)
Return str
End Function
But if the condition fails the report prints "#Error"
Can I in any way avoid this'
hanks In Advance,Provide an Else condition for anything that does NOT satisfy the other
conditions like "NA"... But if the function fails, you can not override the
error...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> Hi all,
> Im using the custom code to format the string returned by the
> stored procedure in the reports.
> Public Function ResourceCategory(ByVal stat As String) As String
> Dim str As String
> Dim arr As String()
> arr = stat.Split(",")
> Dim i As Integer
> For i = 0 To arr.Length -1
> If arr(i) = "'PART'" Then
> str = str & "Partner/"
> End If
> If arr(i) = "'ADM'" Then
> str = str & "Administration/"
> End If
> If arr(i) = "'DIR'" Then
> str = str & "Director/"
> End If
> If arr(i) = "'ENG'" Then
> str = str & "Engineer/"
> End If
> if arr(i) = "'PM'" Then
> str = str & "Project Manager/"
> End If
> if arr(i) = "'SE'" Then
> str = str & "Senior Engineer/"
> End If
> if arr(i) = "'VALGRE'" Then
> str = str & "Validation Engineer Greenville/"
> End If
> if arr(i) = "'VALSEN'" Then
> str = str & "Senior Validation Engineer SFO/"
> End If
> if arr(i) = "'VALSFO'" Then
> str = str & "Validation Engineer/"
> End If
> if arr(i) = "All" Then
> str = str & "All/"
> End If
> Next
> str = str.Remove(str.LastIndexOf("/"), 1)
> Return str
> End Function
> But if the condition fails the report prints "#Error"
> Can I in any way avoid this'
> hanks In Advance,|||Thanks Wayne ,
this is wat im trying to accomplish.
Hope u will help me out in this'
Im displaying the parameters selected by the user in a textbox.
The selection mode is multiple.
Im passing the code selected to the stored procedure,so it displays the
code.
if i give,
Parameters!Category.Value
So i wrote the code which i posted previously,
IS there a way i can load the description from the database '
Can i connect to the Database from the Code to achieve this'
"Wayne Snyder" wrote:
> Provide an Else condition for anything that does NOT satisfy the other
> conditions like "NA"... But if the function fails, you can not override the
> error...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> > Hi all,
> > Im using the custom code to format the string returned by the
> > stored procedure in the reports.
> >
> > Public Function ResourceCategory(ByVal stat As String) As String
> > Dim str As String
> > Dim arr As String()
> > arr = stat.Split(",")
> > Dim i As Integer
> > For i = 0 To arr.Length -1
> > If arr(i) = "'PART'" Then
> > str = str & "Partner/"
> > End If
> > If arr(i) = "'ADM'" Then
> > str = str & "Administration/"
> > End If
> > If arr(i) = "'DIR'" Then
> > str = str & "Director/"
> > End If
> > If arr(i) = "'ENG'" Then
> > str = str & "Engineer/"
> > End If
> > if arr(i) = "'PM'" Then
> > str = str & "Project Manager/"
> > End If
> > if arr(i) = "'SE'" Then
> > str = str & "Senior Engineer/"
> > End If
> > if arr(i) = "'VALGRE'" Then
> > str = str & "Validation Engineer Greenville/"
> > End If
> > if arr(i) = "'VALSEN'" Then
> > str = str & "Senior Validation Engineer SFO/"
> > End If
> > if arr(i) = "'VALSFO'" Then
> > str = str & "Validation Engineer/"
> > End If
> > if arr(i) = "All" Then
> > str = str & "All/"
> > End If
> > Next
> > str = str.Remove(str.LastIndexOf("/"), 1)
> > Return str
> > End Function
> >
> > But if the condition fails the report prints "#Error"
> > Can I in any way avoid this'
> > hanks In Advance,
>

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.
sql

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.