&rs:Parameters=false not working if redering reports in a iframe;

Hi,
I have problem with &rs:Parameters=false it's not working if reports in a
iframe;
same url working well on a normal page; any trick? here is my url:
http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and
Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=false&date1=2006-05-01&date2=2006-05-02&unit_id=-1147471730&children=Y
thanks in advance! /Tomsorry, my bad, I mess up with rc: and rs in iframe url: everything is OK now,
thanks!
"TomKang2000" wrote:
> Hi,
> I have problem with &rs:Parameters=false it's not working if reports in a
> iframe;
> same url working well on a normal page; any trick? here is my url:
> http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and
> Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=false&date1=2006-05-01&date2=2006-05-02&unit_id=-1147471730&children=Y
> thanks in advance! /Tom

"The request failed with HTTP status 401: Unauthorized" SQl server reports

I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.

I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.

I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:

The request failed with HTTP status 401: Unauthorized

Please reply with solution as soon as possible. I will be very thankful to you

So, this is an IIS error which means that the request doesn't event make it to the Report Server. You can try creating a simple website with a single page in it and configure this website for Windows Integrated security. You will probably get the same error. You need to find why IIS is rejecting the web request.

"Select All" option visible in Designer but gone on Report Manager

Hello,

I have several reports that use parameters that I have defined as multi-value. When I am designing the reports I see the "(Select All)" option listed first in each parm control that has the multi-value property set true. However, when the same reports are deployed to our server and viewed through Report Manager, the "(Select All)" option is missing. I need the "(Select All)" to be present.

I've seen some discussion of a service pack. Could this be the problem? What do we need to do to get our "(Select All)" back?

Thanks,

BCB

Hello BCB,

You'll need to apply SP2 to the server with Reporting Services on it. It seems that your local machine already has it applied.

Jarret

|||

Hello Jarret,

Thanks for your response. Can you tell me how to identify the service packs that have been applied to our SQL Server, if any? I checked the SQL Server properties and found a Version property that reads 9.00.2047.00. However, the number doesn't mean anything to me.

How can I tell if SP2 has been applied?

Thanks,

BCB

|||

BCB,

RTM - 2005.90.1399
SP1 - 2005.90.2047
SP2 - 2005.90.3042

This link will tell you which version number corresponds to which service pack:

http://support.microsoft.com/default.aspx/kb/321185

You can also go to the properties of the EXE file to get the version number. For example:

{Drive}:\Program Files\Microsoft SQL Server\MSSQL.{InstanceID_of_RS}\Reporting Services\ReportServer\bin\ReportingServicesService.exe

Jarret

|||

I have the same scenarios (but it's not a problem)

I applied SP2 (AND SP2a) on my local client, so my VS2005 has <Select All> in the Designer, and local Preview

however, our SSRS servers haven't been applied SP2 but only SP1, so no <Select All> there

My local .exe version is 3050 (ie. anything > 3042 is SP2) since SP2a is .3050 :)

|||Thanks to all for the very helpful responses...

"Remote access to report data sources and/or the report server database" is not suppor

I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)

The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

Justin Song

SQL Express does not allow access to data sources not on the local machine. You will need to point to local data in your report.|||

I'm new user of Reporting Services. I'm trying use Samples (AdventureWorks) and can't use it because this error. How do I point to local data in this samples? I create a Data Source named AdventureWorks with this string:

data source="(local)";persist security info=False;initial catalog=AdventureWorks

but is not working...

|||

I've seen this problem before. The way I solved it previously was to update the connectionstring from an old-style ADO format to the new SQL 2005 format.

Old:

data source=(local);persist security info=False;initial catalog=AdventureWorks

New:

Server=(local); Database=AdventureWorks; Trusted_Connection=yes;

Hope this helps. Mark

"Remote access to report data sources and/or the report server database" is not suppor

I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)

The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

Justin Song

SQL Express does not allow access to data sources not on the local machine. You will need to point to local data in your report.|||

I'm new user of Reporting Services. I'm trying use Samples (AdventureWorks) and can't use it because this error. How do I point to local data in this samples? I create a Data Source named AdventureWorks with this string:

data source="(local)";persist security info=False;initial catalog=AdventureWorks

but is not working...

|||

