Configure IIS for Reporting Manager and reporting server site

Dear All:

My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same.

But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me?

My IIS 5.1
Reporting service 2005 Express with SQL Server Express
ASP.NET 2.0 Express.

Please help.

Thanks in Advance

Emmanuel MathewDear All:

I got it somehow worked. But now the problem is that when I take the report manager and display the report, it shows me a wrongly formatted page with "Object reference not set to an isntance of an Object"

But in server, even though I am getting the unformatted (Like CSS is not applied), I get the report correctly. Is there anything wrong with the ath of CSS?

And what is this "Object reference error"? Could you please help me.

Thanks
Emmanuel Mathew|||Can you tell us the stack trace in report service log file? Also is there any error in the reporting services configuration tool (not sure if it comes with RS express)?|||Dear Friend:

There is no error screen to take a stack trace. Let me explain. When I give the URL, the reporting manager comes nicely. Then when I click on one of the report, usually, the parameter and the view report button should appear. It appears. But they are all mis aligned. And when Press on the view report, the image which shows the processing rotates and then shows the error in a single line "Object reference not set to an instance of an Object"

When I open the reporting server, I get the directory listing and then when I click on one of the report, the report comes mis aligned as in report manager. But when I click on the view report, it shows the report even though its looking ugly. I get the error only in reporting manager.

Let me tell you what had happened earlier too. One day when I opened the machine, my IIS got an unexpected error and it did not start. SO I reisntalled the same. After reinstalling, I saw that the reporting manager and the server virtual folders are gone. So I created the same and ran the command Reg IIS to register IIS for the ASP.NET 2. I have .NET, sql server and the reporting services which are all express editions installed in the machine. Everything was working fine till I find one day my IIS got corrupted.

Lot of thanks for the support. And thanks in Advance.

Emmanuel Mathew|||I reinstalled IIS and the server stated working fine now. I know its not the solution. But I made it working. Thanks a lot for your help.

Configure IIS for Reporting Manager and reporting server site

Dear All:

My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same.

But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me?

My IIS 5.1
Reporting service 2005 Express with SQL Server Express
ASP.NET 2.0 Express.

Please help.

Thanks in Advance

Emmanuel MathewDear All:

I got it somehow worked. But now the problem is that when I take the report manager and display the report, it shows me a wrongly formatted page with "Object reference not set to an isntance of an Object"

But in server, even though I am getting the unformatted (Like CSS is not applied), I get the report correctly. Is there anything wrong with the ath of CSS?

And what is this "Object reference error"? Could you please help me.

Thanks
Emmanuel Mathew|||Can you tell us the stack trace in report service log file? Also is there any error in the reporting services configuration tool (not sure if it comes with RS express)?|||Dear Friend:

There is no error screen to take a stack trace. Let me explain. When I give the URL, the reporting manager comes nicely. Then when I click on one of the report, usually, the parameter and the view report button should appear. It appears. But they are all mis aligned. And when Press on the view report, the image which shows the processing rotates and then shows the error in a single line "Object reference not set to an instance of an Object"

When I open the reporting server, I get the directory listing and then when I click on one of the report, the report comes mis aligned as in report manager. But when I click on the view report, it shows the report even though its looking ugly. I get the error only in reporting manager.

Let me tell you what had happened earlier too. One day when I opened the machine, my IIS got an unexpected error and it did not start. SO I reisntalled the same. After reinstalling, I saw that the reporting manager and the server virtual folders are gone. So I created the same and ran the command Reg IIS to register IIS for the ASP.NET 2. I have .NET, sql server and the reporting services which are all express editions installed in the machine. Everything was working fine till I find one day my IIS got corrupted.

Lot of thanks for the support. And thanks in Advance.

Emmanuel Mathew|||I reinstalled IIS and the server stated working fine now. I know its not the solution. But I made it working. Thanks a lot for your help.

configuration tool

In SSRS 2005, where do I find Reporting Services Configuration tool ?
Thanks

Assuming you installed SSRS 2005 on C-drive then the path should be "C:\Program Files\Microsoft SQL Server\90\Tools\binn\RSConfigTool.exe"

configuration tool

