I am new to both Reporting Services and Webservices implementation so I am just trying to use a simple example. I found a Webservice on the internet that returns movie information:
I am trying to query a list in sharepoint using its lists.asmx webservice and in turn its GetListItems call. I currently have the call working using the following code in the Querystring for the report
This seems to work fine except that the list has some empty fields in the first record and for some unbelivable reason they (the empty fields) do not get returned as part of the dataset unless i put a value into them. I then came across a parameter for GetListItems called viewFields which is supposed to . Tehn sample Soap request is shown as follows
As i have a parameter for viewfields setup.... What value do i pass to it ??? My XML is in its infancy but i though something along the lines of the following would do as an input.
Also, maybe i am going the wrong way about this.Is there an easier way of defining the Parameters as part of the Querystring or do Parameters always have to be setup in the parameters tab (My Parameter values are static and will never change).
am doing proof-of-concept for reporting services reports getting data via web services.
got it working for simple examples (passing back strings etc) also woking passing back an object but cant get it working with a dataset - am having trouble filtering out the XML resultset
this is my webmethod [WebMethod] public DataSet DSetExample() { DataSet ds = new DataSet("XMLTest"); DataTable dt = new DataTable(); DataColumn dc; dc = new DataColumn("IntegerColumn1", System.Type.GetType("System.Int32")); dt.Columns.Add(dc); dc = new DataColumn("StringColumn1", System.Type.GetType("System.String")); dt.Columns.Add(dc); dc = new DataColumn("DecimalColumn1", System.Type.GetType("System.Decimal")); dt.Columns.Add(dc); dc = new DataColumn("DateTimeColumn1", System.Type.GetType("System.DateTime")); dt.Columns.Add(dc); DataRow drow = dt.NewRow(); drow["IntegerColumn1"] = 1; drow["StringColumn1"] = "WTF"; drow["DecimalColumn1"] = 205.299; drow["DateTimeColumn1"] = DateTime.Parse("22/May/1966"); dt.Rows.Add(drow); ds.Tables.Add(dt); return ds; }
this is my basic query <Query> <ElementPath IgnoreNamespaces="true">* </ElementPath> <Method Name="DSetExample" Namespace="http://localhost/testservice1"> </Method> </Query>
this just gives me the first node details
but when ever i try and specify the elements i want by using the ElementPath nothing comes back....
just need to know how to specfiy the ELEMENTPATH to return the dataset details...
I was wondering if it's possible to use a sharepoint list as datasource in reporting services ? If yes, what's your trick ? Is it possible to use a directory as datasource in reporting services ?
I've created a SSIS package with a DataReaderDestination and a SSRS report that points to it.
I referenced these links during development and I have everything working as expected locally. **I changed the config files as stated on both my local machine and our server. My config matches the example exactly.
When I attempt to deploy my report project to the server I get this error message: "An attempt has been made to use a data extension 'SSIS' that is not registered for this report server."
In the report manager data source properties page it reads: "The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly."
In SQL Server Management Studio data source properties page SSIS is not a data source type option.
I've tried restarting both the Reporting Services and Integration Services on the server to no avail.
Any suggests? My problem is I can't get the SSIS to be recognized source on the server.
Data Source of the report is AS/400 and I need to create a report in visual studio 2013 with ODBC Connection type and deploy report onto share point 2013. How to create report, data source and deploy on share point.
My problem is how we will create ODBC connection with AS/400 and connect report with AS/400.
A customer use SCSM 2012 RTM and recently they changed the password of the account that connects with the datasources that use Service Manager to generate reports. There are several datasources namely DWStagingAndConfig, ConfigurationManager, DWDataMart and other ones.The process to change the password of the account, done via web in the SSRS URL instance of Service Manager, requires to enter in the Manage option of each DataSource and replace the password with the right one in the Properties section; is a really simple step. However, after the change, the only Datasource that not allows to access again to the Manage option is DWStagingAndConfig (appears a message that points out to a report server internal error);I append a extract of the SSRS log related to the problem with this Datasource.
library!ReportServer_0-109!3024!01/22/2014-14:54:14:: Call to GetPermissionsAction(/SystemCenter/ServiceManager/DWStagingAndConfig). library!ReportServer_0-109!8820!01/22/2014-14:54:14:: Call to GetSystemPermissionsAction(). library!ReportServer_0-109!8820!01/22/2014-14:54:14:: Call to GetSystemPropertiesAction(). library!ReportServer_0-109!8ab8!01/22/2014-14:54:15:: Call to GetDataSourceContentsAction(/SystemCenter/ServiceManager/DWStagingAndConfig). library!ReportServer_0-109!8ab8!01/22/2014-14:54:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
When creating a report using reporting Services with a cube as a datasource, visual studio 2005 hangs. I have applied SP1 to visual studio.net 2005 .
This is the query generated by query designer in reporting services. When I try to drag and drop another dimension to slice it by , visual studio hangs.
The fact table has just 10,000 records. Are the number of dimensions used to slice the cube too many? How do I optimize this query?
SELECT NON EMPTY { [Measures].[Avg MT Rate - Speech], [Measures].[Change in Avg MT Rate], [Measures].[Edited Lines Per 1000], [Measures].[Speech Utilization], [Measures].[Time Saved %], [Measures].[Speech Edited for Rev 1], [Measures].[Change in Account Productivity], [Measures].[Hours Saved], [Measures].[Lines Per 1000], [Measures].[Average MT Rate - Total Production], [Measures].[Typed Lines], [Measures].[Productivity Time in hours - Edited Docs],[Measures].[Productivity Time in Hours - Typed Docs],[Measures].[Productivity Time in Hours]} ON COLUMNS, NON EMPTY { ([Dim Customer].[Customer Name].[Customer Name].ALLMEMBERS * [Dim Customer].[Dictator Site Name].[Dictator Site Name].ALLMEMBERS * [Dim Date].[The Month].[The Month].ALLMEMBERS * [Dim Date].[The Year].[The Year].ALLMEMBERS * [Dim MT].[Creator Last Name].[Creator Last Name].ALLMEMBERS * [Dim MT].[Creator First Name].[Creator First Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@FromDimDateTheYear, CONSTRAINED) : STRTOMEMBER(@ToDimDateTheYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOMEMBER(@FromDimDateTheMonth, CONSTRAINED) : STRTOMEMBER(@ToDimDateTheMonth, CONSTRAINED) ) ON COLUMNS FROM [ETL DW])) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection) System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)
I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing:
1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx. this webservice has a method called "GetXMLDocument" that has 1 parameter (sql). This method uses the sql statement to fill a dataset from a SQL Server database, converts it to an xmlDocument, and returns the xmlDocument. Here is a sample of the results:
<?xml version="1.0" encoding="utf-8" ?> - <NewDataSet> - <Table> <ReportName>GirlsNamedMary</ReportName> <ReportFriendlyName>All Girls Named Mary</ReportFriendlyName> <ReportDescription>This is a test SQL Server Reporting Services report. It has no parameters.</ReportDescription> </Table> </NewDataSet>
2. I created a datasource in my reports project as follows: - Name: TestDataSource - Type: XML - Connection string: http://localhost/myWebDirectory/myService.asmx
3. I created the following dataset: - Name: TestDataSet - Data source: TestDataSource - Query string: <Query xmlns="http://tempuri.org/Service/GetXMLDocument"> <Method Namespace="http://tempuri.org/Service" Name="GetXMLDocument"/> <ElementPath /> </Query>
I am getting this error: ------------------------------------------------------------------------------------ An error occurred while executing the query. Failed to execute web request for the specified URL.
Additional Information: ----> Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions). ------------------------------------------------------------------------------------
I cannot figure out why I have this error. The service runs fine from the browser, but I just can't get it to work in Reporting Services. What am I doing wrong?
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified. Restored my Reportserver and ReportserverTempDB databases Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'? Is it possible to migrate from 32bit to 64bit?
Hello,Can I import an OLTP (Reltional DB) as a Data Source into SQL ServerAnalysis Services 2005 and then use the Cube Wizard and the new DataSource View feature to create the OLAP model ?Or do I have to first design an OLAP Data Warehouse with a Star Schemaand then import this DW as a Data Source into my Analysis ServicesProject.With SQL Server 2000 , OLAP would be the way to go..but with SQLServer 2005 , it seems as though the wizard and data source viewfeatures do half the work for you.I have an OLTP DB and am not sure which route I should take ! Anysuggestions / input would be much appreciated.Thanks in Advance...RegardsRusszee
System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
Source Error:
Line 206: [return: System.Xml.Serialization.XmlElementAttribute("executionInfo")] Line 207: public ExecutionInfo LoadReport(string Report, string HistoryID) { Line 208: object[] results = this.Invoke("LoadReport", new object[] { Line 209: Report, Line 210: HistoryID}); Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs Line: 208
Stack Trace:
[SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings) at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save() at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo) at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)] System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +533462 System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204 Reporting.ReportExecutionService.LoadReport(String Report, String HistoryID) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs:208 _Default.RenderReport(String client_short, String gobj_long, String event_date, String event_time) in c:WebsitesReportTestDefault.aspx.cs:68 _Default.Button1_Click(Object sender, EventArgs e) in c:WebsitesReportTestDefault.aspx.cs:22 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Looks like I need some additional adjustment on the authentication. But I do not know where and how.
I try to change the webservice identity but after changing the user identity of the application pool in iis ( I think this is the only way to change webservice identity) I got the error message service unavailable in IIS. With this I also couldn't start the webfront end any more. Switching back to NT-AuthorityNetwork Serive the web front end worked again.
I tryed to add
Code Snippet<identity impersonate="true" />
to the web config and I get the same Error on the webserver account...
It would be great if someone could help me to adjust the settings...
Hi, I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services. In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found" Does anyone have any ideas? Thanks
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
I have a table is SQL server database A that is my source. I have another database B which is accessed via webservice call.(its a CRM server basically). My intention is to transfer data from A to B while B is accessible only via web service. I need to update existing one and create the missing one.
Currently I am using script component, and on every insertion of a row, i call the webservice to check if the record exist or not. If it exist I update it else create it using webservice call itself.
All this happen in Input0_ProcessInputRow(Input0Buffer Row) function.
Now this method is making 2n webserive call which is making the performance very slow.
I want to optimize the approach. Is there a way where I can retrieve whole set of rows in source table in preexecute(), filter it and store it in a List. This way, i just need to check the list a perform update ro create accordingly preventing my webservice call.
How to optimize this or even some better approach?
Its actually a CRM server and I am trying to update and create contacts in CRM sync with a database.
I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
I'm trying to make some reports using the sql 2005 reporting services addin for Visual Web Developer Express 2005. I download the add-in here. So far it installed "successfully". The problem i have is when i try to add a datasource to the report at "Report > Data Sources... " it gives me an error saying: "The system cannot find the file specified."
Another Error it gives is that when I try to drag a DataSet field from the Website Data Sources toolbox tab the visual web developer crashes :/.
An observation that I don't know if this is ok is when I create a new Data Source it creates an App_Code folder inside where my report is /Reports/ and there it saves the DataSet. Just an observation...
This is my development enviorment:
Laptop:
Windows Vista Home Premium (Up to date) Microsoft Visual Web Developer 2005 with Service Pack 1 Reporting Add-In for Microsoft Visual Web Developer 2005 Express
Server:
Microsoft Windows Server 2003 IIS 6.0 ASP.NET 2.0 Microsoft SQL Server 2005 Express Reporting Services for SQL Server 2005 Express
I am searching for a solution for Calling or consume a web service in SSIS through Script task. I have gone through so many links but i am able to find the exact solution. I am getting so many references, though i am unable to crack it.
My requirement is i need to call a web service URL through script task which is having a client certificate. When we are trying to connect to the URL it will ask for the certificate authentication. After calling this URL we will get a WSDL file from the web service, We need to consume that WSDL file and we need to identify the methods inside this WSDL and need to write the data available in this WSDL to the data base tables.
How can we call that web service URL( With certificate) through script task and how can we read the WSDL file and How we can load the data into DB table.
Hi, I want to get data from Oracle 10g Stored procedure to Reporting Services 2005. I could pass a SQL text and get a record set, but I want to execute a store proc and get the record set.
1. Add New Data Source 2. Choose Type : Oracle and connection tested OK 3. { call Test_Package.Test_Procedure(?) } is it wrong... how to write??? There is an error in the query. ORA-00911: invalid character
Also make sure that you use the text-based generic query designer (2 panes !) instead of the visual query designer (4 panes) - you can switch between them through an icon on the toolbar in the data view of report designer. Question : I tried many methods but unable to solve it...
create or replace PACKAGE Test_Package AS TYPE Test_Type IS REF CURSOR RETURN Test_Table%ROWTYPE; END Test_Package;
create or replace PROCEDURE Test_Procedure ( Test_Cursor IN OUT Test_Package.Test_Type, Test_Parameter IN Test_Table.ID%TYPE ) AS BEGIN OPEN Test_Cursor FOR SELECT * FROM Test_Table WHERE Test_Table.ID >= Test_Parameter; END Test_Procedure;
The below site gave some example but i could not solve it... any suggestions greatly appreciated...
I am new to SQL Reporting services and learning from website tutorials. I could easily connect to Adventure Works database and could create some reports. Now I want to create one report from Oracle database in my network on one of my server (Network computer). I could not connect to database as do not know what to write (is path like Server name or IP address 152.168.1.25 Oracle database name) is required in Server name field? Server Type should be OLE DB or Oracle and OLEDB Provider should be Microsoft OLE DB Provider for Oracle? Then Server of filename? Is there any tutorial or material available, which can help me in establishing this connectivity? Any help is greatly appreciated.Do I have to install any thing on my local computer for oracle ( as read in one of forum for Oracle Client or something like that)
Is it possible to consume the sql 2005 web service from 1.1? When I try and do so I receive the following error:Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:varchar' is not declared or not a simple type. An error occurred at , (1, 2452).
I'm using Report Builder to create a new report. The problem I'm having is that once I choose a Field from an Entity in the Entities list I can only choose Fields from that Entity. For example, I have two Entities, one called Customers and the other called Delivery. Within the Customer Entity I have several Fields that I want to add to my report, say First Name and Last Name. From the Delivery Entity I have a Status Field which I'd like to include but because I have no way to get back to my Entities list, without removing the Fields from my Report, I can't include that Field.
If I remove the Fields from my report, the Entities list then populates with both the Customers and Delivery Entities, THEN I can choose my Delivery Entity and select the Status Field. But I can't get back to the Customer Entity. I keep going back and forth.
I'm not exactly sure what I'm doing wrong, or if there is a more efficient manner to accomplish what I'm trying to do.
What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.
I am getting the following error while I am connecting SQL 2005 reporting services through local and outside
http://localhost/reports
http://servername/reprots
I configured through all the stems through reproting services configuration
You advise/suggestion is greately appriciated.
Ven
---------------------------------------
Server Error in '/Reports' Application. --------------------------------------------------------------------------------
An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowElementMissing(String element) +41 Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1104 Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166 Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62 Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296 Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134 Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84 Microsoft.ReportingServices.UI.Global.get_Configuration() +4 Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR.
The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message "An error occurred while retrieving the parameters in the query. The stored procedure 'mysp' doesn't exist.
I have a sql server 2000 database and sql server reporting services 2000 installed on it i want to install 2005 sql reporting services on sql server 2000 Is Sql server reporting services 2005 works fine with sql server 2000 and what are the settings that i have to perform.