End User Utility

I heard some talk in the past about a tool called Data Views, or
something close to that name, that will be the end user tool for
Reporting Services. Currently, I can't seem to find any information on
it and my company is evaluating Reporting Services. We are looking for
some sort of information on end user tools that can be used to help
them write reports with RS instead of using visual studio. Any ideas
or suggestions?
ThanksMore information on Report Builder (aka Active Views) is available here:
http://www.microsoft.com/sql/reporting/productinfo/av_activeviews.asp
More detailed information will be available closer to RS 2005 Beta 3.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <cooperb@.gmail.com> wrote in message
news:6aba6d9.0411300723.7ea6957c@.posting.google.com...
> I heard some talk in the past about a tool called Data Views, or
> something close to that name, that will be the end user tool for
> Reporting Services. Currently, I can't seem to find any information on
> it and my company is evaluating Reporting Services. We are looking for
> some sort of information on end user tools that can be used to help
> them write reports with RS instead of using visual studio. Any ideas
> or suggestions?
> Thanks

Encryption Keys (Reporting Services Configuration)

Ok I am playing around with SQL Server 2005 got it all setup. Then I decided to change the admin password and run dcpromo. Now I got all the issues resolved except this one. It had a key from what the server use to be called. I deleted it to make a new key for the state of the server now. Well big mistake I am finding out. Below are the only real directions I have found to recreate the key and it is not a lot of help. Does anyone know how to do this? Not like SQL Server 2000 to many choices and I got click happy on over load. Thanks in advance...

SQL Server Setup Help

Encryption Keys (Reporting Services Configuration)
Delete
Deletes the symmetric key and all encrypted content, including connection strings and stored credentials. You should only delete the symmetric key if you cannot restore it.

Once you delete the symmetric key, you must re-enter the missing connection strings and stored credentials in the reports and shared data sources that no longer have these values. You must also update all subscriptions that use delivery extensions that store encrypted data. This includes the file share delivery extension and any third-party delivery extension that use encrypted value.

There is no automated way to update this information. Each report, subscription, and shared data source that uses stored credentials and connection strings must be updated one at a time.

Initialization (Reporting Services Configuration)
Remove
Click Remove to remove the encryption keys of the selected report server instance from the report server database. You can remove keys to remove a report server from a scale-out deployment. With this option, only the encryption keys for the specified report server instance are removed. Encrypted data in the report server database is not affected.

As a precaution, be sure to create a backup copy of the symmetric key before you remove it. Once you remove the encryption keys of the last report server in the list, you introduce new requirements for any subsequent report server initialization for that database. The new requirement is that after you initialize a report server you must restore a backup copy of the symmetric key. Restoring the symmetric key is necessary if you want to access the encrypted data that is currently in the report server database.

If you no longer need the encrypted data or if you do not have a backup copy of the key, you must delete the encrypted data. For more information, see Encryption Keys (Reporting Services Configuration).

Event Viewer Log

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 2/9/2006
Time: 11:13:32 PM
User: N/A
Computer: VM-IPDG3
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

If you don't have a backup of your key and you've deleted it, then the only thing you could do is to create a new key. From the "Encryption keys" panel in the config tool, click "change". By now you've lost all secure information, so you should reenter them. You need to redo the "Database setup" panel, and the credentials for data sources.|||

James Wu

Thanks for the reply I will try this when I get home. On the "Encyption Keys" panel in the configure reporting sections if memory serves me. The Change was disabled and the only two buttons out of the four I could click were Restore and Delete. The Change and Backup buttons were disabled. Can you supply a step by step to get where you are talking about.

I know if you go into

Microsoft SQL Server 2005|||

Yes your are right. "Change" and "Backup" will be disabled if your report server is not initialized. Here is a more detailed article on how to delete and recreate encryption keys :) http://msdn2.microsoft.com/en-us/library/ms156010.aspx

|||

James Wu

Thanks for the link I will research it now. I am using vmware so I reverted back a snapshot and started over. Made a few dumb errors that I should have been smarter not to do. Thanks Again