In SSRS 2005, where do I find Reporting Services Configuration tool ?
Thanksstart > programs > ms sql server 2005 > configuration tools > reporting
services configuration
OR
"\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:75425385-15FE-4C68-B634-1F953713D9E6@.microsoft.com...
> In SSRS 2005, where do I find Reporting Services Configuration tool ?
> Thanks|||I am now in E-mail settings for SSRS 2005
It is asking for Sender address and SMTP address.
I guess I can get hold of the SMTP address which is probably the server the
send the emails but not sure what to place for Sender address ?
Thanks
"Immy" wrote:
> start > programs > ms sql server 2005 > configuration tools > reporting
> services configuration
> OR
> "\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:75425385-15FE-4C68-B634-1F953713D9E6@.microsoft.com...
> > In SSRS 2005, where do I find Reporting Services Configuration tool ?
> > Thanks
>
>|||whatever you want.
e.g Reporting@.server.com
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:A21C5499-5FA5-4FFB-BD7E-78972D0E8D15@.microsoft.com...
>I am now in E-mail settings for SSRS 2005
> It is asking for Sender address and SMTP address.
> I guess I can get hold of the SMTP address which is probably the server
> the
> send the emails but not sure what to place for Sender address ?
> Thanks
>
> "Immy" wrote:
>> start > programs > ms sql server 2005 > configuration tools > reporting
>> services configuration
>> OR
>> "\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"
>> "farshad" <farshad@.discussions.microsoft.com> wrote in message
>> news:75425385-15FE-4C68-B634-1F953713D9E6@.microsoft.com...
>> > In SSRS 2005, where do I find Reporting Services Configuration tool ?
>> > Thanks
>>|||If the emails do not get sent, is there a place to check for status? i.e.
error message as for why email was not sent?
Thanks
"Immy" wrote:
> whatever you want.
> e.g Reporting@.server.com
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:A21C5499-5FA5-4FFB-BD7E-78972D0E8D15@.microsoft.com...
> >I am now in E-mail settings for SSRS 2005
> > It is asking for Sender address and SMTP address.
> > I guess I can get hold of the SMTP address which is probably the server
> > the
> > send the emails but not sure what to place for Sender address ?
> > Thanks
> >
> >
> > "Immy" wrote:
> >
> >> start > programs > ms sql server 2005 > configuration tools > reporting
> >> services configuration
> >>
> >> OR
> >>
> >> "\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"
> >>
> >> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> >> news:75425385-15FE-4C68-B634-1F953713D9E6@.microsoft.com...
> >> > In SSRS 2005, where do I find Reporting Services Configuration tool ?
> >> > Thanks
> >>
> >>
> >>
>
>sqlsql

Configuration SQL Server 2005 Report Services

I have SQL Server 2005 and SQL Reporting Services installed on my server
with IIS.
I would like to obtain instructions to configure the SQL Reporting Services
on this server.
Thank You,Hi,
I suggest you start your reading with the page "Configuring Reporting
Services Components " in SQL Server 2005 Books Online. Several
relevant topics link from there.
Andrew Watt [MVP]
On Thu, 20 Apr 2006 16:40:02 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:
>I have SQL Server 2005 and SQL Reporting Services installed on my server
>with IIS.
>I would like to obtain instructions to configure the SQL Reporting Services
>on this server.
>Thank You,

Configuration problem (WMIProviderException)

I installed Reporting Services on stand-alone server from a SQL Server 2005
Standard CD. It supposed to connect to a remote SQL Server that would host
the ReportServer database.
I went through the steps of the Configure Report Server till I got to
"Database Setups". I created a new ReportServer database and when click on
"Apply", I get the following warning:
-- QUOTE --
Setting Connection Info for Report Server
Although saving tghe database succeeded, the report server cannot access
internal information about deployment to determine whether the current
configuration is valid for this edition. [...]
-- UNQUOTE --
When I click on the link to show me more information, I get the following
reported exception:
-- QUOTE --
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
-- UNQUOTE --
I'm not trying to set up a scale-out deployment. I want this single instance
of RS to connect to a remote database, and I verifiied that this is supported
by the Standard Edition of SQL Server 2005.
When I ignored this warning and moved the encryption keys stage of the
configuration, I found that only the Restore and Delete are enabled. If
clicked on "Delete", I get this error:
-- QUOTE --
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
-- UNQUOTE --
I verified that the Reporting Server was actually able to connect to the
database to create the Reporting Server database. But somehow it cannot
connect anymore.
Any ideas as to why?
ThanksI am experiencing the exact same problem. Did you get this resolved? Also, I
am curious as to whether you are running a side-by-side installation with SQL
2000 (as I am) or simply using SQL 2005?
Anyone know the solution to this? I've been working on this for several days
now, to no avail
"Homam" wrote:
> I installed Reporting Services on stand-alone server from a SQL Server 2005
> Standard CD. It supposed to connect to a remote SQL Server that would host
> the ReportServer database.
> I went through the steps of the Configure Report Server till I got to
> "Database Setups". I created a new ReportServer database and when click on
> "Apply", I get the following warning:
> -- QUOTE --
> Setting Connection Info for Report Server
> Although saving tghe database succeeded, the report server cannot access
> internal information about deployment to determine whether the current
> configuration is valid for this edition. [...]
> -- UNQUOTE --
> When I click on the link to show me more information, I get the following
> reported exception:
> -- QUOTE --
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
> cannot open a connection to the report server database. A connection to the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
> -- UNQUOTE --
> I'm not trying to set up a scale-out deployment. I want this single instance
> of RS to connect to a remote database, and I verifiied that this is supported
> by the Standard Edition of SQL Server 2005.
> When I ignored this warning and moved the encryption keys stage of the
> configuration, I found that only the Restore and Delete are enabled. If
> clicked on "Delete", I get this error:
> -- QUOTE --
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
> cannot open a connection to the report server database. A connection to the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
> -- UNQUOTE --
>
> I verified that the Reporting Server was actually able to connect to the
> database to create the Reporting Server database. But somehow it cannot
> connect anymore.
> Any ideas as to why?
>
> Thanks
>

