Can't Sum Table Fields in SQL 2000 Reporting Services Report

I have a report in SQL 2000 Reporting Services with several tables.
The only thing showing in these tables are the group footers because
the detail data is not needed.
I am needing to add a total for a column in each table and then add
those totals together in a text box.
When ever I do this I am getting the following errors:
The value expression for the text box 'textbox58' uses an aggregate
function on a report item. Aggregate functions can be used only on
report items contained in page headers and footers.
The value expression for the text box 'textbox37' uses an aggregate
expression without a scope. A scope is required for all aggregates
used outside of a data region unless the report contains exactly one
data set.
I've tried several different ways and still can't figure it out, PLEASE
HELP!!A few design suggestions. If you don't need the detail then don't return it.
Let SQL Server do the work. But, let's say you continue the way you are
today. What I do sometimes is to add a colum to the result set and make it
calculated, then using the expression editor make it the sum of the two
fields. This makes things a whole lot easier at times.
Once you have done this you can use the expression editor, base it on the
dataset and sum up the column.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jasper.frazee@.gmail.com> wrote in message
news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>I have a report in SQL 2000 Reporting Services with several tables.
> The only thing showing in these tables are the group footers because
> the detail data is not needed.
> I am needing to add a total for a column in each table and then add
> those totals together in a text box.
> When ever I do this I am getting the following errors:
> The value expression for the text box 'textbox58' uses an aggregate
> function on a report item. Aggregate functions can be used only on
> report items contained in page headers and footers.
> The value expression for the text box 'textbox37' uses an aggregate
> expression without a scope. A scope is required for all aggregates
> used outside of a data region unless the report contains exactly one
> data set.
> I've tried several different ways and still can't figure it out, PLEASE
> HELP!!
>|||Thanks for the Responce Bruce!
In my dataset there are 5 columns that will alwayse have the same
result and one column that has detail data that needs to be summed. If
I sum that one column in SQL I have to have the other columns in an
aggregate function as well. In SQL 2000 the "First" function is not
supported. Any ways around that?
Once I get the totals in each table on my report how can I grab those
totals and sum them in a textbox? It keeps telling me that "Aggregate
functions can be used only on
report items contained in page headers and footers."
Thanks A Lot!
Jasper
Bruce L-C [MVP] wrote:
> A few design suggestions. If you don't need the detail then don't return it.
> Let SQL Server do the work. But, let's say you continue the way you are
> today. What I do sometimes is to add a colum to the result set and make it
> calculated, then using the expression editor make it the sum of the two
> fields. This makes things a whole lot easier at times.
> Once you have done this you can use the expression editor, base it on the
> dataset and sum up the column.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <jasper.frazee@.gmail.com> wrote in message
> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
> >I have a report in SQL 2000 Reporting Services with several tables.
> > The only thing showing in these tables are the group footers because
> > the detail data is not needed.
> > I am needing to add a total for a column in each table and then add
> > those totals together in a text box.
> > When ever I do this I am getting the following errors:
> >
> > The value expression for the text box 'textbox58' uses an aggregate
> > function on a report item. Aggregate functions can be used only on
> > report items contained in page headers and footers.
> >
> > The value expression for the text box 'textbox37' uses an aggregate
> > expression without a scope. A scope is required for all aggregates
> > used outside of a data region unless the report contains exactly one
> > data set.
> >
> > I've tried several different ways and still can't figure it out, PLEASE
> > HELP!!
> >|||You can sum the numbers by summing =ReportItems("textbox1").Value +
ReportItems("textbox2").Value etc.
You need to know the names of the textboxes, so you might want to name the
textboxes with something more descriptive than textbox1 etc before you start
summing. :)
(Not sure if it's ReportItems or ReportItem, so you might have to try both.)
Kaisa M. Lindahl Lervik
<jasper.frazee@.gmail.com> wrote in message
news:1162417277.149051.147270@.f16g2000cwb.googlegroups.com...
> Thanks for the Responce Bruce!
> In my dataset there are 5 columns that will alwayse have the same
> result and one column that has detail data that needs to be summed. If
> I sum that one column in SQL I have to have the other columns in an
> aggregate function as well. In SQL 2000 the "First" function is not
> supported. Any ways around that?
> Once I get the totals in each table on my report how can I grab those
> totals and sum them in a textbox? It keeps telling me that "Aggregate
> functions can be used only on
> report items contained in page headers and footers."
> Thanks A Lot!
> Jasper
> Bruce L-C [MVP] wrote:
>> A few design suggestions. If you don't need the detail then don't return
>> it.
>> Let SQL Server do the work. But, let's say you continue the way you are
>> today. What I do sometimes is to add a colum to the result set and make
>> it
>> calculated, then using the expression editor make it the sum of the two
>> fields. This makes things a whole lot easier at times.
>> Once you have done this you can use the expression editor, base it on the
>> dataset and sum up the column.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <jasper.frazee@.gmail.com> wrote in message
>> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>> >I have a report in SQL 2000 Reporting Services with several tables.
>> > The only thing showing in these tables are the group footers because
>> > the detail data is not needed.
>> > I am needing to add a total for a column in each table and then add
>> > those totals together in a text box.
>> > When ever I do this I am getting the following errors:
>> >
>> > The value expression for the text box 'textbox58' uses an aggregate
>> > function on a report item. Aggregate functions can be used only on
>> > report items contained in page headers and footers.
>> >
>> > The value expression for the text box 'textbox37' uses an aggregate
>> > expression without a scope. A scope is required for all aggregates
>> > used outside of a data region unless the report contains exactly one
>> > data set.
>> >
>> > I've tried several different ways and still can't figure it out, PLEASE
>> > HELP!!
>> >
>sql

Cant start report server

Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

I just can't seem to be able to start the service.

Can you plz help?

Thanks

Hi,

Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:

1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >

If the problem still exists, you should try the following methods.

Set the Report Server Web service and Report Manager to use the same application pool.

|||

Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?

++ Where do I go to

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

|||

Hi,

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

Can't start 2005 Report Services on XP SP2

Hej,
I am attempting to get a test environment up and running on my XP SP2
machine but I can't start reporting services. I found the following log in
the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e ERROR:
Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'ANEISHA\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
firstTime)
Anybody have any clues?
Thanks in advance,
Antony C. Roberts.In desperation, I created an ASPNET user and gave it all possible roles.
That solved the problem... What is the CORRECT solution to this problem?
Thanks!
/Ant.
"Antony C. Roberts" <acr@.no.way.com> wrote in message
news:ONFgYrjUGHA.1444@.TK2MSFTNGP11.phx.gbl...
> Hej,
> I am attempting to get a test environment up and running on my XP SP2
> machine but I can't start reporting services. I found the following log in
> the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
> ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'ANEISHA\ASPNET' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
> firstTime)
> Anybody have any clues?
> Thanks in advance,
> Antony C. Roberts.
>