I've seen this problem before. The way I solved it previously was to update the connectionstring from an old-style ADO format to the new SQL 2005 format.

Old:

data source=(local);persist security info=False;initial catalog=AdventureWorks

New:

Server=(local); Database=AdventureWorks; Trusted_Connection=yes;

Hope this helps. Mark

"Remote access to report data sources and/or the report server database" is not su

I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)

The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

Justin Song

SQL Express does not allow access to data sources not on the local machine. You will need to point to local data in your report.|||

I'm new user of Reporting Services. I'm trying use Samples (AdventureWorks) and can't use it because this error. How do I point to local data in this samples? I create a Data Source named AdventureWorks with this string:

data source="(local)";persist security info=False;initial catalog=AdventureWorks

but is not working...

|||

I've seen this problem before. The way I solved it previously was to update the connectionstring from an old-style ADO format to the new SQL 2005 format.

Old:

data source=(local);persist security info=False;initial catalog=AdventureWorks

New:

Server=(local); Database=AdventureWorks; Trusted_Connection=yes;

Hope this helps. Mark

"Pending" status for Data-driven Subscription

An issue with the 'Status' column of the 'Subscription' tab in the Report Manager.
I created Data-driven Subscriptions for some of the reports, and I scheduled the reports using shared schedule. The scheduling is working fine and all the reports are getting generated daily.
The issue is with the status of the report subscriptions under subscription tab, it shows as PENDING even after the report is generated.
I restarted the ReportServer database, it didn't served my purpose. The status never changes .

When do the subscription status changes to PENDING?
What needs to be done to change the PENDING status?
Is this the bug with the Report Manager?

Appreciate your timely help. TIA
Did you find a solution for this? I'm having the same issue.|||I didn't find any solution yet. If you find any, do share the same .
|||

There seems to be a SOAP Solution, But I've never used SOAP (Except in the Shower..LOL..sorry lame joke) , I'm having a hard time getting the MSDN Example to work. I can't get vb to recognize the ReportingService2005 class. heres the link if you want to take a look. http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions(SQL.90).aspx

Code Snippet

Dim rs As New ReportingService2005()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim extSettings As ExtensionSettings
Dim desc As String
Dim active As ActiveState
Dim status As String
Dim eventType As String
Dim matchData As String
Dim values As ParameterValue() = Nothing
Dim subscriptions As Subscription() = Nothing
Dim extensionParams As ParameterValueOrFieldReference() = Nothing

Try
subscriptions = rs.ListSubscriptions("/SampleReports/Employee Sales Summary", "myDomain\myUserName")

If Not (subscriptions Is Nothing) Then
' Retrieve properties for the first subscription in the list.
rs.GetSubscriptionProperties(subscriptions(0).SubscriptionID, extSettings, desc, active, status, eventType, matchData, values)

Console.WriteLine("Description: {0}", desc)
Console.WriteLine("Status: {0}", status)
Console.WriteLine("EventType: {0}", eventType)
Console.WriteLine("matchData: {0}", matchData)
Console.WriteLine("Extension: {0}", extSettings.Extension)

extensionParams = extSettings.ParameterValues

If Not (extensionParams Is Nothing) Then
Dim extensionParam As ParameterValueOrFieldReference
For Each extensionParam In extensionParams
Console.WriteLine((CType(extensionParam, ParameterValue).Name + ": " + CType(extensionParam, ParameterValue).Value))
Next extensionParam
End If

If Not (values Is Nothing) Then
Dim pv As ParameterValue
For Each pv In values
Console.WriteLine("Name: {0}", pv.Name)
Console.WriteLine("Value: {0}", pv.Value)
Next pv
End If
End If

Catch e As SoapException
Console.WriteLine(e.Detail.OuterXml)
End Try

|||

Any help on this issue?

|||

Are you sure that this isn't a client-side caching issue in your browser? That would potentially out-last restarting the reportserver database.

IAC if you are seeing "Pending" In your browser, whether it is browser-cached or webapp-cached this would not have much to do with restarting the database. Even server-side it could be the ReportManager webapp that is caching the value. IOW, if it is a server-side cache, and if you restart the RS instance (rather than the database) you would see the change.

>L<

"Pending" status for Data-driven Subscription