Configuration of Reporting Services

obviously until I get this sorted I cannot deploy my reports

in my Reporting Services Configuration

All ticked except initialisation (3)

in Database services ticked but on the right hand side there are warnings/errors

Verifying Database Edition - ticked

Verifying Database Version - warning

The current connection string is not valid and can't be used to connect to SQL Server

Where do I check this? (1)

Creating A Grant Rights script for LocalSystem = ticked

Assigning Reporting Services Rights to User = error (2)

System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

Can someone tell me what I should be checking please?

thanks

HI !!!

I am also facing the same problem, The database server is sql 2000 personal edition while reporting server is sql 2005 evaluation.

In 'Database Setup' option displayes 'success'; but 'Verify Database Version' and 'Setting Connection Info For Reporting Server' are warnings while 'Create grants rights script' task is failing.

The 'Initialization' option is also failing. The message displayed is 'The report server cannot open connection to report server database (rsReportServerDatabaseUnavailable)'

Which setting should I check in report configuration? Or is this backward compatibility issue?

|||

On your reporting database,

Make sure under Security/Roles - that the RSExecRole exist, if not create it. It should also be assigned to the schema of RSExecRole. Finally, on your report service login User make sure that this user is assigned under the RSExecRole.

I hope this helps.

Ham

|||

HI Ham,

Thanks a lot for the reply.

I'll try out the solution suggested by you and let you know the outcome after that.

-Nishad

|||

Ham,

I am having the same problem. I need extra clarification, though. When you say check under Security/Roles, are you talking about doing this on the Reporting Services server or the database engine server that reporting services is connected to?

For instance, in my Object Explorer I see my reporting services server and under that in the tree is Security -> Roles. However, when I try to right-click on anything there it gives me the following message:

Unhandled exception has occured in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. the expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase).

Furthermore, when I try to upgrade the database by clicking 'Upgrade' in the Database Setup section of the Reporting Services Configuration Manager it gives me a green check on Verifying Database Edition and a yellow exclamation mark on Verifying Database Version. The warning says:

The current connection string is not valid and can't be used to connect to SQL Server.

So, if you mean I should add the RSExecRole to Security/Roles under my reporting services server, then I am in even deeper trouble than I thought. However, if you mean I should add them to Security/Server Roles under my database engine tree then I'm probably back in business.

I am loathe to try anything until I get clarification. Thanks for your kind help!

|||

Nevermind, I solved my problem.

I just needed to click the New button on the Database Setup page before trying to connect. Pretty silly on my part, but all's well that ends well.

|||

Ham and Philip,

I am having similary problem. When i am trying to get connection with my existing database, It says in task status

1- Varifying Database Edition (Pass)

2- Verifying Database Version (! Exclamitaion)

3- Creating Grant Rights for ServerName\UserName (Not Pass X)

In the browser when i am typing http://LocalServer/ReportServer That generate error that is

Reporting Services Error

---

The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)|||

Irfan,

If I remember correctly from when I was having my troubles, this may be due to ASPNET permissions on your web server.

You might google ASPNET reporting services server persmissions or something like that.

Best luck to you!

|||

Irfan,

This is stating that the "Report Database is failing" - First, verify that the login setup for Report Server logon in the Report Configuration Manager is correct.

You can verify that by connecting to the SQL2005 via studio management with the report server logon credentials

let me know if this works for you.

Configuration of Reporting Services

obviously until I get this sorted I cannot deploy my reports

