Trend Lines In RS2005
Jan 24, 2007Are trend lines supported in RS2005, and if so how do you produce them?
Thanks,
Peter Cwik
Trizetto
ADVERTISEMENT
Trend-Least Squares Method
Apr 2, 2008I have developed a simple logic for finding the trend based on least squares method.Want to know whether a built in function already exists for finding the trend or is being developed for future versions of SQL server
View 3 Replies View RelatedNeed Some Thoughts On An Emerging Trend With SharePoint
Dec 17, 2007I was hoping to elicit some feedback on a trend I am seeing in the Portal market, and specifically with SharePoint development.
If you are not familiar with SharePoint, there is a data table abstraction within SharePoint called a "List". Lists are used for storing data (duh!). However, they are built using the SharePoint front end, and the data entered into all lists is stored in a few tables in the SharePoint content database.
What I am seeing happening is SharePoint gurus reccomending AGAINST storing your relational data within database tables, and within SharePoint lists instead. I am not sold on this approach, and it actually makes me think we are taking a step backwards with regards to persistent data storage and best practices.
- Lists cannot be natively related to one another, however they support "lookups"
- Anyone can create a list...and repeat the same data all over the enterprise.
- Lists are maintained in two tables within the SharePoint content database using meta-data patterns.
- Portals contain a multitude of sites. Users and portal admins can create lists all over the place, thus spreading related data over a wide swath of the enterprise.
Is it just me, or are SharePoint pundits absolutely CRAZY to be recommending persistent data storage using lists? I see nothing but problems arising from this approach.
I apologize beforehand if you have not worked with SharePoint and Lists, as this post may not make much sense to you. ;)
Curve Fitting (Trend Analysis And Prediction)
Jan 9, 2007For a set of data points (x, y), this algorithm can be used to fit the data to any of the following curves:
1. Straight line (linear regresion); y = A + b*x
2. Exponential curve; y = A*EXP(b*x); nb a > 0
3. Logarithmic curve; y = A + b*LN(x)
4. Power curve; y = A*x^b; nb a > 0
The coefficient of determination is R2 (how well does the curve fit)
-- Prepare test data
CREATE TABLEcf
(
x decimal(38, 10),
y decimal(38, 10)
)
-- Calculate Linear regression
INSERTcf
SELECT40.5, 104.5 UNION ALL
SELECT38.6, 102 UNION ALL
SELECT37.9, 100 UNION ALL
SELECT36.2, 97.5 UNION ALL
SELECT35.1, 95.5 UNION ALL
SELECT34.6, 94
SELECT'Linear regression' AS Type, A, b, R2
FROMdbo.fnCurveFitting(1)
UNION ALL
SELECT'Bestfit = ' + CAST(Type AS VARCHAR), A, b, R2
FROMdbo.fnBestFit()
-- Calculate Exponential regression
DELETE
FROMcf
INSERTcf
SELECT.72, 2.16 UNION ALL
SELECT1.31, 1.61 UNION ALL
SELECT1.95, 1.16 UNION ALL
SELECT2.58, .85 UNION ALL
SELECT3.14, .5
SELECT'Exponential regression' AS Type, A, b, R2
FROMdbo.fnCurveFitting(1)
UNION ALL
SELECT'Bestfit = ' + CAST(Type AS VARCHAR), A, b, R2
FROMdbo.fnBestFit()
-- Calculate Logarithmic regression
DELETE
FROMcf
INSERTcf
SELECT3, 1.5 UNION ALL
SELECT4, 9.3 UNION ALL
SELECT6, 23.4 UNION ALL
SELECT10, 45.8 UNION ALL
SELECT12, 60.1
SELECT'Logarithmic regression' AS Type, A, b, R2
FROMdbo.fnCurveFitting(1)
UNION ALL
SELECT'Bestfit = ' + CAST(Type AS VARCHAR), A, b, R2
FROMdbo.fnBestFit()
-- Calculate Power regression
DELETE
FROMcf
INSERTcf
SELECT10, .95 UNION ALL
SELECT12, 1.05 UNION ALL
SELECT15, 1.25 UNION ALL
SELECT17, 1.41 UNION ALL
SELECT20, 1.73 UNION ALL
SELECT22, 2 UNION ALL
SELECT25, 2.53 UNION ALL
SELECT27, 2.98 UNION ALL
SELECT30, 3.85 UNION ALL
SELECT32, 4.59 UNION ALL
SELECT35, 6.02
SELECT'Power regression' AS Type, A, b, R2
FROMdbo.fnCurveFitting(1)
UNION ALL
SELECT'Bestfit = ' + CAST(Type AS VARCHAR), A, b, R2
FROMdbo.fnBestFit()
DROP TABLE cf
Peter Larsson
Helsingborg, Sweden
SQL Server 2012 :: Find Trend How Employee Makes Sales Every Month?
Jun 7, 2015How do I find sales trend of an employee via comparing current month and previous month sales?
I got so far query upto following,
;WITH SalesOrderHeader As
(
SELECT ROW_NUMBER() OVER (ORDER BY SUM(H.SUBTOTAL)) AS ROWNUMBER, SUM(H.SUBTOTAL),H.SALESPERSONID,
[Code]....
I am getting following error:
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
Reporting Services :: How To Draw Polynomial Trend Line In SSRS 2012
Sep 13, 2015draw 4th Polynomial Trend line chart ib SSRS 2012. FYI this feature is in Excel but I want to draw this trend line on my Column Chart.
View 5 Replies View RelatedUsers In RS2005
Feb 11, 2007How do you set up user as who can access what report in Report Manger. I do not see security tab in RS2005.
Help With RS2005 And Internet
May 5, 2008Hi all,
I really need help with this issue.
I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.
I'm stomped...
The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports
The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports
How can I configure my server to stay on my secure address?
Thanks
Aiwa
RS2005 And SQL2000
Aug 11, 2006Hi,
As per my reading, using RS2005 with backend database as SQL 2000 is
possible.
Can anyone tell me whether RS2005 connect to SQL 2000 database on same same
machine. i.e. in short can RS2005 reside with SQL 2000?
Which edition of RS 2005 support backend as SQL2000?
TIA,
Tanmaya
Using MDXScope Statement In RS2005
Apr 13, 2007Has anyone used the MDX Scope Statement in a RS2005 Reporting Services
Report?
I am not sure if the scope / end scope statement will work in a RS report script.
Thanks,
Flow Layout In Rs2005
Jan 10, 2007I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.
a quick example
A full address would look like this..
customer name
address line 1
address line 2
town
county
post code
if address line 2 isnt given, I get:
customer name
address line 1
town
county
post code
but I want:
customer name
address line 1
town
county
post code
Can anyone help?
Many thanks,
Paul
RS2005 Setup Blues
Jul 10, 2007I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:ReportingServices2005MSSQL.1Reporting ServicesLogFilesReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
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)
w3wp!ui!5!7/10/2007-11:29:32:: 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)
Please advise.
The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>
Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.
What am I missing here ..?
Deploy Problem; RS2005
Feb 9, 2007
I am not able to deploy report to report server, I have this error:
The permissions granted to user <IUSR_MashineName> are insufficient for performing this operation.
RS2005 On Vista. Could It Be Any More Difficult?
Jan 8, 2007Well, I finally got RS2005 installed on Vista, only problem is, now it won't run. I've installed SP2 (Ctp) and still no joy. It just errors when attempting to access the web service.
Here's the error:
w3wp!library!5!01/08/2007-20:36:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest()
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
Any clues anyone? I'm all out.
Cheers,
Paul
Drill Through Reports In RS2005
Jul 23, 2007How do I drill through to a report from a report that's in a different directory? In the designer I can only drill through to reports that are in that project. I'm sure that there is a simple solution (hopefully!).
View 1 Replies View RelatedReporting Services :: Draw Trend Line For SSRS Line Chart 2005
May 4, 2012I need the Trend line for the following data in Line chart they are the following data. The following are the graph are my output and i need the trend line for these Key_gap value.
This is the link [URL] ....
I need the same trend line for the Bar-Chart in SSRS 2005.
Where Do I Change The From Email Display Name For RS2005?
Jul 20, 2007All of the subscription emails that go out has a "From" display name of "POP3", so when the receipients receive the email, they see "POP3" in the "From" field. I would like to change this so ill-informed users don't delete the emails thinking they're junk/virus email.
Of course if the email software being used by the receipients doesn't support displaying a "From" name, then only the actual email will show and, in that case, it will be perfectly fine.
I'm trying to account for the less-than-educated end-users with minimal literacy in computers.
Does anyone know how to change this? Thanks!
Changes In Paramters In RS2005 Compare To RS2000
Nov 27, 2007Hi there,
I've got a RS2000 report from Analysis services 2000. This report is working fine but after the upgrade to SQL2K5, i'm having issues with changes to parameters.
Basically i'm passing DateQuarter, CustomersLevel as parameters to the following mdx script. I've tried to change mdx script in RS2005 but no luck yet. I don't much about the parameter level changes in sql2k5. So can anyone suggest what is wrong in the script.
Code Block
RS2000
="with " &
"member [Measures].[Ex Price] as 'coalesceempty([Measures].[Ex Price After Trade Discount - Detail],0.00)' " &
"set [Rolling Quarters] as '" + Parameters!DateQuarter.value +".lag(4):" + Parameters!DateQuarter.value + "'" &
"SELECT " &
"{[Measures].[Ex Price]} ON COLUMNS , " &
"filter({CrossJoin([Items by Class].[Item Class Description].members, [Rolling Quarters])}, [Measures].[Ex Price] > 0) on Rows " &
"FROM Sales " &
"WHERE (" & Parameters!CustomersLevel.Value & ")"
RS2005
with
member [Measures].[Ex Price] as 'coalesceempty([Measures].[Ex Price After Trade Discount - Detail],0.00)'
set [Rolling Quarters] as '@DateQuarter' +'.lag(4):' + '@DateQuarter'
SELECT
{[Measures].[Ex Price]} ON COLUMNS ,
filter({CrossJoin([Items by Class].[Item Class Description].members, [Rolling Quarters])}, [Measures].[Ex Price] > 0) on Rows
FROM Sales
WHERE STRTOSET(@CustomersLevel)
Thanks in advance,
Vivek
RS2005 Reports To AS2000 Cubes
Jul 13, 2007Hello,
I am using RS 2005 to design reports.
There's no problem when I connect to an Analysis Services 2005 cube.
But when I try to connect to an AS 2000 cube (Foodmart)...
I have read in this forum that I can use "Microsoft SQL Server Analysis Services" provider (or OLE DB)...
Can someone help me please!!
Thank you
RS2005 And Visual Studio 2008?
Jan 24, 2008Can I author report projects in VS Studio 2008 that I deploy to a RS2005 Report Server?
Our development staff has upgraded to VS2008 for our DLLs, Web sites, and console apps... no problem there whatsoever. But we have SQL2005... obviously, since SQL2008 appears to be along way off.
So, it seems like an obvious question... although I'm dreading the response. My experience with getting RS2005 installed and configured correctly was simply horific. In fact, so bad, I'm considering dumping RS altogether and going with a more reliable 3rd party tool... MS has truly done everything in the power to botch this one or so it would seem.
Displaying A Trend Line (in Line Chart) In SSRS
Feb 7, 2007We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.
View 1 Replies View RelatedHow Do You Move A Report And Its Subscriptions To A Different RS2005 Instance?
Oct 26, 2007I am new to RS. The Report developers want a way to move a report and its subscriptions to a different RS2005 instance. They tell me they can move the report but have to manually add the subscriptions back. Is that true? Is there no friendly way to move the subscriptions?
Thanks,
Michael
Cannot Modify Subscription After The Migration From RS2000 To RS2005
Feb 5, 2007We successfully migrated our RS2000 to RS2005. But we run into an issue €“ trying to modify an existing subscription that was created on RS2000 (We do not have this problem if the subscription is created on RS2005).
The error message is:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help.
The specified @name (€˜B3F7CB60-6636-4F67-93CF-B94C052DFD29€™) already exists.
The call stack is:
w3wp!library!d!02/05/2007-14:31:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: The specified @name ('B3F7CB60-6636-4F67-93CF-B94C052DFD29') already exists.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.CreateTask(Task task)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.RSService._SetSubscriptionProperties(String subscriptionID, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.RSService.SetSubscriptionProperties(Guid batchId, String subscriptionID, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
--- End of inner exception stack trace ---
The error message is raised from the stored procedure sp_verify_job:
-- NOTE: We allow jobs with the same name (since job_id is always unique) but only if
-- they originate from different servers. Thus jobs can flow from an MSX to a TSX
-- without having to worry about naming conflicts.
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobs
WHERE (name = @name)
AND (originating_server = @originating_server)
AND (job_id <> ISNULL(@job_id, 0x911)))) -- When adding a new job @job_id is NULL
BEGIN
RAISERROR(14261, -1, -1, '@name', 'name')
RETURN(1) -- Failure
END
which is called by another stored procedure sp_add_job.
Question:
Is there anyway that I can workaround this issue? Or is there anyway that I can re-create existing report server subscriptions (I have 300+ subscriptions) programmatically.
Please help.
Bobby Fu
Reduce Row Spacing In Financial Reports - RS2005
Jan 30, 2007I am using RS 2K5 to develop financial reports, with plenty of figures that must fit in a page.
I use tables for example. Fonts cannot be set smaller than 8pts.
I have also tried to decrease row height and to disable the "can grow to fit content" option, but of course in this way the text gets cut of in its lower part.
How can I do lines more compact? I need to reduce line spacing and to make the data more dense. Currently it looks very sparse.
Is it a known limitation for RS? Any workaround available? Any online example with dense reports?
Thank you.
RS2005 Date Parameter - JScript Error
Sep 20, 2006
I have a RS2005 report that was deployed to a ReportServer and has been running for over 1 month. I personally have not run this report in the past month, however, today when I tried to run it I got an error trying to select a date parameter. I can't paste samples of the windows displayed, so I'll do my best to explain. When I click on the report, it goes to the View window and displays 2 date parameter fields. When I click the icon next to one of the parameter fields, I get an error window that says
A Runtime Error has occurred.
Do you wish to Debug?
Line: 383
Error: 'resultfield.id' is null or not an object
I click Yes and get a VS Just-in-Time Debugger window, where I choose New instance of VS 2005. When VS2005 opens, then I get this error:
Microsoft JScript runtime error: 'resultfield.id' is null or not an object
The Continue option just keeps displaying this error, when I click Break it shows me the code below and has highlighted the line I show in BOLD:
function ClickDay(date)
{
var win = document.parentWindow;
if (!win) win = document.contentWindow;
if (!win) win = document.defaultView;
if (!win) return true;
var ifrm=win.frameElement;
if (ifrm==null)
{
return MoveToDate(date, false);
}
var eltValidator=win.parent.document.getElementById(ifrm.resultfield.id+g_strDatePickerRangeValidatorID);
if (eltValidator !=null)
{
eltValidator.style.display="none";
}
var OnSelectDateCallback=ifrm.OnSelectDateCallback;
OnSelectDateCallback(ifrm.resultfield, date);
var resultfunc=ifrm.resultfunc;
resultfunc(ifrm.resultfield);
return true;
}
To make this more confusing, after I get this error a few times, eventually it lets me choose a date and run the report. Another quirk of my PC is that I often get runtime errors that ask me if I want to Debug when I'm in IExplorer.
Any idea what is going on and how to fix it?
Thanks in advance!
WWW Service Overload When Trying To Print A Rs2005 Report
Mar 23, 2006Hi
When I try to print a very simple report with rs2005 via the print button on the http://servername/report/pages/... website, it says "printing" but nothing happend. When I look at the server (win2003 SP1 + latest hotfixes) the www and sql2005 (SP1 CTP installed) services eat up 100% cpu for ever.
I get no error messages neither in the rs log's nor in os application or system log. With profiler I found out, that there must be some loop. The following stored procedure exec DeletePersistedStreams @SessionID='24iumm55mp32l2ie2nezs0y0'is called about 650 times per second, which explain the load. The only way to stop this, is shut down and restart the www service.
This behaviour can be found with all reports.
The call, view and export of the same reports to pdf, xls, ... works without problems.
Any ideas?
Thanks for your help
Peter
Is There A Feature In RS2005 For Using Different Languages In Column Headings?
Nov 16, 2007we'd like our users to have the option of choosing the language (eg French) for column headings (maybe report heading too). I'm sure I'd have to provide the translations somehow but I'd like to know what feature, if any in RS2005 comes the closest to doing/supporting this, even if it is something like making column headings themselves dependent on a variable?
View 5 Replies View RelatedRS2005 Emailed Web Archives Not Showing Up With Correct Formating
Dec 7, 2007I recently upgraded to SQL 2005 and after the upgrade, my emailed reports didn't show formating. The email method was Web Archive (MHTML). Embedded images do show up, but inside tables, my bold, background colors, text alignment, table borders are being ignored.
I created a brand new report (VS 2005) and while it works great in the GUI and it works fine running the report from the webserver and exporting as Web Archieve, I still have the same issue that when it is emailed via a subscription, it comes back without formating.
Even more confusing is that the formating of a text box will work as long as it is before the table. If it is along side or below the table, than its formating won't work either.
Header/footer: Drillthrough Link Are Not Supported In RS2005: Fix Available?
Nov 2, 2007Hi Friends,
We are using Drillthrough links in page header/footer which is not supported in RS2005.
Is there any fix available bcas the same problem was raised one year back.
thanks
Novin
Can You Have Multiple RS2005 Instances Running On Server 2003?
May 9, 2006I have a website running under Windows Server 2003 which I am trying to deploy Reportin Services to using a custom security extension using Forms authentication. There is also another website which is just a Report Server running on this IIS 6.
On my development machine, XP with IIS 5.1, the Website with Reporting Services using forms authentication works fine, shares cookies for authentication and all that jazz. but trying to configure a second instance of Reporting Services on Server 2003 is not behaving.
Is there some trickery or details involved with running two instances of Reporting Services?
Also in the Configure Report Server tool it is failing and so not initializing on the last step of the Database Setup
Setting Connection Info for Reporting Server
ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.
---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
How Do Set Printer Delivery Extension In RS2005 For Report Subscription
Mar 14, 2007Can anyone help on this topic...
i need to set Printer Delivery Extension, and create a subscription for report which will be sent to the printer automatically
RS2005: ReportManager And Forms Authentication : The Report Server Is Not Responding
Nov 10, 2006Hi,
Sorry for the long post but I'll try to give a maximum of information.
I've tried to implement Form Authentication for Reporting Services. Right now, just about everything works as I would hope for, i.e.:
When I try to access http://<server>/ReportServer$SQLSERVER_2005, I am redirected to the authentication form.
When successfully authenticated, I can access the report
I can display reports throught the ReportViewer Web control by passing the authentication cookie.
Etc.
(Note: My implementation of Form Authentication was inspired by http://www.devx.com/dotnet/Article/26759/0/page/1 which seems similar to Microsoft Sample)
(The $SQLSERVER_2005 suffix is because SQL Server 2000 is also installed on the server, but I don't think Reporting Services 2000 is installed)
There is one thing which does not work however and it is the Report Manager.
When I try to access http://<server>/Reports$SQLSERVER_2005, I would expect to be redirected to the /Pages/UILogon.aspx page. Instead, I get an error page with the following message:
"The report server is not responding. Verify that the report server is running and can be accessed from this computer."
Both ReportServer and Reports are on the same server, both have the same security on the folder and in IIS (6.0), both have Anonymous security access "checked".
If I revert to the old .config files (prior to my modifications for Form Authentication) and remove Anonymous from IIS for both sites, everything works fine (like it did after the installation).
Here are excerpts from the config files I've modified in ReportManager:
RSWebApplication.config:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<servername>/ReportServer$SQLSERVER_2005</ReportServerUrl>
</UI>
rsmgrpolicy.config:
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants MyComputer code Execution permission. ">
<IMembershipCondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer" />
Web.config:
<identity impersonate="false" />
Here is the content of the log ReportServerWebApp_*.log (see error in bold):
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__11_10_2006_08_32_34.log</Path>
<SystemName>MSCAPP02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!11/10/2006-08:32:39:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!5!11/10/2006-08:32:39:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
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)
w3wp!ui!5!11/10/2006-08:32:40:: 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)
So that's it. Thanks for any help you can provide.
Nicolas
Is RS2005's Matrix Data Region Feature Broken, Or Subject To Certain Limitations?
Dec 25, 2007I'm consistently getting >10 minute render times in a matrix based report whose underlying query only takes 1-2 seconds to run in both RS's data tab and mgt studio. The bad render times occur in preview tab, Report Viewer and when requested from Report Manager. I believe most of the time being taken is RS's attempt to pivot and present the data.
I can run a homegrown query that pivots (with unknown number of cols) the data itself in under 4 seconds but would be concerned about mapping an unknown number of columns to a table region in RS.
The matrix I'm testing with is 67 columns across (just over 2 months of daily columns) and is supposed to be 207 rows long. There is no aggregation required by RS when it is pivoting the data because each intersection occurs at most one time in the query's result set. The number of data points actually being "bucketed" is around 13,800 values. Row headers consist of 3 columns.
RS is also cutting off the number of rows it is supposed to be showing. The number of rows cutoff seems to be 100% repeatable based on the date range chosen. RS doesnt tell me when it cuts off rows that should have been displayed. From what I can tell so far, it never cuts off columns.
The number of rows cut off seems consistent across designer's preview, report viewer and when requested thru report manager. The "run" command (exclamation icon in data tab) seems to always return the correct number of unpivoted rows, just as in mgt studio.
Are there known bugs and or limitations in RS's matrix data region feature? Are there some settings or workarounds that might make it work more to my liking?