An issue with the 'Status' column of the 'Subscription' tab in the Report Manager.
I created Data-driven Subscriptions for some of the reports, and I scheduled the reports using shared schedule. The scheduling is working fine and all the reports are getting generated daily.
The issue is with the status of the report subscriptions under subscription tab, it shows as PENDING even after the report is generated.
I restarted the ReportServer database, it didn't served my purpose. The status never changes .

When do the subscription status changes to PENDING?
What needs to be done to change the PENDING status?
Is this the bug with the Report Manager?

Appreciate your timely help. TIA
Did you find a solution for this? I'm having the same issue.|||I didn't find any solution yet. If you find any, do share the same .
|||

There seems to be a SOAP Solution, But I've never used SOAP (Except in the Shower..LOL..sorry lame joke) , I'm having a hard time getting the MSDN Example to work. I can't get vb to recognize the ReportingService2005 class. heres the link if you want to take a look. http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions(SQL.90).aspx

Code Snippet

Dim rs As New ReportingService2005()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim extSettings As ExtensionSettings
Dim desc As String
Dim active As ActiveState
Dim status As String
Dim eventType As String
Dim matchData As String
Dim values As ParameterValue() = Nothing
Dim subscriptions As Subscription() = Nothing
Dim extensionParams As ParameterValueOrFieldReference() = Nothing

Try
subscriptions = rs.ListSubscriptions("/SampleReports/Employee Sales Summary", "myDomain\myUserName")

If Not (subscriptions Is Nothing) Then
' Retrieve properties for the first subscription in the list.
rs.GetSubscriptionProperties(subscriptions(0).SubscriptionID, extSettings, desc, active, status, eventType, matchData, values)

Console.WriteLine("Description: {0}", desc)
Console.WriteLine("Status: {0}", status)
Console.WriteLine("EventType: {0}", eventType)
Console.WriteLine("matchData: {0}", matchData)
Console.WriteLine("Extension: {0}", extSettings.Extension)

extensionParams = extSettings.ParameterValues

If Not (extensionParams Is Nothing) Then
Dim extensionParam As ParameterValueOrFieldReference
For Each extensionParam In extensionParams
Console.WriteLine((CType(extensionParam, ParameterValue).Name + ": " + CType(extensionParam, ParameterValue).Value))
Next extensionParam
End If

If Not (values Is Nothing) Then
Dim pv As ParameterValue
For Each pv In values
Console.WriteLine("Name: {0}", pv.Name)
Console.WriteLine("Value: {0}", pv.Value)
Next pv
End If
End If

Catch e As SoapException
Console.WriteLine(e.Detail.OuterXml)
End Try

|||

Any help on this issue?

|||

Are you sure that this isn't a client-side caching issue in your browser? That would potentially out-last restarting the reportserver database.

IAC if you are seeing "Pending" In your browser, whether it is browser-cached or webapp-cached this would not have much to do with restarting the database. Even server-side it could be the ReportManager webapp that is caching the value. IOW, if it is a server-side cache, and if you restart the RS instance (rather than the database) you would see the change.

>L<

"Pending" status for Data-driven Subscription

An issue with the 'Status' column of the 'Subscription' tab in the Report Manager.
I created Data-driven Subscriptions for some of the reports, and I scheduled the reports using shared schedule. The scheduling is working fine and all the reports are getting generated daily.
The issue is with the status of the report subscriptions under subscription tab, it shows as PENDING even after the report is generated.
I restarted the ReportServer database, it didn't served my purpose. The status never changes .

When do the subscription status changes to PENDING?
What needs to be done to change the PENDING status?
Is this the bug with the Report Manager?

Appreciate your timely help. TIA
Did you find a solution for this? I'm having the same issue.|||I didn't find any solution yet. If you find any, do share the same .
|||

There seems to be a SOAP Solution, But I've never used SOAP (Except in the Shower..LOL..sorry lame joke) , I'm having a hard time getting the MSDN Example to work. I can't get vb to recognize the ReportingService2005 class. heres the link if you want to take a look. http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions(SQL.90).aspx

Code Snippet

