95th percentile calculation

Hi *,

For our needs, we have to integrate on a Visual Studio project (a Report Server Project, which gives a report dealing with AVG, MAX counters' values from a SQL DB), a calculation of a '95th percentile' average for a counter (in place of a 'normal' average).
(In another words, we have to automatically substract the 5th 'highest values' of the total of the value, and so only make the average on the remaining 95th of the value).
And this treatment should appear as a function, that we could integrate on the Report.

Does this function already exist ?

Does anyone have any idea to help me to find how to do ?

Tks a lot to everybody.

HI,snakeoli :

Can you elaborate more about your requirment? Do you need something like top 5 percent?

|||

Hi,

No, in fact, we have to calculate the average, in the case for several ranges of values.
But to have 'relevant' results, for each sorted ranges of values, we have to exclude 5% of the highest values before calculating the average.
This maneer is called '95th percentile calculation'.

(for ex : in this range of 20 values : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20
the 95th percentile give : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19 !!
=> exclusion of the 5thhighest values of the list (5% of '20' gives '1' ==> 1 value)
And so, calculation of the average only on 19 values !)

The goal is, in some case, to supress values that can influence the result of a average.

Imagine that in this example, we have '1250' in the place of '20' !

So the average of the 20 values gives a result not relevant !
(1+ 2+ 3+ 4 + ...+ 18 + 19 + 1250) / 20

And so, finaly, that what we need to create, throught Visual Studio :
a function (similar as 'AVG()') that can calculate automaticaly this !
(for a sorted range of value, a average excluding the 5th highest values !)

I whisper sincerely that I was clearly in my explanation.

Thanks a lot for your help.

|||

Hi,snakeoli:

I got to know what you want to do in this scenario. However AVG() can not deal with such comlicated calculation for you. I just recommend you to do this in the sql statement. It will be much reasonable.

405 Error when passing parameters to reports - IIS and Reporting Services

When trying to use a report that requests parameters, while in Visual
Studio everything works fine. I can preview the report and select a
parameter, click view report and the report works. When I deploy the
report to the server and test on the web site, after I select the
parameter from the drop down and click the View Report button I get an
error in the selection criteria fram that says...
(Clip)
The page cannot be displayed
The page you are looking for cannot be displayed because the page
address is incorrect.
----
Please try the following:
If you typed the page address in the Address bar, check that it is
entered correctly.
Open the finreports.mc.vanderbilt.edu home page and then look for
links to the information you want.
HTTP 405 - Resource not allowed
Internet Information Services
----
Technical Information (for support personnel)
More information:
Microsoft Support
(/Clip)
The Report page itself stays blank. When checking the IIS logs, I
see..
(Clip)
443 POST /ReportServer
%2fDepartment+of+Finance+Reports%2fDNFB+Test+Data 405 1
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
(/Clip)
It's giving a 405 error on the post to the ReportServer path. This
report, and other reports, work perfectly when used without any
parameters, it's only giving this error when I add parameters for the
user to select.
Does anyone have any ideas? I'm sure it's something I've overlooked,
but I've been gazing at this so long just trying to get Report Server
working in an SSL and Domain locked environment that I'm cross-eyed.
I need an outside view and opinion.
Thanks for any help anyone can give.
TnNytehawkFound the fix to this a couple of hours after I posted, but Google
Groups didn't have my message up until much later so I couldn't reply
to it.
The fix was to add to the ReportServer Virtual Directory Application
Configuration Extension Mapping
Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
Extension: *
Verbs: All Verbs
Script Engine: Checked
Once I added this, everything works like a charm.|||Hello. I have the same problem! Could you write some additional informations
how to solve this problem?
Regards
â'TnNytehawkâ' pisze:
> Found the fix to this a couple of hours after I posted, but Google
> Groups didn't have my message up until much later so I couldn't reply
> to it.
> The fix was to add to the ReportServer Virtual Directory Application
> Configuration Extension Mapping
> Executable: C:\winnt\Microsoft.net\framework\v1.1.4322\apsnet_isapi.dll
> Extension: *
> Verbs: All Verbs
> Script Engine: Checked
> Once I added this, everything works like a charm.
>

3rd party tool to create reports

Hi,
Does any one know of a 3rd party tool to create report definitions for SQL
Reporting Services so you don't have to use Visual Studio.NET?
Y/JakobUnless you have objections about how it creates it or how easy it is to
create it, all you need to have is any version of VS, which includes VB. I
believe it is possible to get something with VS that costs only $100. I
doubt you could purchase a report writer for less than that. $100 per
developer is pretty inexpensive.
Bruce L-C
"Jakob Olsen" <jaoss@.wmdata.com> wrote in message
news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Does any one know of a 3rd party tool to create report definitions for SQL
> Reporting Services so you don't have to use Visual Studio.NET?
> Y/Jakob
>|||There are some 3rd party tools listed at
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23C5JSLElEHA.592@.TK2MSFTNGP11.phx.gbl...
> Unless you have objections about how it creates it or how easy it is to
> create it, all you need to have is any version of VS, which includes VB. I
> believe it is possible to get something with VS that costs only $100. I
> doubt you could purchase a report writer for less than that. $100 per
> developer is pretty inexpensive.
> Bruce L-C
> "Jakob Olsen" <jaoss@.wmdata.com> wrote in message
> news:OVlIKaDlEHA.3520@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Does any one know of a 3rd party tool to create report definitions for
>> SQL Reporting Services so you don't have to use Visual Studio.NET?
>> Y/Jakob
>