in my Reporting Services Configuration

All ticked except initialisation (3)

in Database services ticked but on the right hand side there are warnings/errors

Verifying Database Edition - ticked

Verifying Database Version - warning

The current connection string is not valid and can't be used to connect to SQL Server

Where do I check this? (1)

Creating A Grant Rights script for LocalSystem = ticked

Assigning Reporting Services Rights to User = error (2)

System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

Can someone tell me what I should be checking please?

thanks

HI !!!

I am also facing the same problem, The database server is sql 2000 personal edition while reporting server is sql 2005 evaluation.

In 'Database Setup' option displayes 'success'; but 'Verify Database Version' and 'Setting Connection Info For Reporting Server' are warnings while 'Create grants rights script' task is failing.

The 'Initialization' option is also failing. The message displayed is 'The report server cannot open connection to report server database (rsReportServerDatabaseUnavailable)'

Which setting should I check in report configuration? Or is this backward compatibility issue?

|||

On your reporting database,

Make sure under Security/Roles - that the RSExecRole exist, if not create it. It should also be assigned to the schema of RSExecRole. Finally, on your report service login User make sure that this user is assigned under the RSExecRole.

I hope this helps.

Ham

|||

HI Ham,

Thanks a lot for the reply.

I'll try out the solution suggested by you and let you know the outcome after that.

-Nishad

|||

Ham,

I am having the same problem. I need extra clarification, though. When you say check under Security/Roles, are you talking about doing this on the Reporting Services server or the database engine server that reporting services is connected to?

For instance, in my Object Explorer I see my reporting services server and under that in the tree is Security -> Roles. However, when I try to right-click on anything there it gives me the following message:

Unhandled exception has occured in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. the expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase).

Furthermore, when I try to upgrade the database by clicking 'Upgrade' in the Database Setup section of the Reporting Services Configuration Manager it gives me a green check on Verifying Database Edition and a yellow exclamation mark on Verifying Database Version. The warning says:

The current connection string is not valid and can't be used to connect to SQL Server.

So, if you mean I should add the RSExecRole to Security/Roles under my reporting services server, then I am in even deeper trouble than I thought. However, if you mean I should add them to Security/Server Roles under my database engine tree then I'm probably back in business.

I am loathe to try anything until I get clarification. Thanks for your kind help!

|||

Nevermind, I solved my problem.

I just needed to click the New button on the Database Setup page before trying to connect. Pretty silly on my part, but all's well that ends well.

|||

Ham and Philip,

I am having similary problem. When i am trying to get connection with my existing database, It says in task status

1- Varifying Database Edition (Pass)

2- Verifying Database Version (! Exclamitaion)

3- Creating Grant Rights for ServerName\UserName (Not Pass X)

In the browser when i am typing http://LocalServer/ReportServer That generate error that is

Reporting Services Error

---

The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)|||

Irfan,

If I remember correctly from when I was having my troubles, this may be due to ASPNET permissions on your web server.

You might google ASPNET reporting services server persmissions or something like that.

Best luck to you!

|||

Irfan,

This is stating that the "Report Database is failing" - First, verify that the login setup for Report Server logon in the Report Configuration Manager is correct.

You can verify that by connecting to the SQL2005 via studio management with the report server logon credentials

let me know if this works for you.

Configuration Help

I am running 2005 reporting services and 2005 visual studio. I have a
c# .net web application located in the default web directory in IIS
that uses forms authentication, but that authentication is to active
directory using an ldap call inside the code. We set it up that way so
the user can log in to a normal page instead of the windows pop-up
login. I have reporting services running inside the web site directory.
It is setup to use windows authentication. I have the user login into
the web site and then when they go to run a report a windows login box
appears and they have to login again. Does anyone know how I can
authenticate to reporting services in the background so the user does
not see the windows pop-up login.
Thanks in advance,
JasonWrite a FormsAuthentication extension to MSRS.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
When you app hits LDAP, you can also authenticate against MSRS and grab
the auth cookies for MSRS. Your other options is to hijacks the
ASP.NET pipeline when a user requests an MSRS report and perform the
auth on demand.
Andy Pottersqlsql

Configuration file for reporting server project