Dim rs As New ReportingService2005()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim extSettings As ExtensionSettings
Dim desc As String
Dim active As ActiveState
Dim status As String
Dim eventType As String
Dim matchData As String
Dim values As ParameterValue() = Nothing
Dim subscriptions As Subscription() = Nothing
Dim extensionParams As ParameterValueOrFieldReference() = Nothing

Try
subscriptions = rs.ListSubscriptions("/SampleReports/Employee Sales Summary", "myDomain\myUserName")

If Not (subscriptions Is Nothing) Then
' Retrieve properties for the first subscription in the list.
rs.GetSubscriptionProperties(subscriptions(0).SubscriptionID, extSettings, desc, active, status, eventType, matchData, values)

Console.WriteLine("Description: {0}", desc)
Console.WriteLine("Status: {0}", status)
Console.WriteLine("EventType: {0}", eventType)
Console.WriteLine("matchData: {0}", matchData)
Console.WriteLine("Extension: {0}", extSettings.Extension)

extensionParams = extSettings.ParameterValues

If Not (extensionParams Is Nothing) Then
Dim extensionParam As ParameterValueOrFieldReference
For Each extensionParam In extensionParams
Console.WriteLine((CType(extensionParam, ParameterValue).Name + ": " + CType(extensionParam, ParameterValue).Value))
Next extensionParam
End If

If Not (values Is Nothing) Then
Dim pv As ParameterValue
For Each pv In values
Console.WriteLine("Name: {0}", pv.Name)
Console.WriteLine("Value: {0}", pv.Value)
Next pv
End If
End If

Catch e As SoapException
Console.WriteLine(e.Detail.OuterXml)
End Try

|||

Any help on this issue?

|||

Are you sure that this isn't a client-side caching issue in your browser? That would potentially out-last restarting the reportserver database.

IAC if you are seeing "Pending" In your browser, whether it is browser-cached or webapp-cached this would not have much to do with restarting the database. Even server-side it could be the ReportManager webapp that is caching the value. IOW, if it is a server-side cache, and if you restart the RS instance (rather than the database) you would see the change.

>L<

"Keyword not supported: 'provider'." error with Report Builder

Hi,

I'm trying to process reports with Report Builder against a SQL Server Database.

When the .Net Provider is used in the model, everything works fine.

But if I try to use another provider (the .Net Provider for OLEDB or the native OLEDB one) to connect to the data source, i've got the following error when trying to process the report in Report Builder: Keyword not supported: 'provider'.

Is this a normal behaviour of the Report Builder ?

Thanks in advance.

Grgory.

I have tried OLE DB data sources (for Sybase) on SQL Server 2005 server, and it just doesn't work. Ended up using ODBC

The same steps worked fine on SQL Server 2000 (can access Sybase through OLE instead of ODBC)

I think it's not really a Report Server issue

"Key cannot be null. Parameter name: key"

We are using forms authentication with SSRS2005 and we are able to access Report Manager (http://servername/reports) and Reportserver (http://servername/reportserver). The problem we are having is every time we add a user to the Content Manager or the Publisher role. The user is able to login and reach the Report Manager but no folder is showing up and also we have the following error message : "Key cannot be null. Parameter name: key".

We removed users from the Content Manager and Publisher Roles and they are able to reach report manager and see the folders. This only happens with report manager. everything works fine with reportserver(http://servername/reportserver).

Any idea why we're getting an error message when trying to assign the Content Manager and publisher Roles to a user.

here is the error log from ReportServerWebApp :

aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: Key cannot be null.
Parameter name: key
aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: HTTP status code --> 500
-Details--
System.ArgumentNullException: Key cannot be null.

Parameter name: key

at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)

at System.Collections.Hashtable.Add(Object key, Object value)

at Microsoft.ReportingServices.UI.BasePermissions.ReadPermissions(String[] permissions)

at Microsoft.ReportingServices.UI.Permissions.GetPermissions()

at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)

at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Thanks!

chi

Hi

Check the following post out, it may help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327150&SiteID=1

|||

i checked the link, hmmm... did not work. any other suggestions.

chi

"Key cannot be null. Parameter name: key"