Encryption Key

I am getting the following error while configuring the reporting services on
my local machine. I cannot restore the key as I do not know the file or the
password.
Somebody please help!
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value
for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()Hello,
Are you installing a new version of Reporting Services (with clear
ReportServer database) or just reinstalling it with using previous version
of ReportServer database'
It looks like that you've reinstalled Reporting Services without recovering
previous encryption key.
If you don't have any copy of your previous encryption key, the only way to
make Reporting Services content available is to delete all unusable
encrypted data from ReportServer database.
Follow these steps to apply the encryption key to the report server
database:
1.. Run rskeymgmt.exe locally on the computer that hosts the report
server. You must use the -d apply argument. The following example
illustrates the argument you must specify:
rskeymgmt -d
2.. Restart Internet Information Service (IIS).
After the values are removed, you must re-specify the values as follows:
1.. Run rsconfig utility to specify a report server connection. This step
replaces the report server connection information. For more information, see
Configuring a Report Server Connection and rsconfig Utility.
2.. If you are supporting unattended report execution for reports that do
not use credentials, run rsconfig to specify the account used for this
purpose. For more information, see Configuring an Account for Unattended
Report Processing.
3.. For each report and shared data source that uses stored credentials,
you must retype the user name and password. For more information, see
Specifying Credential and Connection Information.
4.. Open and resave each subscription. Subscriptions retain residual
information about the encrypted credentials deleted during the rskeymgmt
delete operation. You can update the subscription by opening and saving it.
You do not need to modify or recreate it.
I hope this infomation will helpful.
Best Regards,
Radoslaw Lebkowski
U¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
>I am getting the following error while configuring the reporting services
>on
> my local machine. I cannot restore the key as I do not know the file or
> the
> password.
> Somebody please help!
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
> value
> for the "LogonCred" configuration setting cannot be decrypted.
> (rsFailedToDecryptConfigInformation)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
> mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()|||Hi Rad,
The very first step in trying to delete the key is giving me the same
exception which is ReportServicesConfigUI.WMIProvider.WMIProviderException:
The encrypted value
for the "LogonCred" configuration setting cannot be decrypted.
rskeymgmt -d -i instance
This is completely new installation in 2steps.
1. Installed sql server 2005 with all other services except reporting
services as iis was not installed at that time.
2. Installed reporting services.
"Radoslaw Lebkowski" wrote:
> Hello,
> Are you installing a new version of Reporting Services (with clear
> ReportServer database) or just reinstalling it with using previous version
> of ReportServer database'
> It looks like that you've reinstalled Reporting Services without recovering
> previous encryption key.
> If you don't have any copy of your previous encryption key, the only way to
> make Reporting Services content available is to delete all unusable
> encrypted data from ReportServer database.
> Follow these steps to apply the encryption key to the report server
> database:
> 1.. Run rskeymgmt.exe locally on the computer that hosts the report
> server. You must use the -d apply argument. The following example
> illustrates the argument you must specify:
> rskeymgmt -d
> 2.. Restart Internet Information Service (IIS).
> After the values are removed, you must re-specify the values as follows:
> 1.. Run rsconfig utility to specify a report server connection. This step
> replaces the report server connection information. For more information, see
> Configuring a Report Server Connection and rsconfig Utility.
> 2.. If you are supporting unattended report execution for reports that do
> not use credentials, run rsconfig to specify the account used for this
> purpose. For more information, see Configuring an Account for Unattended
> Report Processing.
> 3.. For each report and shared data source that uses stored credentials,
> you must retype the user name and password. For more information, see
> Specifying Credential and Connection Information.
> 4.. Open and resave each subscription. Subscriptions retain residual
> information about the encrypted credentials deleted during the rskeymgmt
> delete operation. You can update the subscription by opening and saving it.
> You do not need to modify or recreate it.
> I hope this infomation will helpful.
> Best Regards,
> Radoslaw Lebkowski
>
> U¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa³ w wiadomo¶ci
> news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
> >I am getting the following error while configuring the reporting services
> >on
> > my local machine. I cannot restore the key as I do not know the file or
> > the
> > password.
> > Somebody please help!
> >
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
> > value
> > for the "LogonCred" configuration setting cannot be decrypted.
> > (rsFailedToDecryptConfigInformation)
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
> > mo)
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
>
>|||Hmm, that's a little strange situation.
Under the following link there is a very similar problem with LogonCred
decryption problem.
http://groups.google.pl/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ec7858be1ef25e24/9f72570a671b74e7?lnk=st&q=LogonCred+decrypted&rnum=1&hl=pl#9f72570a671b74e7
Maybe you have problem with authorization a connection to ReportServer
database (bad values contained in RSReportServer.config file used to connect
to the report server database)
Try to use rsconfig utility described below
http://msdn2.microsoft.com/en-us/library/aa179654(SQL.80).aspx
Regards
Radoslaw Lebkowski
U¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:7BC3B705-71DF-4B48-93FE-6959E94A51FF@.microsoft.com...
> Hi Rad,
> The very first step in trying to delete the key is giving me the same
> exception which is
> ReportServicesConfigUI.WMIProvider.WMIProviderException:
> The encrypted value
> for the "LogonCred" configuration setting cannot be decrypted.
> rskeymgmt -d -i instance
> This is completely new installation in 2steps.
> 1. Installed sql server 2005 with all other services except reporting
> services as iis was not installed at that time.
> 2. Installed reporting services.
> "Radoslaw Lebkowski" wrote:
>> Hello,
>> Are you installing a new version of Reporting Services (with clear
>> ReportServer database) or just reinstalling it with using previous
>> version
>> of ReportServer database'
>> It looks like that you've reinstalled Reporting Services without
>> recovering
>> previous encryption key.
>> If you don't have any copy of your previous encryption key, the only way
>> to
>> make Reporting Services content available is to delete all unusable
>> encrypted data from ReportServer database.
>> Follow these steps to apply the encryption key to the report server
>> database:
>> 1.. Run rskeymgmt.exe locally on the computer that hosts the report
>> server. You must use the -d apply argument. The following example
>> illustrates the argument you must specify:
>> rskeymgmt -d
>> 2.. Restart Internet Information Service (IIS).
>> After the values are removed, you must re-specify the values as follows:
>> 1.. Run rsconfig utility to specify a report server connection. This
>> step
>> replaces the report server connection information. For more information,
>> see
>> Configuring a Report Server Connection and rsconfig Utility.
>> 2.. If you are supporting unattended report execution for reports that
>> do
>> not use credentials, run rsconfig to specify the account used for this
>> purpose. For more information, see Configuring an Account for Unattended
>> Report Processing.
>> 3.. For each report and shared data source that uses stored
>> credentials,
>> you must retype the user name and password. For more information, see
>> Specifying Credential and Connection Information.
>> 4.. Open and resave each subscription. Subscriptions retain residual
>> information about the encrypted credentials deleted during the rskeymgmt
>> delete operation. You can update the subscription by opening and saving
>> it.
>> You do not need to modify or recreate it.
>> I hope this infomation will helpful.
>> Best Regards,
>> Radoslaw Lebkowski
>>
>> U?ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa3 w
>> wiadomo?ci
>> news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
>> >I am getting the following error while configuring the reporting
>> >services
>> >on
>> > my local machine. I cannot restore the key as I do not know the file
>> > or
>> > the
>> > password.
>> > Somebody please help!
>> >
>> > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
>> > value
>> > for the "LogonCred" configuration setting cannot be decrypted.
>> > (rsFailedToDecryptConfigInformation)
>> > at
>> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
>> > mo)
>> > at
>> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
>>