Hi!
Is it somehow possible to create a configuration file for a reporting server
project. Something similar like the web.config or app.config file in .NET
applications?
What I wanna do is to store the link of a picture file. I don't want to
hard-code that in every report.
Are there any other options than storing this link in a config file?
Cheers, RogerOn Jul 17, 8:37 am, "Roger Frei" <s...@.hotmail.com> wrote:
> Hi!
> Is it somehow possible to create a configuration file for a reporting server
> project. Something similar like the web.config or app.config file in .NET
> applications?
> What I wanna do is to store the link of a picture file. I don't want to
> hard-code that in every report.
> Are there any other options than storing this link in a config file?
> Cheers, Roger
What you could try doing is include a link to a picture file in a
report and then check the XML structure of the underlying RDL file in
a text editor (Notepad, Wordpad, etc). Then change the path in the RDL
file via a custom application that creates the RDL file on the fly.
This might be a bit tedious but it may be the only option.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 17, 2:37 pm, "Roger Frei" <s...@.hotmail.com> wrote:
> Hi!
> Is it somehow possible to create a configuration file for a reporting server
> project. Something similar like the web.config or app.config file in .NET
> applications?
> What I wanna do is to store the link of a picture file. I don't want to
> hard-code that in every report.
> Are there any other options than storing this link in a config file?
> Cheers, Roger
Roger,
Add the picture file to your report project - deploy and hide - no ?

Configuration Error on Encryption Key

I came across an issue while configuring SQL Server 2005 Reporting Services. In the reporting services configuration tool, there is a step the either Backup, Restore, or Change the encryption key for the new Reporting Services instance. I backed up the key since this is the first installation of SQL Server and Reporting Services on this machine.

I had expected that the configuration would then allow me to progress to the next step in the configuration, "Initialization". But regardless of how I handle the Encryption Key step, the option to move "Initialization" does not become available.
Has anyone had this happen to them? Or better yet, does anyone have a solution to this?

The report server only needs to be manually initialized if you are connecting the server to a web farm. It is needed to ensure that all nodes in the farm are using the same encryption key. In your case, since you have backed up the key, the report server is already initialized. The option is likely disabled because you are using an edition of SQL Server that does not support web farms (it is only available in enterprise and developer editions).|||Yep, I found that to be the case yesterday while trying to troubleshoot this.
I was checking on another server trying to find where the setup went wrong and determined that the issue is actually that the Initialization step didn't become available as it should. There must have been an error in one of the preceding steps that didn't show up as it should have.
At this point I am going to try and run the command-line initialization to complete the setup. And if that doesn't work, I'll probably have to uninstall and re-install Reporting Services.

Configuartion & Deployment

Please kindly recommend good links/tutorials on configuration & deployment of reporting services.
Thanks much.

I posted the script required to deploy reports and other dependant files here ...http://www.bassicsoftware.com/CodeLibrary.aspx?searchcategory=29
Click on"Publish Reports to SQL Reporting Services"
Sorry for not having place much comments in the code

|||Hey i wanna know if there is any way that you can specify in the deployment script, the data source that your reports will be using.
Thanks|||The datasource should be defined in your RDL file.
btw, you can edit the rdl file using Notepad.|||One more thing...Does the datasource have to be in the same folder as the .rdl file or not.
If not then how can i give that in my .rss file.|||In the publishReports.rss you only specify the datasource by name.
In order to setup your datasources on the server (Local or Remote) you can do this manualy or create an rss script to publish them similiar to the publishReports.rss.
If I have time I'll post a sample of the script.|||Thanks,
You were right, the data source has to be defined in the .rdl file. there is a <datasourcereference> tag in the .rdl file that you need to edit in order to specify a datasource that is not in the same folder as the .rdl file, because, by default it is configured for data sources that are in the same folder. Still i havent found any way of specifying data sources on the fly at the time of deployment, and i dont think there is any...
Thanks Anyways...|||Note that a data source doesn't always mean referencing an RDS file, you may use a shared datasource.

Config Help for Server2003/sql2000/iis6 Reporting Services

