Formula Problem

I get the following error in Report Manager when running a report. The
report runs perfect in visual studio when I preview it.
Reporting Services Error
_____
* An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
* The sort expression for the grouping 'table1_Group1' uses a numeric
aggregate function on data that is not numeric. Numeric aggregate
functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate
numeric data. (rsProcessingError) Get Online Help
_____
Microsoft Reporting Services
I pass two parameters, qty and sortdate. As the formulas show below,
when they select qty and ascending, it uses sum(fields). When I pick
date, it does not use sum.
This will sort by the value in the sortby parameter. Used for sortdate
field in data.
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value<>"quantity",Fields(Parameters!SortBy.Value).Value,0)
When I need to sort by the sum of the qty since it is grouped, I do
this...
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",sum(Fields(Parameters!SortBy.Value).Value),0)
As I said above, this works perfect in visual studio when I preview it.
Any Ideas?What is the datatype of Fields!quantity.Value? Most likely it is not a
System.Int32 at runtime.
You may want to try this (assuming you want to sum up integers):
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",
sum(CInt(Fields(Parameters!SortBy.Value).Value)), 0)
Or use this if you want to actually sum double:
=iif(Parameters!Direction.Value="Descending" AND
Parameters!SortBy.Value="quantity",
sum(CDbl(Fields(Parameters!SortBy.Value).Value)), 0.0)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Geddes" <john_g@.alamode.com> wrote in message
news:eTl79Cj4EHA.3504@.TK2MSFTNGP12.phx.gbl...
> I get the following error in Report Manager when running a report. The
> report runs perfect in visual studio when I preview it.
> Reporting Services Error
> _____
>
> * An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> * The sort expression for the grouping 'table1_Group1' uses a numeric
> aggregate function on data that is not numeric. Numeric aggregate
> functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate
> numeric data. (rsProcessingError) Get Online Help
> _____
> Microsoft Reporting Services
>
> I pass two parameters, qty and sortdate. As the formulas show below,
> when they select qty and ascending, it uses sum(fields). When I pick
> date, it does not use sum.
> This will sort by the value in the sortby parameter. Used for sortdate
> field in data.
> =iif(Parameters!Direction.Value="Descending" AND
>
Parameters!SortBy.Value<>"quantity",Fields(Parameters!SortBy.Value).Value,0)
> When I need to sort by the sum of the qty since it is grouped, I do
> this...
> =iif(Parameters!Direction.Value="Descending" AND
>
Parameters!SortBy.Value="quantity",sum(Fields(Parameters!SortBy.Value).Value
),0)
>
> As I said above, this works perfect in visual studio when I preview it.
> Any Ideas?
>

Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: 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)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: 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)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Forms Authentication Not Working

I have installed SQL Server September CTP (Full Install) on a Windows 2003
Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
(Full Install).
I installed the custom security extension example that comes with the server
install and the AdventureWorks sample reports.
When I login to the web-based Report Manager I get the following error:
Key cannot be null. Parameter name: key
The error message is displayed on an rs manager like interface with no links.
I followed the instructions that came with the Custom security extension to
the tee. I have tried several different configurations including non-SSL and
nothing works.
Does anyone know what this error pertains to or has ANYONE been able to get
Forms Authentication work AT ALL? Microsoft is not responding to any of our
posts so I guess it's up to us.
Thanks in advance.I am having the same problem with the final release version. Did you ever
resolve this issue?
"Zach" wrote:
> I have installed SQL Server September CTP (Full Install) on a Windows 2003
> Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
> (Full Install).
> I installed the custom security extension example that comes with the server
> install and the AdventureWorks sample reports.
> When I login to the web-based Report Manager I get the following error:
> Key cannot be null. Parameter name: key
> The error message is displayed on an rs manager like interface with no links.
> I followed the instructions that came with the Custom security extension to
> the tee. I have tried several different configurations including non-SSL and
> nothing works.
> Does anyone know what this error pertains to or has ANYONE been able to get
> Forms Authentication work AT ALL? Microsoft is not responding to any of our
> posts so I guess it's up to us.
> Thanks in advance.

Forms authentication and report publishing from Visual Studio

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