We are using forms authentication with SSRS2005 and we are able to access Report Manager (http://servername/reports) and Reportserver (http://servername/reportserver). The problem we are having is every time we add a user to the Content Manager or the Publisher role. The user is able to login and reach the Report Manager but no folder is showing up and also we have the following error message : "Key cannot be null. Parameter name: key".

We removed users from the Content Manager and Publisher Roles and they are able to reach report manager and see the folders. This only happens with report manager. everything works fine with reportserver(http://servername/reportserver).

Any idea why we're getting an error message when trying to assign the Content Manager and publisher Roles to a user.

here is the error log from ReportServerWebApp :

aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: Key cannot be null.
Parameter name: key
aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: HTTP status code --> 500
-Details--
System.ArgumentNullException: Key cannot be null.

Parameter name: key

at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)

at System.Collections.Hashtable.Add(Object key, Object value)

at Microsoft.ReportingServices.UI.BasePermissions.ReadPermissions(String[] permissions)

at Microsoft.ReportingServices.UI.Permissions.GetPermissions()

at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)

at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!3/27/2007-16:38:49:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Thanks!

chi

Hi

Check the following post out, it may help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327150&SiteID=1

|||

i checked the link, hmmm... did not work. any other suggestions.

chi

"Bad Request" error

Hi,

I've installed Reporting Services and configured it without any problem.
When I browse to http://x.x.x.x/reports I'm getting "Bad Request" error.

Is it related somehow to the IP mapping issue?
Any other clues?

Thanks,
Mark

ps
SQL 2005 RTM
W2K3 Std

Mark,

IP address should work fine. I just tried it, and I didn't have any problem. What happens when you use the NetBIOS name instead of the IP address?|||Mike - I have the same problem - did you ever figure it out?|||If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

The result is then
<Configuration>
<UI>
<ReportServerUrl>http://mbs05:8088/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
.....

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

"Bad Request" error

Hi,

I've installed Reporting Services and configured it without any problem.
When I browse to http://x.x.x.x/reports I'm getting "Bad Request" error.

Is it related somehow to the IP mapping issue?
Any other clues?

Thanks,
Mark

ps
SQL 2005 RTM
W2K3 Std

Mark,

IP address should work fine. I just tried it, and I didn't have any problem. What happens when you use the NetBIOS name instead of the IP address?|||Mike - I have the same problem - did you ever figure it out?|||If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

The result is then
<Configuration>
<UI>
<ReportServerUrl>http://mbs05:8088/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
.....

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

"Bad Request" error

Hi,

I've installed Reporting Services and configured it without any problem.
When I browse to http://x.x.x.x/reports I'm getting "Bad Request" error.

Is it related somehow to the IP mapping issue?
Any other clues?

Thanks,
Mark

ps
SQL 2005 RTM
W2K3 Std

Mark,

IP address should work fine. I just tried it, and I didn't have any problem. What happens when you use the NetBIOS name instead of the IP address?|||Mike - I have the same problem - did you ever figure it out?|||If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

The result is then
<Configuration>
<UI>
<ReportServerUrl>http://mbs05:8088/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
.....

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

<?xml version="1.0" encoding="utf-8"?>