Encrypted data in a report

I'm new to RS but how does one deal with encrypted data
within reporting services.
That is we have a table that has encrypted data. Is there
fuctionality within RS that allows the decrypting of that
data in generation of the report.
If there is, someone point me in the right direction.
Thanks,
WarrenUse embedded code or a custom assembly. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_84f9.asp?frame=true
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_6d0i.asp?frame=true
for details.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Warren Smith" <anonymous@.discussions.microsoft.com> wrote in message
news:978801c478b4$9af1f0d0$a401280a@.phx.gbl...
> I'm new to RS but how does one deal with encrypted data
> within reporting services.
> That is we have a table that has encrypted data. Is there
> fuctionality within RS that allows the decrypting of that
> data in generation of the report.
> If there is, someone point me in the right direction.
> Thanks,
> Warren
>
>

enable reomte error

Hello,
I got the error:
______________________
Reporting Services Error
* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________
I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."
How can I get to the ReportServer.ConfigurationInfo database table?
I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(
Where is this configuration?
Any help?
Thanks.Hello,
Follow the steps below.
Enable remote errors through script
Create a text file and copy the following script into the file.
Public Sub Main()
Dim P As New [Property]()
P.Name = "EnableRemoteErrors"
P.Value = True
Dim Properties(0) As [Property]
Properties(0) = P
Try
rs.SetSystemProperties(Properties)
Console.WriteLine("Remote errors enabled.")
Catch SE As SoapException
Console.WriteLine(SE.Detail.OuterXml)
End Try
End Sub
Save the file as EnableRemoteErrors.rss.
Click Start, point to Run, type cmd, and click OK to open a command prompt
window.
Navigate to the directory that contains the .rss file you just created.
Type the following command line, replacing servername with the actual name
of your server:
rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
Best regards,
Radoslaw Lebkowski
Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> Hello,
> I got the error:
> ______________________
> Reporting Services Error
> * For more information about this error navigate to the report
> server on the local server machine, or enable remote errors SQL Server
> Reporting Services
> ______________________
>
> I saw the answer:
> "You could set the "EnableRemoteErrors" configuration value to True in
> the ReportServer.ConfigurationInfo database table."
> How can I get to the ReportServer.ConfigurationInfo database table?
> I am on the reportservice server and I run "reporting services
> configuration manager" and the "sql server managment". I didn't saw
> that option :(
> Where is this configuration?
> Any help?
> Thanks.
>|||Hi Radoslaw,
Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?
If not, I'll use the script you sent me.
Thanks again.
Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
> Hello,
> Follow the steps below.
> Enable remote errors through script
> Create a text file and copy the following script into the file.
> Public Sub Main()
> Dim P As New [Property]()
> P.Name =3D "EnableRemoteErrors"
> P.Value =3D True
> Dim Properties(0) As [Property]
> Properties(0) =3D P
> Try
> rs.SetSystemProperties(Properties)
> Console.WriteLine("Remote errors enabled.")
> Catch SE As SoapException
> Console.WriteLine(SE.Detail.OuterXml)
> End Try
> End Sub
> Save the file as EnableRemoteErrors.rss.
> Click Start, point to Run, type cmd, and click OK to open a command prompt
> window.
> Navigate to the directory that contains the .rss file you just created.
> Type the following command line, replacing servername with the actual name
> of your server:
> rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> Best regards,
> Radoslaw Lebkowski
>
> Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > Hello,
> > I got the error:
> > ______________________
> > Reporting Services Error
> >
> > * For more information about this error navigate to the report
> > server on the local server machine, or enable remote errors SQL Server
> > Reporting Services
> > ______________________
> >
> >
> > I saw the answer:
> > "You could set the "EnableRemoteErrors" configuration value to True in
> > the ReportServer.ConfigurationInfo database table."
> >
> > How can I get to the ReportServer.ConfigurationInfo database table?
> >
> > I am on the reportservice server and I run "reporting services
> > configuration manager" and the "sql server managment". I didn't saw
> > that option :(
> >
> > Where is this configuration?
> >
> > Any help?
> > Thanks.
> >|||I think you can also use Enterprise Manager (for SQL 2000 database) or SQL
2005 Management Studio (for SQL 2005 server)
to change this value in ReportServer.ConfigurationInfo database table.
You have to connect to database server and ReportServer database and then
change value in ConfigurationInfo table.
Radoslaw Lebkowski
U¿ytkownik "nicknack" <roezohar@.gmail.com> napisa³ w wiadomo¶ci
news:1170768672.373595.150750@.k78g2000cwa.googlegroups.com...
Hi Radoslaw,
Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?
If not, I'll use the script you sent me.
Thanks again.
Radoslaw Lebkowski ?:
> Hello,
> Follow the steps below.
> Enable remote errors through script
> Create a text file and copy the following script into the file.
> Public Sub Main()
> Dim P As New [Property]()
> P.Name = "EnableRemoteErrors"
> P.Value = True
> Dim Properties(0) As [Property]
> Properties(0) = P
> Try
> rs.SetSystemProperties(Properties)
> Console.WriteLine("Remote errors enabled.")
> Catch SE As SoapException
> Console.WriteLine(SE.Detail.OuterXml)
> End Try
> End Sub
> Save the file as EnableRemoteErrors.rss.
> Click Start, point to Run, type cmd, and click OK to open a command prompt
> window.
> Navigate to the directory that contains the .rss file you just created.
> Type the following command line, replacing servername with the actual name
> of your server:
> rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> Best regards,
> Radoslaw Lebkowski
>
> Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > Hello,
> > I got the error:
> > ______________________
> > Reporting Services Error
> >
> > * For more information about this error navigate to the report
> > server on the local server machine, or enable remote errors SQL Server
> > Reporting Services
> > ______________________
> >
> >
> > I saw the answer:
> > "You could set the "EnableRemoteErrors" configuration value to True in
> > the ReportServer.ConfigurationInfo database table."
> >
> > How can I get to the ReportServer.ConfigurationInfo database table?
> >
> > I am on the reportservice server and I run "reporting services
> > configuration manager" and the "sql server managment". I didn't saw
> > that option :(
> >
> > Where is this configuration?
> >
> > Any help?
> > Thanks.
> >|||Thanks,
I'll try to find this elusive ReportServer.ConfigurationInfo database
Take care,
Roy.
Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
> I think you can also use Enterprise Manager (for SQL 2000 database) or SQL
> 2005 Management Studio (for SQL 2005 server)
> to change this value in ReportServer.ConfigurationInfo database table.
> You have to connect to database server and ReportServer database and then
> change value in ConfigurationInfo table.
>
> Radoslaw Lebkowski
>
>
> U=C2=BFytkownik "nicknack" <roezohar@.gmail.com> napisa=C2=B3 w wiadomo=C2==B6ci
> news:1170768672.373595.150750@.k78g2000cwa.googlegroups.com...
> Hi Radoslaw,
> Thanks for the replay.
> Is that the only way?
> Isn't there any simple way to change this with one of the
> configuration tools?
> If not, I'll use the script you sent me.
> Thanks again.
> Radoslaw Lebkowski ?:
> > Hello,
> >
> > Follow the steps below.
> >
> > Enable remote errors through script
> > Create a text file and copy the following script into the file.
> > Public Sub Main()
> > Dim P As New [Property]()
> > P.Name =3D "EnableRemoteErrors"
> > P.Value =3D True
> > Dim Properties(0) As [Property]
> > Properties(0) =3D P
> > Try
> > rs.SetSystemProperties(Properties)
> > Console.WriteLine("Remote errors enabled.")
> > Catch SE As SoapException
> > Console.WriteLine(SE.Detail.OuterXml)
> > End Try
> > End Sub
> > Save the file as EnableRemoteErrors.rss.
> > Click Start, point to Run, type cmd, and click OK to open a command pro=mpt
> > window.
> > Navigate to the directory that contains the .rss file you just created.
> > Type the following command line, replacing servername with the actual n=ame
> > of your server:
> > rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> >
> > Best regards,
> > Radoslaw Lebkowski
> >
> >
> > Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> > news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > > Hello,
> > > I got the error:
> > > ______________________
> > > Reporting Services Error
> > >
> > > * For more information about this error navigate to the report
> > > server on the local server machine, or enable remote errors SQL Server
> > > Reporting Services
> > > ______________________
> > >
> > >
> > > I saw the answer:
> > > "You could set the "EnableRemoteErrors" configuration value to True in
> > > the ReportServer.ConfigurationInfo database table."
> > >
> > > How can I get to the ReportServer.ConfigurationInfo database table?
> > >
> > > I am on the reportservice server and I run "reporting services
> > > configuration manager" and the "sql server managment". I didn't saw
> > > that option :(
> > >
> > > Where is this configuration?
> > >
> > > Any help?
> > > Thanks.
> > >

enable remote errors option?

Hello,

Reporting Services 2005 error messagess always state that for details the report should be run on the local machine or that remote errors should be enabled.

It might be a silly question, but how does one enable the remote errors?
I searched the BOL and the net but found no clues, just many error samples

We are facing situations where we can not log onto the server and rune the report from localhost/Reports....

ThanksNot sure but sounds like a .net error - it may be in the .config files?
CustomErrors="RemoteOnly" should be CustomErrors="Off" or something to that effect.|||

You could set the "EnableRemoteErrors" configuration value to True in the ReportServer.ConfigurationInfo database table.

Alternatively, you can use the SetSystemProperties SOAP call:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_63le.asp

-- Robert

|||Hi Robert,

Thanks. Thats what I was looking for. How about adding that to the Site settings form on the report manager?

P.S. I had to restart iis (5.0 ...) to make it take effect.

Thanks again for the quick reply

Enable Email Delivery of Reports

We have just installed SQL Server and Reporting Services. I'm trying to
setup automatic EMAIL delivery of some reports, but the only option I have
is to deliver to a file share.
How can I enable email delivery as a delivery option on SSRS? Thanks a ton
for your help.It won't be an option until you configure RS with an email source. You have
several options for this. My company has a smtp server around that does not
require a password to use to send email. Use the Reporting Services
Configuration tool to configure it for email.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"HBJimmie" <someone@.mydomain.com> wrote in message
news:4FFAADAD-A502-473B-96FB-2C5C525A495A@.microsoft.com...
> We have just installed SQL Server and Reporting Services. I'm trying to
> setup automatic EMAIL delivery of some reports, but the only option I have
> is to deliver to a file share.
> How can I enable email delivery as a delivery option on SSRS? Thanks a ton
> for your help.

Empty RS Home-folder after changing IIS properties

Hi,
I've installed Reporting Services on my laptop and built some folders and
reports, works great. But when other persons tried to access my reports they
only got an empty Home-folder when connecting (to http://myserver/Reports). I
tried to change properties at IIS/default website/reports/properties
(directory security/anonymous access and auth control/anonymous access) and
after that also I get an empty Home-folder. I can do/see nothing! As you
already noticed I'm a total newbie to webservers/security/domains etc. Any
tips to get the access to my reports back ? I've changed nothing but IIS
props.
/jerome kThis is not an IIS issue. You have to go in and set security on your folders in
Report Manager. Users must have at least Browser permissions to see anything in
the folders, including your root folder.
/jerome k wrote:
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports they
> only got an empty Home-folder when connecting (to http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access) and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k|||The problem here is when you set anonymous then everybody is treated the
same, i.e. not given access. Change IIS back the way it was. Then create a
local group and put the people you want to have access to it in the group.
Next read up about roles. RS is role based. You have to put Window users or
groups into a role (using Report Manager). The window user or group can
either be local or domain. I create a local group and then add my domain
user and groups to the local group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:1C173666-89C0-46EC-86E2-360F3202095D@.microsoft.com...
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports
> they
> only got an empty Home-folder when connecting (to
> http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access)
> and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k

Empty Recordset

New to Reporting Services.
I have written a stored procedure which I call from a report built with RS.
Certain parameters being passed to the procedure does not materialize a
record set, therefore, the report comes up blank, with no labels etc. What I
need to do is detect an empty record set, from within the report, and set
default values so the report does not appear blank. I have tried the
IsNothing function within each text boxes expressions, however, it does not
work. Has anyone run into this and if so, would you be so kind to provide a
solution?
Regards,
Fred
Regards,
FredHi,
maybe you can use the NoRows property of your table to display the desired
information?
"FredG" <FredG@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A5EDE86A-C658-4FF7-B0B1-F4CD33F196FF@.microsoft.com...
> New to Reporting Services.
> I have written a stored procedure which I call from a report built with
> RS.
> Certain parameters being passed to the procedure does not materialize a
> record set, therefore, the report comes up blank, with no labels etc. What
> I
> need to do is detect an empty record set, from within the report, and set
> default values so the report does not appear blank. I have tried the
> IsNothing function within each text boxes expressions, however, it does
> not
> work. Has anyone run into this and if so, would you be so kind to provide
> a
> solution?
> Regards,
> Fred
>
> Regards,
> Fred|||Hello Ralph,
Thank you for responding. I am not familiar with the NoRows property, do you
have an example? I tried searching the RS BOL but came up empty.
"Ralph Watermann" wrote:
> Hi,
> maybe you can use the NoRows property of your table to display the desired
> information?
> "FredG" <FredG@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:A5EDE86A-C658-4FF7-B0B1-F4CD33F196FF@.microsoft.com...
> > New to Reporting Services.
> > I have written a stored procedure which I call from a report built with
> > RS.
> > Certain parameters being passed to the procedure does not materialize a
> > record set, therefore, the report comes up blank, with no labels etc. What
> > I
> > need to do is detect an empty record set, from within the report, and set
> > default values so the report does not appear blank. I have tried the
> > IsNothing function within each text boxes expressions, however, it does
> > not
> > work. Has anyone run into this and if so, would you be so kind to provide
> > a
> > solution?
> >
> > Regards,
> > Fred
> >
> >
> > Regards,
> > Fred
>
>|||Hi Fred,
You could modify your stored procedure to test whether or not you
retrieve records depending on the parameters you pass. If the query in your
stored procedure does not return records, then you can pass a single record
with the default values in a Select statement, that you want to show in the
report...
Cheers,
Daniel.
"FredG" wrote:
> Hello Ralph,
> Thank you for responding. I am not familiar with the NoRows property, do you
> have an example? I tried searching the RS BOL but came up empty.
> "Ralph Watermann" wrote:
> > Hi,
> >
> > maybe you can use the NoRows property of your table to display the desired
> > information?
> >
> > "FredG" <FredG@.discussions.microsoft.com> schrieb im Newsbeitrag
> > news:A5EDE86A-C658-4FF7-B0B1-F4CD33F196FF@.microsoft.com...
> > > New to Reporting Services.
> > > I have written a stored procedure which I call from a report built with
> > > RS.
> > > Certain parameters being passed to the procedure does not materialize a
> > > record set, therefore, the report comes up blank, with no labels etc. What
> > > I
> > > need to do is detect an empty record set, from within the report, and set
> > > default values so the report does not appear blank. I have tried the
> > > IsNothing function within each text boxes expressions, however, it does
> > > not
> > > work. Has anyone run into this and if so, would you be so kind to provide
> > > a
> > > solution?
> > >
> > > Regards,
> > > Fred
> > >
> > >
> > > Regards,
> > > Fred
> >
> >
> >|||"NoRows" is an element that is a part of the "Properties" for a table. You
can specify a value in the table's "Properties" (under "Data") for the case
when there is no row to display.
"daniel_xi" wrote:
> Hi Fred,
> You could modify your stored procedure to test whether or not you
> retrieve records depending on the parameters you pass. If the query in your
> stored procedure does not return records, then you can pass a single record
> with the default values in a Select statement, that you want to show in the
> report...
> Cheers,
> Daniel.
>
> "FredG" wrote:
> > Hello Ralph,
> > Thank you for responding. I am not familiar with the NoRows property, do you
> > have an example? I tried searching the RS BOL but came up empty.
> >
> > "Ralph Watermann" wrote:
> >
> > > Hi,
> > >
> > > maybe you can use the NoRows property of your table to display the desired
> > > information?
> > >
> > > "FredG" <FredG@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > news:A5EDE86A-C658-4FF7-B0B1-F4CD33F196FF@.microsoft.com...
> > > > New to Reporting Services.
> > > > I have written a stored procedure which I call from a report built with
> > > > RS.
> > > > Certain parameters being passed to the procedure does not materialize a
> > > > record set, therefore, the report comes up blank, with no labels etc. What
> > > > I
> > > > need to do is detect an empty record set, from within the report, and set
> > > > default values so the report does not appear blank. I have tried the
> > > > IsNothing function within each text boxes expressions, however, it does
> > > > not
> > > > work. Has anyone run into this and if so, would you be so kind to provide
> > > > a
> > > > solution?
> > > >
> > > > Regards,
> > > > Fred
> > > >
> > > >
> > > > Regards,
> > > > Fred
> > >
> > >
> > >|||Hello Daniel,
That is exactly what I did to solve the problem. Thanks
"daniel_xi" wrote:
> Hi Fred,
> You could modify your stored procedure to test whether or not you
> retrieve records depending on the parameters you pass. If the query in your
> stored procedure does not return records, then you can pass a single record
> with the default values in a Select statement, that you want to show in the
> report...
> Cheers,
> Daniel.
>
> "FredG" wrote:
> > Hello Ralph,
> > Thank you for responding. I am not familiar with the NoRows property, do you
> > have an example? I tried searching the RS BOL but came up empty.
> >
> > "Ralph Watermann" wrote:
> >
> > > Hi,
> > >
> > > maybe you can use the NoRows property of your table to display the desired
> > > information?
> > >
> > > "FredG" <FredG@.discussions.microsoft.com> schrieb im Newsbeitrag
> > > news:A5EDE86A-C658-4FF7-B0B1-F4CD33F196FF@.microsoft.com...
> > > > New to Reporting Services.
> > > > I have written a stored procedure which I call from a report built with
> > > > RS.
> > > > Certain parameters being passed to the procedure does not materialize a
> > > > record set, therefore, the report comes up blank, with no labels etc. What
> > > > I
> > > > need to do is detect an empty record set, from within the report, and set
> > > > default values so the report does not appear blank. I have tried the
> > > > IsNothing function within each text boxes expressions, however, it does
> > > > not
> > > > work. Has anyone run into this and if so, would you be so kind to provide
> > > > a
> > > > solution?
> > > >
> > > > Regards,
> > > > Fred
> > > >
> > > >
> > > > Regards,
> > > > Fred
> > >
> > >
> > >

empty cellset issue with mdx in reporting services 2005

Hi all,
I am using reporting services 2005 based on analysis services 2005 cubes
datasource. I use oledb provider and connect to analysis services 9.0. I am
writing an expression in dataset which will evaluate to mdx query during
runtime. Now the issue is if the generated dynamic query cannot product even
a single row because of slicer, then I get an ugly error message.
If in a sql statement, the where clause we include make the query return
zero rows, then you wont see any data for your report, but you dont see an
error. But here in RS with mdx, you are getting error. How to avoid this? Is
there any work around available to solve this issue while creating datasets.
Thanks.Hello,
Thank you for your post in MSDN newsgroup!
To understand the issue better, I'd like to know the following information:
1. What is the exact error message you encountered? Is is saying there are
multiple measures in the WHERE clause even though there is only one
measure? If so, this shall be known issue in AS 2005.
2. Does the issue occur if you run the MDX directly on SSMS? If you use
"Microsoft SQL Server Analysis Services" instead of OlEDB provider for
Analysis Service, does the issue still occur?
3. If the error message is different from that mentioned above, will you
provide us a simple sample project by using Adventure works sample
database, so that we may be able to reproduce the issue on our side? YOu
could send it to me at petery@.microsoft.com.
If you have other related information, please also let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Just want to check in if you have further questions on the issue. Please
feel free to post back if need any help.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================