Newbie alert. Need some configuration help please. Have web server with 3
websites on box above with same ip using host headers (well-established sites
working fine). Installed reporting services, went to one website and created
virtual directories with IIS to same folder/name as items under Default Web
Site. Authentication is set to IUSR_svrname, Integrated Windows on website
and virtual directories.
Created a basic report & deployed to http://serverName/reportServer. I can
view report by url similar
to:http://serverName/Reportserver?%2fFolderName%2freportName&rs:Command=Render Data connection and report retrieval is fine.
But, I need folks to be able to enter the www.domainname.com type of url and
that gives me a HTTP Error 403.8 - Forbidden: DNS name of the client is
rejected. As soon as I remove the report services part of the url, site
pops up fine. And, if possible, I'd like to be able to use more than one of
my domains, just referencing the virtual directory in IIS for each site.
Also, I cannot get to the http://serverName/Reports/Pages/Folder.aspx to set
roles and permissions because it only sees me as IUSR and I can't "see"
anything under that role. Even though I'm a domain administrator, believe
it's seeing me as IUSR.
Tried a few things but may be making it worse. Thanks for any advice-would
really like to be able to use this tool, but can't at this point.Update - think I'm really close, but still need help. Uninstalled,
reinstalled RS. Deployed sample. Added <ReportServerExternalURL>
http://www.domainname.org/Reports </ReportServerExternalURL> to
rswebapplication.config Deployed.
Created new role for IUSR_MachineName and gave it browse capabilities on
home folder.
Added virtual directory is IIS under web site above for Reports, with
documents of home.aspx and enable IUSR in IIS for directory. (Deployment is
still okay.) If I view Reports via machinename, site settings are there.
Browse to folder, click on report, the folder pops up again. Report will not
generate. If I view via www, site settings are not there (good, good).
Report does the same thing - popping up another folder view but not
generating.
Added virtual directory is IIS under web site above for ReportServer, with
document sof default.htm, default.asp, index.htm, iisstart.htm, default.aspx.
Same thing happens again.
Think I'm very close. Anybody?|||Finally got a reply on another forum so thought I'd pass it along. Even
though the documentation explicitly says:
"To access a report server on the Internet, you must add a
ReportServerExternalURL configuration setting that specifies the fully
qualified domain name of the report server. The external client uses this
value to access a report server. In this scenario, the browser that is
hosting Report Manager must send a fully qualified domain name when making
requests on behalf of Report Manager to the report server. The following
example illustrates the syntax for ReportServerExternalURL:
<ReportServerExternalURL> reports.adventure-works.com
</ReportServerExternalURL>"
When I replaced the UI with the following, things started rendering properly.
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
Hope it helps out someone else.

Confguring Report Builder

--Hello All ,
I am having a problem generating data models with SQL Reporting services
2005 from the web .I installed and configured 2005 Reporting services ,
created few reports and gave access to the users to view the reports from the
browser .Everything goes well till this point . But I don't see the "Generate
Model" button to generate a model from my current Data Source and use it in
the Report Builder feature from the web.I am trying to set this thing right
as it gives the end users to build their own reports from the web using
Report Builder.
Does it have to do with the security feature of Reporting Services ? If so
how can I configure the accounts ? [ I am using windows 2003 server with
IIS 6.0 and SQL Server 2005 CTP ]
Any help is highly appreciated .
thank you
K.This is controlled through the "Manage models" role, similar to all the
other RS security roles (e.g. "View reports", "Manage reports", etc.). Here
is a starting point for managing role level security in RS 2005:
http://msdn2.microsoft.com/ms228284(en-US,SQL.90).aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kallis" <Kallis@.discussions.microsoft.com> wrote in message
news:B9D96877-14FC-44FC-A99F-B2E63566E501@.microsoft.com...
> --Hello All ,
> I am having a problem generating data models with SQL Reporting services
> 2005 from the web .I installed and configured 2005 Reporting services ,
> created few reports and gave access to the users to view the reports from
> the
> browser .Everything goes well till this point . But I don't see the
> "Generate
> Model" button to generate a model from my current Data Source and use it
> in
> the Report Builder feature from the web.I am trying to set this thing
> right
> as it gives the end users to build their own reports from the web using
> Report Builder.
> Does it have to do with the security feature of Reporting Services ? If so
> how can I configure the accounts ? [ I am using windows 2003 server with
> IIS 6.0 and SQL Server 2005 CTP ]
> Any help is highly appreciated .
> thank you
> K.|||Robert,
Thank You for responding to my question . I gave the 'Content Manager' role
all the permissions inside Reporting server roles . From the browser , I
assigned the 'Content Manager' role to a group { local to the server where
IIS is installed}.Even then I am not able to view the 'Generate Models'
button besides 'Apply',Move & 'Delete' buttons . In addition to the above ,
when I run a report from report builder I get he following msg 'An attempt
has been made to use a data extension 'OLEDB-MD' that is not registered for
this report server'. How can I overcome this issue ?
Thanks for helping !!
-K
--
K
"Robert Bruckner [MSFT]" wrote:
> This is controlled through the "Manage models" role, similar to all the
> other RS security roles (e.g. "View reports", "Manage reports", etc.). Here
> is a starting point for managing role level security in RS 2005:
> http://msdn2.microsoft.com/ms228284(en-US,SQL.90).aspx
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kallis" <Kallis@.discussions.microsoft.com> wrote in message
> news:B9D96877-14FC-44FC-A99F-B2E63566E501@.microsoft.com...
> >
> > --Hello All ,
> >
> > I am having a problem generating data models with SQL Reporting services
> > 2005 from the web .I installed and configured 2005 Reporting services ,
> > created few reports and gave access to the users to view the reports from
> > the
> > browser .Everything goes well till this point . But I don't see the
> > "Generate
> > Model" button to generate a model from my current Data Source and use it
> > in
> > the Report Builder feature from the web.I am trying to set this thing
> > right
> > as it gives the end users to build their own reports from the web using
> > Report Builder.
> >
> > Does it have to do with the security feature of Reporting Services ? If so
> > how can I configure the accounts ? [ I am using windows 2003 server with
> > IIS 6.0 and SQL Server 2005 CTP ]
> >
> > Any help is highly appreciated .
> >
> > thank you
> >
> > K.
>
>