Hey we've been building some reports.. occassionally the build / change
team complains when we use 'special characters' in our reports..
I opened up our RDLs; and I noted that we have this as the first line
<?xml version=3D"1.0" encoding=3D"utf-8"?>
I was thinking that we might need to change to 16 in order to allow
'special characters'
<?xml version=3D"1.0" encoding=3D"utf-16"?>
In other words; we are using SSRS 2005 in order to 'print letters' for
mass-mailing.. and we have some letters that people are printing out.
We just want to be able to use a simple character for a box-- as in a
simple checkbox-- that they can print off; fill out.. and snailmail
back in
I just have this gut feeling that I'm going to break our build process
if I send in a special character.. because 70% of our breaks have been
the result of special characters so far.
So am I limited to the ASCII set? Can I use Unicode characters?
So I need to set the UTF8 flag at the top of our reports to UTF16?
Thanks
-Aaron
=E2=80=ABanyone?
does anyone else have reports that have this at top?
<?xml version=3D"1.0" encoding=3D"utf-16"?>
or does everyone else have
<?xml version=3D"1.0" encoding=3D"utf-8"?>
you see this is the piece that's a buch of crap; microsoft is blocking
my posts.. just because I speak the truth.
Piece of shit ass company supports CENSORSHIP-- not in China-- but here
in their own backyard
-Aaron
aaron.kempf@.gmail.com wrote:
> Hey we've been building some reports.. occassionally the build / change
> team complains when we use 'special characters' in our reports..
> I opened up our RDLs; and I noted that we have this as the first line
> <?xml version=3D"1.0" encoding=3D"utf-8"?>
>
> I was thinking that we might need to change to 16 in order to allow
> 'special characters'
> <?xml version=3D"1.0" encoding=3D"utf-16"?>
> In other words; we are using SSRS 2005 in order to 'print letters' for
> mass-mailing.. and we have some letters that people are printing out.
> We just want to be able to use a simple character for a box-- as in a
> simple checkbox-- that they can print off; fill out.. and snailmail
> back in
>
> I just have this gut feeling that I'm going to break our build process
> if I send in a special character.. because 70% of our breaks have been
> the result of special characters so far.
> So am I limited to the ASCII set? Can I use Unicode characters?
> So I need to set the UTF8 flag at the top of our reports to UTF16?
> > Thanks
> > > -Aaron
> > =E2=80=AB|||my friend Hari told me that Reporting Services only supports the Ascii
character set.. is this true?
-Tom
aaron.kempf@.gmail.com wrote:
> anyone?
> does anyone else have reports that have this at top?
> <?xml version=3D"1.0" encoding=3D"utf-16"?>
> or does everyone else have
> <?xml version=3D"1.0" encoding=3D"utf-8"?>
> you see this is the piece that's a buch of crap; microsoft is blocking
> my posts.. just because I speak the truth.
> Piece of shit ass company supports CENSORSHIP-- not in China-- but here
> in their own backyard
> -Aaron
>
>
> aaron.kempf@.gmail.com wrote:
> > Hey we've been building some reports.. occassionally the build / change
> > team complains when we use 'special characters' in our reports..
> >
> > I opened up our RDLs; and I noted that we have this as the first line
> > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> >
> >
> > I was thinking that we might need to change to 16 in order to allow
> > 'special characters'
> >
> > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> >
> > In other words; we are using SSRS 2005 in order to 'print letters' for
> > mass-mailing.. and we have some letters that people are printing out.
> >
> > We just want to be able to use a simple character for a box-- as in a
> > simple checkbox-- that they can print off; fill out.. and snailmail
> > back in
> >
> >
> > I just have this gut feeling that I'm going to break our build process
> > if I send in a special character.. because 70% of our breaks have been
> > the result of special characters so far.
> >
> > So am I limited to the ASCII set? Can I use Unicode characters?
> > So I need to set the UTF8 flag at the top of our reports to UTF16?
> > > > Thanks
> > > > > > -Aaron
> > > > =E2=80=AB|||yeah.. it looks like reporting services only supports the ASCII / ANSI
character set..
I wonder how the people in China do it?
-Aaron
punjab_tom@.hotmail.com wrote:
> my friend Hari told me that Reporting Services only supports the Ascii
> character set.. is this true?
> -Tom
>
>
> aaron.kempf@.gmail.com wrote:
> > anyone?
> >
> > does anyone else have reports that have this at top?
> > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> > or does everyone else have
> > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> >
> > you see this is the piece that's a buch of crap; microsoft is blocking
> > my posts.. just because I speak the truth.
> >
> > Piece of shit ass company supports CENSORSHIP-- not in China-- but here
> > in their own backyard
> >
> > -Aaron
> >
> >
> >
> >
> > aaron.kempf@.gmail.com wrote:
> > > Hey we've been building some reports.. occassionally the build / chan=ge
> > > team complains when we use 'special characters' in our reports..
> > >
> > > I opened up our RDLs; and I noted that we have this as the first line
> > > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> > >
> > >
> > > I was thinking that we might need to change to 16 in order to allow
> > > 'special characters'
> > >
> > > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> > >
> > > In other words; we are using SSRS 2005 in order to 'print letters' for
> > > mass-mailing.. and we have some letters that people are printing out.
> > >
> > > We just want to be able to use a simple character for a box-- as in a
> > > simple checkbox-- that they can print off; fill out.. and snailmail
> > > back in
> > >
> > >
> > > I just have this gut feeling that I'm going to break our build process
> > > if I send in a special character.. because 70% of our breaks have been
> > > the result of special characters so far.
> > >
> > > So am I limited to the ASCII set? Can I use Unicode characters?
> > > So I need to set the UTF8 flag at the top of our reports to UTF16?
> > > > > > Thanks
> > > > > > > > > -Aaron
> > > > > > =E2=80=AB|||In India; we need to use a larger character set than ASCII / ANSI
can someone help?
-Tom
aaron.kempf@.gmail.com wrote:
> yeah.. it looks like reporting services only supports the ASCII / ANSI
> character set..
> I wonder how the people in China do it?
> -Aaron
>
> punjab_tom@.hotmail.com wrote:
> > my friend Hari told me that Reporting Services only supports the Ascii
> > character set.. is this true?
> >
> > -Tom
> >
> >
> >
> >
> > aaron.kempf@.gmail.com wrote:
> > > anyone?
> > >
> > > does anyone else have reports that have this at top?
> > > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> > > or does everyone else have
> > > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> > >
> > > you see this is the piece that's a buch of crap; microsoft is blocking
> > > my posts.. just because I speak the truth.
> > >
> > > Piece of shit ass company supports CENSORSHIP-- not in China-- but he=re
> > > in their own backyard
> > >
> > > -Aaron
> > >
> > >
> > >
> > >
> > > aaron.kempf@.gmail.com wrote:
> > > > Hey we've been building some reports.. occassionally the build / ch=ange
> > > > team complains when we use 'special characters' in our reports..
> > > >
> > > > I opened up our RDLs; and I noted that we have this as the first li=ne
> > > > <?xml version=3D"1.0" encoding=3D"utf-8"?>
> > > >
> > > >
> > > > I was thinking that we might need to change to 16 in order to allow
> > > > 'special characters'
> > > >
> > > > <?xml version=3D"1.0" encoding=3D"utf-16"?>
> > > >
> > > > In other words; we are using SSRS 2005 in order to 'print letters' =for
> > > > mass-mailing.. and we have some letters that people are printing ou=t=2E
> > > >
> > > > We just want to be able to use a simple character for a box-- as in= a
> > > > simple checkbox-- that they can print off; fill out.. and snailmail
> > > > back in
> > > >
> > > >
> > > > I just have this gut feeling that I'm going to break our build proc=ess
> > > > if I send in a special character.. because 70% of our breaks have b=een
> > > > the result of special characters so far.
> > > >
> > > > So am I limited to the ASCII set? Can I use Unicode characters?
> > > > So I need to set the UTF8 flag at the top of our reports to UTF16?
> > > >
> > > > Thanks
> > > > > > > > > > > > -Aaron
> > > > > > > > =E2=80=AB