Can't send Attachement (Report Delivering)

Good morning
Iâ'm trying to enable the scheduled report delivering. It is working fine
without attachment (except the mail is in the SMTP-queue, but this is another
issueâ?¦ï' ). But Iâ'm not able to send a mail including a rendered report.
Here is my environment:
- Windows 2003 Advanced Server
- Reporting Services Service Pack 1
- SQL Server Service Pack 3a
- NT 4 Domain (very old, I knowâ?¦)
- SQL Reporting Service running using a Domain Account (having local
Admin on Server)
- SQL Service & Agent running the same Domain Account
- Reporting Server is configured to relay the Mails to an other SMTP
Host within our network
Any ideas?
Thanks in advanceâ?¦
DominicStill not working...help...
I can't find any error messages. Only one looks a bit confusing:
ReportingServicesService!library!8d4!8/12/2004-14:17:02:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
The rest of the log is below...
w3wp!webserver!b8c!8/12/2004-14:17:13:: i INFO: Reporting Web Server started
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Running on 2
physical processors, 4 logical processors
w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Reporting Services
starting SKU: Developer
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!fa8!08/12/2004-14:17:17:: i INFO: Call to GetSystemPermissions
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Exporting public key
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Performing sku validation
w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Importing existing encryption
key
w3wp!library!b8c!08/12/2004-14:17:21:: i INFO: Call to GetSystemPermissions
w3wp!library!b8c!8/12/2004-14:27:13:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
"Dominic" wrote:
> Good morning
> Iâ'm trying to enable the scheduled report delivering. It is working fine
> without attachment (except the mail is in the SMTP-queue, but this is another
> issueâ?¦ï' ). But Iâ'm not able to send a mail including a rendered report.
> Here is my environment:
> - Windows 2003 Advanced Server
> - Reporting Services Service Pack 1
> - SQL Server Service Pack 3a
> - NT 4 Domain (very old, I knowâ?¦)
> - SQL Reporting Service running using a Domain Account (having local
> Admin on Server)
> - SQL Service & Agent running the same Domain Account
> - Reporting Server is configured to relay the Mails to an other SMTP
> Host within our network
> Any ideas?
> Thanks in advanceâ?¦
> Dominic|||Can you look in the reportserverservice<date>.log file instead. This is the
log file that should contain the error information. Is the status of the
subscription showing any error?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:B9C818D3-8753-4E51-9702-BD1654BCA959@.microsoft.com...
> Still not working...help...
> I can't find any error messages. Only one looks a bit confusing:
> ReportingServicesService!library!8d4!8/12/2004-14:17:02:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> The rest of the log is below...
> w3wp!webserver!b8c!8/12/2004-14:17:13:: i INFO: Reporting Web Server
started
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing ConnectionType
to
> '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> IsSchedulingService to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing IsEventService
to
> 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing PollingInterval
> to '10' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MemoryLimit to
> '60' percent as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaximumMemoryLimit to '80' percent as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxQueueThreads
> to '0' thread(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing MaxScheduleWait
> to '5' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing InstanceName to
> 'MSSQLSERVER' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration
> file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration
file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> RunningRequestsAge to '30' second(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!b8c!8/12/2004-14:17:13:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
not
> specified in Configuration file.
> w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Running on 2
> physical processors, 4 logical processors
> w3wp!resourceutilities!b8c!8/12/2004-14:17:13:: i INFO: Reporting Services
> starting SKU: Developer
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Database Cleanup (Web
> Service) timer enabled: Cycle: 600 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests
Scavenger
> timer enabled: Cycle: 60 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Running Requests DB
timer
> enabled: Cycle: 60 seconds
> w3wp!runningjobs!b8c!8/12/2004-14:17:13:: i INFO: Memory stats update
timer
> enabled: Cycle: 60 seconds
> w3wp!library!fa8!08/12/2004-14:17:17:: i INFO: Call to
GetSystemPermissions
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Exporting public key
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Performing sku validation
> w3wp!crypto!fa8!08/12/2004-14:17:17:: i INFO: Importing existing
encryption
> key
> w3wp!library!b8c!08/12/2004-14:17:21:: i INFO: Call to
GetSystemPermissions
> w3wp!library!b8c!8/12/2004-14:27:13:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
jobs
> "Dominic" wrote:
> > Good morning
> >
> > I'm trying to enable the scheduled report delivering. It is working fine
> > without attachment (except the mail is in the SMTP-queue, but this is
another
> > issue.? ). But I'm not able to send a mail including a rendered report.
> >
> > Here is my environment:
> > - Windows 2003 Advanced Server
> > - Reporting Services Service Pack 1
> > - SQL Server Service Pack 3a
> > - NT 4 Domain (very old, I know.)
> > - SQL Reporting Service running using a Domain Account (having local
> > Admin on Server)
> > - SQL Service & Agent running the same Domain Account
> > - Reporting Server is configured to relay the Mails to an other SMTP
> > Host within our network
> >
> > Any ideas?
> >
> > Thanks in advance.
> > Dominic|||Hi Daniel
Ok...hmm...in the service log are AUTZ errors...but my ReportingServer
Service is running with a Domain-Account having local admin rights on the
box...
here is the full log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__08_13_2004_10_55_11.log</Path>
<SystemName>DYLAN</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 54288 seconds
ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO:
Initializing crypto as user: LEU.HANDEL.1\emisadmin
ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO: Exporting
public key
ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Performing
sku validation
ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: EventPolling
polling service started
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
NotificationPolling polling service started
ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!d68!8/13/2004-10:55:14:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!4e4!8/13/2004-10:55:14::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!47c!8/13/2004-10:55:14:: Polling started
ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at 8/13/2004 10:56:04 AM.
ReportingServicesService!schedule!f3c!8/13/2004-10:56:04:: Creating Time
based subscription notification for subscription:
5e89b59a-13bd-404e-9551-f1fae831ecc0
ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution completed at 8/13/2004
10:56:04 AM.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
finished processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04::
NotificationPolling processing item 81728282-f0dd-4318-bc40-f2314d3b4d11
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO: Call to
RenderFirst( '/Reports/Meta Reports/CountryTable' )
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!f3c!08/13/2004-10:56:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!f3c!08/13/2004-10:56:04:: Notification
81728282-f0dd-4318-bc40-f2314d3b4d11 completed. Success: False, Status:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files, DeliveryExtension: Report Server Email,
Report: CountryTable, Attempt 0
ReportingServicesService!dbpolling!f3c!08/13/2004-10:56:04::
NotificationPolling finished processing item
81728282-f0dd-4318-bc40-f2314d3b4d11
Thanks a lot !
Cheers Dominic
"Daniel Reib [MSFT]" wrote:
> Can you look in the reportserverservice<date>.log file instead. This is the
> log file that should contain the error information. Is the status of the
> subscription showing any error?
> --
> -Daniel|||Not sure that this will help, but the error you are getting is:
'The specified domain either does not exist or could not be contacted'
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dominic" <Dominic@.discussions.microsoft.com> wrote in message
news:D2EC6713-D44D-4154-BD63-1B046272AD44@.microsoft.com...
> Hi Daniel
> Ok...hmm...in the service log are AUTZ errors...but my ReportingServer
> Service is running with a Domain-Account having local admin rights on the
> box...
> here is the full log:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>W. Europe Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__08_13_2004_10_55_11.log</Path>
> <SystemName>DYLAN</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
> ReportingServicesService!library!f3c!8/13/2004-10:55:11:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i
INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!f3c!8/13/2004-10:55:11:: i
INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 54288 seconds
> ReportingServicesService!runningjobs!f3c!8/13/2004-10:55:11:: i INFO:
Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO:
> Initializing crypto as user: LEU.HANDEL.1\emisadmin
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:11:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO:
Performing
> sku validation
> ReportingServicesService!crypto!cf0!8/13/2004-10:55:14:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!cf0!08/13/2004-10:55:14::
SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!d68!8/13/2004-10:55:14:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!4e4!8/13/2004-10:55:14::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!47c!8/13/2004-10:55:14:: Polling
started
> ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
> processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
> ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at 8/13/2004 10:56:04 AM.
> ReportingServicesService!schedule!f3c!8/13/2004-10:56:04:: Creating Time
> based subscription notification for subscription:
> 5e89b59a-13bd-404e-9551-f1fae831ecc0
> ReportingServicesService!library!f3c!8/13/2004-10:56:04:: Schedule
> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution completed at 8/13/2004
> 10:56:04 AM.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04:: EventPolling
> finished processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
> ReportingServicesService!dbpolling!47c!8/13/2004-10:56:04::
> NotificationPolling processing 1 more items. 1 Total items in internal
queue.
> ReportingServicesService!dbpolling!f3c!8/13/2004-10:56:04::
> NotificationPolling processing item 81728282-f0dd-4318-bc40-f2314d3b4d11
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO: Call to
> RenderFirst( '/Reports/Meta Reports/CountryTable' )
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> ReportingServicesService!library!f3c!08/13/2004-10:56:04:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
system
> properties.
> ReportingServicesService!emailextension!f3c!08/13/2004-10:56:04:: Error
> sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> The Report Server has encountered a configuration error; more details in
the
> log files -->
>
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
> The Report Server has encountered a configuration error; more details in
the
> log files
> at
>
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP
tr userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin
g
> userName, IntPtr userToken)
> at
>
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S
tring
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
>
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF
romCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
values,
> DatasourceCredentialsCollection credentials)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
> at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes
sageBody(IMessage message, Notification notification, SubscriptionData data)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag
e(Notification notification)
> at
>
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
> ReportingServicesService!notification!f3c!08/13/2004-10:56:04::
Notification
> 81728282-f0dd-4318-bc40-f2314d3b4d11 completed. Success: False, Status:
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files, DeliveryExtension: Report Server
Email,
> Report: CountryTable, Attempt 0
> ReportingServicesService!dbpolling!f3c!08/13/2004-10:56:04::
> NotificationPolling finished processing item
> 81728282-f0dd-4318-bc40-f2314d3b4d11
> Thanks a lot !
> Cheers Dominic
> "Daniel Reib [MSFT]" wrote:
> > Can you look in the reportserverservice<date>.log file instead. This is
the
> > log file that should contain the error information. Is the status of
the
> > subscription showing any error?
> >
> > --
> > -Daniel|||Did you ever get this resolved? I'm have the same type
issue.
Thanks, Ed
>--Original Message--
>Not sure that this will help, but the error you are
getting is:
>'The specified domain either does not exist or could not
be contacted'
>
>--
>-Daniel
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Dominic" <Dominic@.discussions.microsoft.com> wrote in
message
>news:D2EC6713-D44D-4154-BD63-1B046272AD44@.microsoft.com...
>> Hi Daniel
>> Ok...hmm...in the service log are AUTZ errors...but my
ReportingServer
>> Service is running with a Domain-Account having local
admin rights on the
>> box...
>> here is the full log:
>> <Header>
>> <Product>Microsoft SQL Server Reporting Services
Version
>> 8.00.878.00</Product>
>> <Locale>en-US</Locale>
>> <TimeZone>W. Europe Daylight Time</TimeZone>
>> <Path>C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__08_13_2004_10_55_11.
log</Path>
>> <SystemName>DYLAN</SystemName>
>> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
>> <OSVersion>5.2.3790.0</OSVersion>
>> </Header>
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing ConnectionType to '0' as specified in
Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsSchedulingService to 'True' as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsNotificationService to 'True' as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing IsEventService to 'True' as specified in
Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing PollingInterval to '10' second(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MemoryLimit to '60' percent as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RecycleTime to '720' minute(s) as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaximumMemoryLimit to '80' percent as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxAppDomainUnloadTime to '30' minute(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxQueueThreads to '0' thread(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxActiveReqForOneUser to '20' requests(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing MaxScheduleWait to '5' second(s) as
specified in
>Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing DatabaseQueryTimeout to '120' second(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing InstanceName to 'MSSQLSERVER' as
specified in Configuration
>> file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing ProcessRecycleOptions to '0' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsScavengerCycle to '60'
second(s) as specified
>in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsDbCycle to '60' second(s)
as specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing RunningRequestsAge to '30' second(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing CleanupCycleMinutes to '10' minute(s) as
specified in
>> Configuration file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing SecureConnectionLevel to '0' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing DisplayErrorLink to 'True' as specified
in Configuration
>file.
>> ReportingServicesService!library!f3c!8/13/2004-
10:55:11:: i INFO:
>> Initializing WebServiceUseFileShareStorage to default
value of 'False'
>> because it was not specified in Configuration file.
>> ReportingServicesService!resourceutilities!f3c!
8/13/2004-10:55:11:: i
>INFO:
>> Running on 2 physical processors, 4 logical processors
>> ReportingServicesService!resourceutilities!f3c!
8/13/2004-10:55:11:: i
>INFO:
>> Reporting Services starting SKU: Developer
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Database Cleanup (NT Service) timer enabled: Cycle: 600
seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Running Requests Scavenger timer enabled: Cycle: 60
seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Running Requests DB timer enabled: Cycle: 60 seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>> Execution Log Entry Expiration timer enabled: Cycle:
54288 seconds
>> ReportingServicesService!runningjobs!f3c!8/13/2004-
10:55:11:: i INFO:
>Memory
>> stats update timer enabled: Cycle: 60 seconds
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:11:: i INFO:
>> Initializing crypto as user: LEU.HANDEL.1\emisadmin
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:11:: i INFO: Exporting
>> public key
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:14:: i INFO:
>Performing
>> sku validation
>> ReportingServicesService!crypto!cf0!8/13/2004-
10:55:14:: i INFO: Importing
>> existing encryption key
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14:: EventPolling
>> polling service started
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14::
>> NotificationPolling polling service started
>> ReportingServicesService!dbpolling!cf0!08/13/2004-
10:55:14::
>SchedulePolling
>> polling service started
>> ReportingServicesService!dbpolling!d68!8/13/2004-
10:55:14:: EventPolling
>> heartbeat thread started.
>> ReportingServicesService!dbpolling!4e4!8/13/2004-
10:55:14::
>> NotificationPolling heartbeat thread started.
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:55:14:: Polling
>started
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:56:04:: EventPolling
>> processing 1 more items. 1 Total items in internal
queue.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04:: EventPolling
>> processing item 226e46a7-15d7-47c9-bad4-311a2094ff2b
>> ReportingServicesService!library!f3c!8/13/2004-
10:56:04:: Schedule
>> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 executed at
8/13/2004 10:56:04 AM.
>> ReportingServicesService!schedule!f3c!8/13/2004-
10:56:04:: Creating Time
>> based subscription notification for subscription:
>> 5e89b59a-13bd-404e-9551-f1fae831ecc0
>> ReportingServicesService!library!f3c!8/13/2004-
10:56:04:: Schedule
>> 48d32fa7-3755-47d4-8fa6-cbe1ab861556 execution
completed at 8/13/2004
>> 10:56:04 AM.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04:: EventPolling
>> finished processing item 226e46a7-15d7-47c9-bad4-
311a2094ff2b
>> ReportingServicesService!dbpolling!47c!8/13/2004-
10:56:04::
>> NotificationPolling processing 1 more items. 1 Total
items in internal
>queue.
>> ReportingServicesService!dbpolling!f3c!8/13/2004-
10:56:04::
>> NotificationPolling processing item 81728282-f0dd-4318-
bc40-f2314d3b4d11
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO:
>> Initializing EnableIntegratedSecurity to 'True' as
specified in Server
>> system properties.
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO: Call to
>> RenderFirst( '/Reports/Meta Reports/CountryTable' )
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: e ERROR:
>Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files, AuthzInitializeContextFromSid: Win32 error:
1355;
>> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files
>> ReportingServicesService!library!f3c!08/13/2004-
10:56:04:: i INFO:
>> Initializing EnableExecutionLogging to 'True' as
specified in Server
>system
>> properties.
>> ReportingServicesService!emailextension!f3c!08/13/2004-
10:56:04:: Error
>> sending email.
>Microsoft.ReportingServices.Diagnostics.Utilities.RSExcept
ion:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files -->
>Microsoft.ReportingServices.Diagnostics.Utilities.ServerCo
nfigurationErrorEx
>ception:
>> The Report Server has encountered a configuration
error; more details in
>the
>> log files
>> at
>Microsoft.ReportingServices.Authorization.Native.GetAuthzC
ontextForUser(IntP
>tr userSid)
>> at
Microsoft.ReportingServices.Authorization.Native.IsAdmin
(String
>> userName)
>> at
>Microsoft.ReportingServices.Authorization.WindowsAuthoriza
tion.IsAdmin(Strin
>g
>> userName, IntPtr userToken)
>> at
>Microsoft.ReportingServices.Authorization.WindowsAuthoriza
tion.CheckAccess(S
>tring
>> userName, IntPtr userToken, Byte[] secDesc,
ReportOperation
>requiredOperation)
>> at
Microsoft.ReportingServices.Library.Security.CheckAccess
(ItemType
>> catItemType, Byte[] secDesc, ReportOperation rptOper)
>> at
>Microsoft.ReportingServices.Library.RSService._GetReportPa
rameterDefinitionF
>romCatalog(CatalogItemContext
>> reportContext, String historyID, Boolean forRendering,
Guid& reportID,
>Int32&
>> executionOption, String& savedParametersXml,
ReportSnapshot&
>> compiledDefinition, ReportSnapshot& snapshotData, Guid&
linkID, DateTime&
>> historyDate)
>> at
Microsoft.ReportingServices.Library.RSService._GetReportPar
ameters(String
>> report, String historyID, Boolean forRendering,
NameValueCollection
>values,
>> DatasourceCredentialsCollection credentials)
>> at
>Microsoft.ReportingServices.Library.RSService.RenderAsLive
OrSnapshot(Catalog
>ItemContext
>> reportContext, ClientRequest session, Warning[]&
warnings,
>> ParameterInfoCollection& effectiveParameters)
>> at
>Microsoft.ReportingServices.Library.RSService.RenderFirst
(CatalogItemContext
>> reportContext, ClientRequest session, Warning[]&
warnings,
>> ParameterInfoCollection& effectiveParameters, String[]&
>secondaryStreamNames)
>> at
>Microsoft.ReportingServices.Library.RenderFirstCancelableS
tep.Execute()
>> at
>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBas
e.ExecuteWrapper()
>> -- End of inner exception stack trace --
>> at
>Microsoft.ReportingServices.Diagnostics.CancelablePhaseBas
e.ExecuteWrapper()
>> at
>Microsoft.ReportingServices.Library.RenderFirstCancelableS
tep.RenderFirst(RS
>Service
>> rs, CatalogItemContext reportContext, ClientRequest
session, JobTypeEnum
>> type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters,
>> String[]& secondaryStreamNames)
>> at
Microsoft.ReportingServices.Library.ReportImpl.Render
(String
>> renderFormat, String deviceInfo)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.ConstructMes
>sageBody(IMessage message, Notification notification,
SubscriptionData data)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.CreateMessag
>e(Notification notification)
>> at
>Microsoft.ReportingServices.EmailDeliveryProvider.EmailPro
vider.Deliver(Noti
>fication notification)
>> ReportingServicesService!notification!f3c!08/13/2004-
10:56:04::
>Notification
>> 81728282-f0dd-4318-bc40-f2314d3b4d11 completed.
Success: False, Status:
>> Failure sending mail: The Report Server has encountered
a configuration
>> error; more details in the log files,
DeliveryExtension: Report Server
>Email,
>> Report: CountryTable, Attempt 0
>> ReportingServicesService!dbpolling!f3c!08/13/2004-
10:56:04::
>> NotificationPolling finished processing item
>> 81728282-f0dd-4318-bc40-f2314d3b4d11
>> Thanks a lot !
>> Cheers Dominic
>> "Daniel Reib [MSFT]" wrote:
>> > Can you look in the reportserverservice<date>.log
file instead. This is
>the
>> > log file that should contain the error information.
Is the status of
>the
>> > subscription showing any error?
>> >
>> > --
>> > -Daniel
>
>.
>sql

Can't seem to fix the column width

I have a matrix report. I put a rectangle with two text boxes - inside
the column group. Works great!
However - now I can't seem to fix the width of the columns. It just
grows and ignores the property. I have tried to set it for each
individual cell in that matrix. And I have tried to specify the size..
Any idea?
ThxI am not sure when the column width grows. Does this happen when authoring
the report or when you render it? Would you please add some more detail
reproduction steps to your description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407150710.6351cec1@.posting.google.com...
> I have a matrix report. I put a rectangle with two text boxes - inside
> the column group. Works great!
> However - now I can't seem to fix the width of the columns. It just
> grows and ignores the property. I have tried to set it for each
> individual cell in that matrix. And I have tried to specify the size..
> Any idea?
> Thx|||The reproduction step is:
Create a matrix.
Add a field to the column group textbox.
Fix column width - by selecting Cannot Grow.
Fix the Cell width - by selecting cannot Grow.
Works great!
Now add a rectangle inside the column group textbox...
The 'Cannot grow' fails...|||CanGrow only applies to vertical growth, not horizontal growth. However, the
only thing that grows horizontally is autosized images and matrices (per
column group instance).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407181543.300fff7c@.posting.google.com...
> The reproduction step is:
> Create a matrix.
> Add a field to the column group textbox.
> Fix column width - by selecting Cannot Grow.
> Fix the Cell width - by selecting cannot Grow.
> Works great!
> Now add a rectangle inside the column group textbox...
> The 'Cannot grow' fails...

Can't see the ReportManager from another workstation

Maybe this sounds like a simple question for you, but it really took me a
while trying to figure it out.
I have had a report ready on my Report Manager, but I could not run it on
any other workstations at all. My workstation is using IIS 5.1, Win XP, RS
2000 and VS .NET 2003. The database server and report server is a remote
server.
I am thinking maybe I just missed something in the configuration. Please
advise. Thanks a lot.Check that you have given the correct security permissions for your users.
If you are saying that you log in with your own credentials on several boxes
but can only access the report manager from one box then that is a different
problem.
Jim.
"WindWind" wrote:
> Maybe this sounds like a simple question for you, but it really took me a
> while trying to figure it out.
> I have had a report ready on my Report Manager, but I could not run it on
> any other workstations at all. My workstation is using IIS 5.1, Win XP, RS
> 2000 and VS .NET 2003. The database server and report server is a remote
> server.
> I am thinking maybe I just missed something in the configuration. Please
> advise. Thanks a lot.
>|||Hi, Jim,
Thanks for the reply. Yes, I logged in the computers under the same domain ID.
Does this cause the problem?
"Jim Breffni" wrote:
> Check that you have given the correct security permissions for your users.
> If you are saying that you log in with your own credentials on several boxes
> but can only access the report manager from one box then that is a different
> problem.
> Jim.
>
> "WindWind" wrote:
> > Maybe this sounds like a simple question for you, but it really took me a
> > while trying to figure it out.
> >
> > I have had a report ready on my Report Manager, but I could not run it on
> > any other workstations at all. My workstation is using IIS 5.1, Win XP, RS
> > 2000 and VS .NET 2003. The database server and report server is a remote
> > server.
> >
> > I am thinking maybe I just missed something in the configuration. Please
> > advise. Thanks a lot.
> >|||On the report server itself, go to http://localhost/reports
then click on Site Settings
(What we are doing is verifying that no one changed anything for the Browser
rights)
In the Security section, click the "Configure item-level role definitions"
link
Next, click the browser role.
Verify that View folders, View models, view reports, view resources, and
manage individual subscriptions is checked (this is the default settings)
If any are missing, check them and then click Ok
Next, go back to your home page by click the Home link in the upper right.
Click the Properties tab.
You should see two entries (by default only one - the BUILTIN\Administrators
will be listed)
The other entry should be (if you want domain users to have rights to see
this report server) is:
DOMAIN\Domain Users (where DOMAIN is the name of your domain)
If you don't see your domain users being listed, then click "New Role
Assignment" and then check the box for Browser rights and type the group you
want to have rights. In this case, DOMAIN\Domain Users
If they still cannot connect, log them off their workstation, and log back
on after making these changes.
=-Chris
"WindWind" <WindWind@.discussions.microsoft.com> wrote in message
news:A7F95DD1-107D-4100-B2F5-2864BD41F2B4@.microsoft.com...
> Maybe this sounds like a simple question for you, but it really took me a
> while trying to figure it out.
> I have had a report ready on my Report Manager, but I could not run it on
> any other workstations at all. My workstation is using IIS 5.1, Win XP, RS
> 2000 and VS .NET 2003. The database server and report server is a remote
> server.
> I am thinking maybe I just missed something in the configuration. Please
> advise. Thanks a lot.
>

Can't see the Report Manager page

Hi There,

I have installed the Sql Server 2005 reporting services and I see that two default directories being created in IIS (Report and ReportServer..). For some reason, if I type http://localhost/reports, I am unable to see the report manager homepage. Can anybody suggest me if I need to configure any more stuff to see the report manager?

I enabled the anonymous authentication and still cannot see....

I can see the webservice however by typing http://localhost/reportserver...

Any suggestions are greatly apprecaited...

Thanks.

Sam.

I got it. I had to set up the reportserver to be accessible anonymous along with Reports.

Thanks.

sql

cant see Report manager page

Hi Friends
we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !!
all they can see is "sql server reporting services" text nothing else. no reports and no models ertc.,

i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create reports off report server page.
Thanks for your help.From the main page, select the properties tab, then select the security sub-tab. You can grant the necessary permissions to any group or user there.|||Thanks for that Brian. I just tried that but did not work.
our domain name is "yabba.co.nz" so i added domain by clicking "new role assignment" but to no avail.
so i tried add one of users ,who is having this problem like "yabba.co.nz\Peter" but got following error
The user or group name 'yabba.co.nz/Peter' is not recognized. (rsUnknownUserName)

any ideas please.
Thanks for your help|||You should be specifying the user or group name the same way you would for an ACL, such as for the file system. If you are using a domain user, the report server machine must be a part of that domain.|||Thank you very much Brian.
That really helped . now all our users could view report manager page and they can view and run reports now :)

one thing remained though, they cant see "Report builder" link .i tried to assign all roles (i.e. browser,content manager etc.,) but still did not help.
any ideas on this one.
Thanks for your help again :)|||

The user must have "Execute Report Definition" permission. This is a system level permission that can be configured from the "Site Settings" link at the top of Report Manager.

|||Thank you very much Brian.
That worked like a charm. Thanks for all your help :)

Cant see image

Hello, my image is stored on the database as an URL, not binary.

I put a textbox and the url is show on the report,

then I put an image and this expression

=(ReportItems!dslogo.Value)

dslogo is the name of the textbox where the url is. but I dont see my image yet.

Did you set the source property of the image to "External"? Do you get the image in designer preview?|||

Its external and no I dont see it in the preview neither,

when I copy paste the url in the browser it shows me the image.

|||

Hmm, I tried a simple repro and it worked just fine for me. Here is the rdl I used:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="Northwind">
<DataSourceReference>Northwind</DataSourceReference>
<rd:DataSourceID>6865eece-7da0-4cf5-9a9f-0f9d8d019185</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<Left>2.125in</Left>
<MIMEType />
<Top>1.25in</Top>
<ZIndex>1</ZIndex>
<Width>1.22917in</Width>
<Source>External</Source>
<Style />
<Height>0.36458in</Height>
<Value>=ReportItems!ID.Value</Value>
</Image>
<Textbox Name="ID">
<Left>2.125in</Left>
<Top>0.5in</Top>
<rd:DefaultName>ID</rd:DefaultName>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Fields!ID.Value</Value>
</Textbox>
</ReportItems>
<Height>3.75in</Height>
</Body>
<rd:ReportID>689d4b94-4437-47b2-b266-840ecd5d2866</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select 'http://hp.msn.com/global/c/lg/msft94.gif'</CommandText>
<DataSourceName>Northwind</DataSourceName>
</Query>
<Fields>
<Field Name="ID">
<rd:TypeName>System.String</rd:TypeName>
<DataField />
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>12.875in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>

|||

The reporting server is in another server than my machine, the image is on the reporting service but I am testing the report from the preview tab. Maybe it fails because the image is on another server and the report is not deployed?

The image is inside a folder of a web application

C:\Inetpub\wwwroot\Application\images\image1.gif.

Does the folder need special permissions, or do I have to configure reportserver XML configuration files to execute on another context?

Thanks

Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

sql

Can't see content tab or properties tab.

An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>

Can't see a graphical inicator

We have an SRS report that should show a red, green, or yellow circle for one
of the columns. However, only the green and reds are showing up. The ones
that should be yellow are blank. We cannot see anything different in the
coding for yellow as the others. Any ideas?This has been resolved. We had this codded as a value instead of color.
"Renee H" wrote:
> We have an SRS report that should show a red, green, or yellow circle for one
> of the columns. However, only the green and reds are showing up. The ones
> that should be yellow are blank. We cannot see anything different in the
> coding for yellow as the others. Any ideas?

Can't Save Report Parameters

I have looked at the SOAP method of integration as well as the URL method,
and it is just not possible to save report parameters as selected by the
user! The only way you can save them is if you re-invent your own parameter
inputs! And keep in mind that a complete integration solution should be able
to accept any possible combination of report parameters!
I think this is another oversight in the design of this product from
microsoft. They have specially designed ways to cache report data, saving
history, etc... But what about the more common case of wanting fresh data
for the same parameters? I am amazed that they did not think of this...
Is there anything like this in the works for version 2... Yes?
Please tell me yes :-]
MalikLet me also clarify that the difficulty here is getting the parameter input
from the user.
If I already know what parameters I want to run the report for, there is no
problem.
The problem is, the user can change them and then re-run the report, and I
have no idea
what parameters are currently in the report being displayed!
Malik
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> I have looked at the SOAP method of integration as well as the URL method,
> and it is just not possible to save report parameters as selected by the
> user! The only way you can save them is if you re-invent your own
parameter
> inputs! And keep in mind that a complete integration solution should be
able
> to accept any possible combination of report parameters!
> I think this is another oversight in the design of this product from
> microsoft. They have specially designed ways to cache report data, saving
> history, etc... But what about the more common case of wanting fresh data
> for the same parameters? I am amazed that they did not think of this...
> Is there anything like this in the works for version 2... Yes?
> Please tell me yes :-]
> Malik
>
>|||Donovan,
Thanks very much for your report. This is exactly the kind of solution I
need, although there are still a few problems.
I thought of doing it this way, but I am trying to fully integrate SQL RS
with our Web Application. I don't want to have to explain to our customers
that in order to design reports for use with our application you have to
always have those extra data sources present along with code to retrieve the
parameters. This puts the onus on the report developer to be a coder rather
than me taking care of the whole solution myself.
I suppose I could come up with some kind of template report that our
customers can start with, and that would make this a workable solution for
us. I am going over your report in more detail to see what I can learn from
it.
Your help has been quite valuable for my project, and I really appreciate
you sending the report!
Thank you very much indeed,
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> Take a look at the attached report for help. It goes against the pubs
sample database and requires
> a SQL script to be run on the db prior to use.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Let me also clarify that the difficulty here is getting the parameter
input
> > from the user.
> >
> > If I already know what parameters I want to run the report for, there is
no
> > problem.
> >
> > The problem is, the user can change them and then re-run the report, and
I
> > have no idea
> > what parameters are currently in the report being displayed!
> >
> > Malik
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > I have looked at the SOAP method of integration as well as the URL
method,
> > > and it is just not possible to save report parameters as selected by
the
> > > user! The only way you can save them is if you re-invent your own
> > parameter
> > > inputs! And keep in mind that a complete integration solution should
be
> > able
> > > to accept any possible combination of report parameters!
> > >
> > > I think this is another oversight in the design of this product from
> > > microsoft. They have specially designed ways to cache report data,
saving
> > > history, etc... But what about the more common case of wanting fresh
data
> > > for the same parameters? I am amazed that they did not think of
this...
> > >
> > > Is there anything like this in the works for version 2... Yes?
> > >
> > > Please tell me yes :-]
> > >
> > > Malik
> > >
> > >
> > >
> >
> >
>
>|||If the web application provided it's own parameter prompting area and passed along that data to our
Report Viewer then you could build this logic into your web application instead of relying on RS to
do it.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Donovan,
> Thanks very much for your report. This is exactly the kind of solution I
> need, although there are still a few problems.
> I thought of doing it this way, but I am trying to fully integrate SQL RS
> with our Web Application. I don't want to have to explain to our customers
> that in order to design reports for use with our application you have to
> always have those extra data sources present along with code to retrieve the
> parameters. This puts the onus on the report developer to be a coder rather
> than me taking care of the whole solution myself.
> I suppose I could come up with some kind of template report that our
> customers can start with, and that would make this a workable solution for
> us. I am going over your report in more detail to see what I can learn from
> it.
> Your help has been quite valuable for my project, and I really appreciate
> you sending the report!
> Thank you very much indeed,
> Malik
> "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > Take a look at the attached report for help. It goes against the pubs
> sample database and requires
> > a SQL script to be run on the db prior to use.
> >
> > --
> > Thanks.
> >
> > Donovan R. Smith
> > Software Test Lead
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Let me also clarify that the difficulty here is getting the parameter
> input
> > > from the user.
> > >
> > > If I already know what parameters I want to run the report for, there is
> no
> > > problem.
> > >
> > > The problem is, the user can change them and then re-run the report, and
> I
> > > have no idea
> > > what parameters are currently in the report being displayed!
> > >
> > > Malik
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > I have looked at the SOAP method of integration as well as the URL
> method,
> > > > and it is just not possible to save report parameters as selected by
> the
> > > > user! The only way you can save them is if you re-invent your own
> > > parameter
> > > > inputs! And keep in mind that a complete integration solution should
> be
> > > able
> > > > to accept any possible combination of report parameters!
> > > >
> > > > I think this is another oversight in the design of this product from
> > > > microsoft. They have specially designed ways to cache report data,
> saving
> > > > history, etc... But what about the more common case of wanting fresh
> data
> > > > for the same parameters? I am amazed that they did not think of
> this...
> > > >
> > > > Is there anything like this in the works for version 2... Yes?
> > > >
> > > > Please tell me yes :-]
> > > >
> > > > Malik
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>|||Yes, I could write my own code to take care of parameter input, which would
have to do the following:
- prompt for any combination of parameters
- include default values and available values, with queried available
values in a drop-down list
- validate all parameter data types entered, null and blank values
- correctly take hidden parameters from the URL when they are passed
This would have to be robust enough for any report that my customers can
design to work with my web app.
I don't want to be lazy, but since RS already does all of this, I don't want
to re-invent the wheel.
I think it would be much easier for someone who already knows what
parameters are in the reports. In my scenario, our customers will expect to
just open a SQL RS report from our web app. They may design their own, or
get reports from elsewhere. It is a full integration.
I am still very much in design mode (although I should have finished long
ago :-) so I am quite open to suggestions.
Thanks again for your help.
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:eCLqPftiEHA.3896@.TK2MSFTNGP15.phx.gbl...
> If the web application provided it's own parameter prompting area and
passed along that data to our
> Report Viewer then you could build this logic into your web application
instead of relying on RS to
> do it.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> > Donovan,
> >
> > Thanks very much for your report. This is exactly the kind of solution I
> > need, although there are still a few problems.
> >
> > I thought of doing it this way, but I am trying to fully integrate SQL
RS
> > with our Web Application. I don't want to have to explain to our
customers
> > that in order to design reports for use with our application you have to
> > always have those extra data sources present along with code to retrieve
the
> > parameters. This puts the onus on the report developer to be a coder
rather
> > than me taking care of the whole solution myself.
> >
> > I suppose I could come up with some kind of template report that our
> > customers can start with, and that would make this a workable solution
for
> > us. I am going over your report in more detail to see what I can learn
from
> > it.
> >
> > Your help has been quite valuable for my project, and I really
appreciate
> > you sending the report!
> >
> > Thank you very much indeed,
> > Malik
> >
> > "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in
message
> > news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > > Take a look at the attached report for help. It goes against the pubs
> > sample database and requires
> > > a SQL script to be run on the db prior to use.
> > >
> > > --
> > > Thanks.
> > >
> > > Donovan R. Smith
> > > Software Test Lead
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > > Let me also clarify that the difficulty here is getting the
parameter
> > input
> > > > from the user.
> > > >
> > > > If I already know what parameters I want to run the report for,
there is
> > no
> > > > problem.
> > > >
> > > > The problem is, the user can change them and then re-run the report,
and
> > I
> > > > have no idea
> > > > what parameters are currently in the report being displayed!
> > > >
> > > > Malik
> > > >
> > > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > > I have looked at the SOAP method of integration as well as the URL
> > method,
> > > > > and it is just not possible to save report parameters as selected
by
> > the
> > > > > user! The only way you can save them is if you re-invent your own
> > > > parameter
> > > > > inputs! And keep in mind that a complete integration solution
should
> > be
> > > > able
> > > > > to accept any possible combination of report parameters!
> > > > >
> > > > > I think this is another oversight in the design of this product
from
> > > > > microsoft. They have specially designed ways to cache report data,
> > saving
> > > > > history, etc... But what about the more common case of wanting
fresh
> > data
> > > > > for the same parameters? I am amazed that they did not think of
> > this...
> > > > >
> > > > > Is there anything like this in the works for version 2... Yes?
> > > > >
> > > > > Please tell me yes :-]
> > > > >
> > > > > Malik
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>