Conditional sum in reporting services

I need to find a conditional sum of sales if fields!Example.value = 0
(And same if fields!Example.value = 1)
How do I do that in reporting services?
Thanks
CS=Sum(IIf(Fields!Example.value=0,0,Fields!Example.Value))
"chetanasamal@.gmail.com" wrote:
> I need to find a conditional sum of sales if fields!Example.value = 0
> (And same if fields!Example.value = 1)
> How do I do that in reporting services?
> Thanks
> CS
>

Conditional Rows (New to reporting services)

I appologize in advance if this is a question that has already been asked. My
problem is this, I am creating a report that will run on a daily basis, and I
need to add weekly total lines. Something along the lines of, if the day is
friday then add the row, which would calculate the totals for the week.
The other option, would be to populate all of the days of the month,
including a week total and month total line every time I run it. Help! I am
stuck here...
Thank you!
lhagertyUse a different dataset with a table or list which fetches the week row? If
it's not friday no row will be returned. Test the number of rows fetched to
determine if you display the table or list
Erik
"lhagerty" wrote:
> I appologize in advance if this is a question that has already been asked. My
> problem is this, I am creating a report that will run on a daily basis, and I
> need to add weekly total lines. Something along the lines of, if the day is
> friday then add the row, which would calculate the totals for the week.
> The other option, would be to populate all of the days of the month,
> including a week total and month total line every time I run it. Help! I am
> stuck here...
> Thank you!
> lhagerty|||Thank you I will try that!
"Erik van der Aar" wrote:
> Use a different dataset with a table or list which fetches the week row? If
> it's not friday no row will be returned. Test the number of rows fetched to
> determine if you display the table or list
> Erik
> "lhagerty" wrote:
> > I appologize in advance if this is a question that has already been asked. My
> > problem is this, I am creating a report that will run on a daily basis, and I
> > need to add weekly total lines. Something along the lines of, if the day is
> > friday then add the row, which would calculate the totals for the week.
> > The other option, would be to populate all of the days of the month,
> > including a week total and month total line every time I run it. Help! I am
> > stuck here...
> > Thank you!
> > lhagerty

Conditional page breaks

I want to set a page break at the change of a group conditionally based on a
parameter value. Is there any way to do this in Reporting Services?Any help here? Because I would *really* like to figure out how to do this.
Once again, I have a grouped table in a report layout. I would like to have
a page break at the end of a grouping happen conditionally based on a boolean
parameter that I pass to the report.

conditional formatting in reporting services (2005)

I am new to reporting services and am unable to get cell colouring conditional formatting to work in of a report. Basically I need to have the following:

>-5% = "Red"

Between -5% and -1% = "Green"

0% = "White"

Between 1% and 5% = "Green"

>5% = "Red"

Here is what I have tried to use:

=iif((Fields!TrueUpPercQ1.Value >0 and

Fields!TrueUpPercQ1.Value <=0.05) or (Fields!TrueUpPercQ1.Value < 0 and

Fields!TrueUpPercQ1.Value >=-0.05), "Green",

iif(Fields!TrueUpPercQ1.Value =0, "White","Red"))

Any ideas?

Thanks

Try this....