#ERROR - avoid division by zero

Hi...
Need some help with creating reports in MS SQL Server Report Server and column name "Profit / Loss (%)".
Got an error when I try to run the code below.
The purpose is to avoid a division by zero... or do anyone know a better way solve this?

=IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)=0, 0, IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)<>0, -1, SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)))
/
IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)=0, 1, IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)<>0, 1, SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)))
Error message:
The value expression for the textbox ‘textbox86’ refers to the field ‘PROFIT_AND_LOSS_AMOUNT’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

//chwa

This error message is referring to the scope of the field ‘PROFIT_AND_LOSS_AMOUNT’. It cannot find it in the dataset. Try doing

SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value, "dataset name here")

for all those things above.

##### Sorting a column in the report #####

Hi
I am using SQL Server 2000 Reporting Services.
I want to add sorting in my reports so that when a user
clicks on the column header the data in the report gets
sorted by that column. How can i achieve this.
A descriptive explanation would be really helpful
Thanks
Gautam Kashyaphttp://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0064e121-fd26-4c83-8add-4a694e4fea7d&sloc=en-us
"Gautam Kashyap" <kashyap_gautam@.rediffmail.com> wrote in message
news:598001c491b7$cfd93da0$a301280a@.phx.gbl...
> Hi
> I am using SQL Server 2000 Reporting Services.
> I want to add sorting in my reports so that when a user
> clicks on the column header the data in the report gets
> sorted by that column. How can i achieve this.
> A descriptive explanation would be really helpful
> Thanks
> Gautam Kashyap