=iif((Fields!TrueUpPercQ1.Value > 0, "Red", IIF(Fields!TrueUpPercQ1.Value <=0.05, "Red", IIF(Fields!TrueUpPercQ1.Value < 0, "Blue,

IIF(Fields!TrueUpPercQ1.Value >=-0.05, "Green", iif(Fields!TrueUpPercQ1.Value =0, "White","Red")))))

You may want to tweak this to suit your need. Also make sure the number of closing brackets are correct. This is the way the IIF is used. Hope it helps. Let me know.

|||

Iif would work, but I think switch would be better

Try this...you have to have even number of arguments for it to work correctly. The first is your statement to evaluate to true then the second argument is executed, if false it proceeds to the next (3rd) argument until something evaluates as true.

=SWITCH(Fields!TrueUpPercQ1.Value <=0.05, "Red", Fields!TrueUpPercQ1.Value < 0, "Green", Fields!TrueUpPercQ1.Value =0, "White")

1 2 3 4 5 6

|||

Iif would work, but I think switch would be better

Try this...you have to have even number of arguments for it to work correctly. The first is your statement to evaluate to true then the second argument is executed, if false it proceeds to the next (3rd) argument until something evaluates as true.

=SWITCH(Fields!TrueUpPercQ1.Value <=0.05, "Red", Fields!TrueUpPercQ1.Value < 0, "Green", Fields!TrueUpPercQ1.Value =0, "White")

Conditional Formating in Reporting Services 2005

Hello,
I have a problem formating a line in a diagram in SSRS 2005. I want to change the color of the line depending on a value on the x-axis.

I always get an exception that the bordercolor expression for the diagram Object 'Bestandsentwicklung.DataPoint' contains an error. The entry string has the wrong format.

The function is the following:
=IIF(Parameters!CurrentWeek.Value.ToString > cdbl(Fields!DimZeit_WocheTag_Woche_MEMBER_KEY.Value.ToString),"Firebrick","Blue")
whereby the parameter currentweek should return a number and the field DimZeit_WocheTag_Woche_MEMBER_KEY, too.

Can anyone help me? How do I have to convert the values to solve the problem?

Stefoon

The error is because you are comparing a string with a double data type. Do not use ToString for CurrentWeek parameter, instead use CDbl on both sides of your expression in IIf.

Shyam

|||

Hi Shyam,

you are right. But it does not work either.

Stefoon

Conditional Filtering in Reporting Services

I am using the following SQL query in a SSRS 2005 report (see below).
I need dbo.FilteredNew_Assets.new_assettypename = "Computer" ONLY when
the value of dbo.FilteredNew_Assets.new_assignedemployeeid is NOT
null. In other words, only when
dbo.FilteredNew_Assets.new_assignedemployeeid has a value do I need
dbo.FilteredNew_Assets.new_assettypename to be filtered.
Is this a task that needs to be accomplished within my SQL query or
somewhere within the context of the actual report? Either way, how do
I accomplish this?
SELECT dbo.FilteredNew_Employee.new_employeeid,
dbo.FilteredNew_Assets.new_assignedemployeeid,
dbo.FilteredNew_Employee.new_employeetypename,
dbo.FilteredNew_Employee.new_firstname,
dbo.FilteredNew_Employee.new_lastname,
dbo.FilteredNew_Assets.new_assettypename,
dbo.FilteredNew_Assets.new_computertypename,
dbo.FilteredNew_Assets.new_manufacturer,
dbo.FilteredNew_Assets.new_model,
dbo.FilteredNew_Assets.new_modelnumber,
dbo.FilteredNew_Assets.new_assetsid,
dbo.FilteredNew_Assets.new_name
FROM dbo.FilteredNew_Employee LEFT OUTER JOIN
dbo.FilteredNew_Assets ON
dbo.FilteredNew_Employee.new_employeeid = dbo.FilteredNew_Assets.new_assignedemployeeid
ORDER BY dbo.FilteredNew_Employee.new_lastnamePut filterednew_assets into a derived table like this and you=B4re able
to link on this derived table.
The union all reunites both sets of data, one set containing specific
conditional filter
SELECT *
FROM dbo.FilteredNew_Employee LEFT OUTER JOIN
(
SELECT
FNA.new_assignedemployeeid,
FNA.new_assettypename,
FNA.new_computertypename,
FNA.new_manufacturer,
FNA.new_model,
FNA.new_modelnumber,
FNA.new_assetsid
FROM dbo.FilteredNew_Assets FNA
WHERE FNA.new_assignedemployeeid IS NOT NULL And
FNA.New_assettypename =3D "Computer"
UNION ALL
SELECT
FNA.new_assignedemployeeid,
FNA.new_assettypename,
FNA.new_computertypename,
FNA.new_manufacturer,
FNA.new_model,
FNA.new_modelnumber,
FNA.new_assetsid
FROM dbo.FilteredNew_Assets FNA
WHERE FNA.new_assignedemployeeid IS NULL
) DerivedNewAssets ON dbo.FilteredNew_Employee.new_employeeid =3D
DerivedNewAssets.new_assignedemployeeid