Sql Server 2005 Reporting Services And XML Webservice DataSource

Dec 14, 2007

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:

http://www.ignyte.com/webservices/ignyte.whatsshowing.webservice/moviefunctions.asmx?wsdl

I am trying to call in using XML DataSource and with absolutely no luck. Here are the steps I have followed:

DataSource type: XML
Connection String: http://www.ignyte.com/webservices/ignyte.whatsshowing.webservice/moviefunctions.asmx

Report Data Quert:

<Query>
<SoapAction>http://www.ignyte.com/GetUpcomingMovies</SoapAction>
<Method Namespace="http://www.ignyte.com/whatsshowing" Name="GetUpcomingMovies">
<Parameters>
<Parameter Name="month">
<DefaultValue>12</DefaultValue>
</Parameter>
<Parameter Name="year">
<DefaultValue>2007</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath>RunQueryResponse{}/RunQueryResult{}/diffgram{}/DataSetName/TableName</xmldp:ElementPath>
</Query>


I am getting an error: The XmlDP query is invalid. (Microsoft Report Designer)


Any help? I am trying to figure out this simple example so I can apply it to my own webservice.

Thanks

View 1 Replies


ADVERTISEMENT

Reporting Services 2005 And XML DataSource (as WebService)

Apr 25, 2006

I'm trying to build WebService to use result as DataSource for RS 2005 (XML DataSource).

But I have a strange problem.

I have WebMethod with parameters.

When I'm testing my WS in browser then everything works just fine.


But... When I'm trying to call this web-service from VS2005 environment then something strange happens.

Looks like VS passing parameters incorrectly to my WS (not passing at all!)


I've created very simplyfied version just to check parameters:

using System.Xml;
using System.Xml.Serialization;
using System.Messaging;
using System.Text;
using System;
using System.Web.Services;
[WebService(Namespace = "http://company.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class GetRemoteData : System.Web.Services.WebService
{
[WebMethod]
public XmlElement GetData(string CompanyName, string FunctionName, string ParameterList)
{
XmlDocument xmlDocument = new XmlDocument();
XmlElement xmlElement1;
xmlElement1 = xmlDocument.CreateElement("parameters", "values", "urn:errors");
xmlElement1.InnerText = String.Format("{0}, {1}, {2}", CompanyName, FunctionName, ParameterList);
return xmlElement1;
}
}



In the browser WS returns all passed parameters back correctly. VS - not.


What's wrong with my code? Why MSDN example works fine?
Do I need to specify some undocumented (soap specific) attributes?


Where I can find full tutorials how to create RS-compatible web-service?

(Sorry for cross-posting but I have no single reply...)

View 3 Replies View Related

Webservice Calls With Parameters From Reporting Services

May 21, 2007

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



<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
</Query>



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



<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlnsoap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<listName>string</listName>
<viewName>string</viewName>
<query>
<xsdchema>schema</xsdchema>xml</query>
<viewFields>
<xsdchema>schema</xsdchema>xml</viewFields>
<rowLimit>string</rowLimit>
<queryOptions>
<xsdchema>schema</xsdchema>xml</queryOptions>
</GetListItems>
</soap:Body>
</soap:Envelope>





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.



<FieldRef Name='Title'/><FieldRef Name='Address1'/>



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).

View 1 Replies View Related

2005 Reporting Srv Cannot Connect To Oracle Datasource On Web Server

Nov 18, 2006



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)

any thoughts or direction greatly appreciated

View 4 Replies View Related

SQL Server 2005 Reporting Serivces: XML Datasource Problem

May 24, 2006

Hi,

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?

View 17 Replies View Related

Binding WebService As Datasource

Feb 22, 2007

I've painstakingly managed to get a XmlDocument from a webservice and run this to retrieve data.

However, i cannot bind any of the returned elements to anything. Any help appreciated.



View 1 Replies View Related

Using A WCF WebService As Report Datasource

Jul 25, 2007

Hello all,



When trying to configure a WCF service as a report data source I have these following questions:



1. What do I need to provide for the connection string?
I currently wrote http://localhost:8003/ServiceName/ which returns the WSDL. Is that correct?



2. I don't know what to write inside the Query defintion. I currently wrote:



<Query>
<SoapAction>
http://tempuri.org/ServiceContractInterface/MethodName
</SoapAction>
<Method Namespace="http://tempuri.org/ServiceContractInterface"
Name="MethodName">
</Method>
</Query>



and the result is:

Failed to prepare web request for the specified URL. (Microsoft.ReportingServices.DataExtensions).



Can any one please point me in the right direction?!

Thanks.

View 4 Replies View Related

Xml Datasource For Reporting Services

Mar 15, 2008

help pls - pulling hair out on this one

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...

thx


View 6 Replies View Related

Sharepoint List As Datasource In Reporting Services ?

Oct 25, 2007



Hi everybody,

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 ?


Thanks for your response,


Have a nice day,

Aurore

View 3 Replies View Related

Unable To Configure Reporting Services To Use SSIS Datasource

May 16, 2008

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.

http://msdn.microsoft.com/en-us/library/ms345250.aspx
http://msdn.microsoft.com/en-us/library/ms159215.aspx

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.

View 1 Replies View Related

Reporting Services :: Creating Datasource As ODBC With AS / 400 For SSRS Report

May 22, 2015

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.

View 2 Replies View Related

Reporting Services :: SSRS Internal Error When Try To Explore Manage Option Of A DataSource

Jan 28, 2014

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:

[code]...

View 11 Replies View Related

Visual Studio Hangs When Generating A Reporting Services Report With Cube As The Datasource

Mar 7, 2007

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

View 1 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

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?

Any help is appreciated

View 1 Replies View Related

Can We Install Reporting Services 2005 In A Machine In Which Is Not Installed SQL Server 2005

Nov 19, 2007

Hi,


Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?

Thanks

View 3 Replies View Related

OLTP Vs OLAP (Data Warehouse) As A DataSource In Analysis Services 2005

Jul 3, 2007

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

View 1 Replies View Related

SQL Server 2005 And Reporting Services

Apr 8, 2006

Why doesn't SQL Server 2005 need IIS for its http readiness while its Reporting Services do? Thanks.

View 2 Replies View Related

Reporting Services - SQL Server 2005

Mar 3, 2007

We are in the process of doing a side by side installation of the SQLserver 2000 and SQL server 2005 on the same server. To install theReporting services feature of SQL server 2005 requires IIS. We have aseperate web server running IIS that connects to the database server.My question is : can we still install Reporting services on thedatabase server without the IIS?Thank you

View 1 Replies View Related

SQL Server 2005 Reporting Services And ASP .NET 1.1

Oct 26, 2007

Hi,
Our team is developing an ASP.NET 1.1 Application that is written using VS2003 but using SQL Server 2005 as database. Can we use a Report Viewer Control that comes with SQL Server 2005 in our ASP.NET 1.1 application? If not, Can some one suggest some alternative way of showing SQL Server 2005 Reports in ASP.NET 1.1 application?


Thanks,

CodeKracker

View 1 Replies View Related

SQL Server 2005 Reporting Services

Feb 13, 2008

Dear Friends

When try to Install SQL Server 2005 Dev. Edition in Windows Vista Home Premium
Reporting Services Option Found Disabled.

As per Requirment IIS 7 (all options) Enabled and having IE 7.0

Expecting Favour from all friends.

Thanks

View 10 Replies View Related

SQL Server 2005 Reporting Services

Jan 29, 2007

How can I integrate report builder, Report Designer into my .Net application.? Please Help me?.

View 1 Replies View Related

SQL Server 2005 Reporting Services

Apr 10, 2008

Does anyone know how to beautify the parameter control layouts on a report header?

For example I have a drop down multi selection control for a parameter for a report. I'd like it to be three times as wide. I could just add spaces to the labels but I'd prefer a more elegant solution.

SQ

View 5 Replies View Related

SQL Server Reporting Services 2005

Sep 19, 2007

hi,
i am using SQL server reporting services 2005. but when i tried to deply onto the report server, i am getting error "rsReportServerServiceUnavailable". can anybody tell me what is the problem. manytimes i m getting this error.

thanks and regards,
vishruti.

View 1 Replies View Related

Sql Server Reporting Services 2005 Limitations

Dec 20, 2007

Hi,

Apologies for the generic subject heading but I have a client who at my suggestion has implemented a reporting solution using SSRS. However, we are now finding serious limitations with this solution, primarily regarding exporting matrix data to Excel. The major concern is that after exporting matrix data you cannot sort, filter or format properly as we cannot repeat the group data, merged cells is also another big problem.

They are now seriously looking at bringing in different technology to address these problems and I was wondering if anybody had any positive ideas, as to how I can provide a way forward and overcome our issues?

Can I easily add an add-in to the existing export options, does SQL 2008 offer any improvements, are there any 3rd party offerings out there?

Grateful for any advice.

View 3 Replies View Related

SQL Server 2005 Reporting Services Not Starting

Oct 11, 2007


Service cannot be started. System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Library.Global' threw an exception. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file. (C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinReportingServicesService.exe.config line 5)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
--- End of inner exception stack trace ---
at System.Configuration.ClientConfigurationSystem.EnsureInit(String con...

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any tips would hugely help. I checked this config file and have not seen this info in the file.

View 1 Replies View Related

SQL Server 2005 Reporting Services Designer

Sep 14, 2007

Is there a control in SQL Server 2005 Reporting Services similar to Crystal reports Designer control that can be embedded in third party applications that allows their user to design their own reports through the application.

Basically we are using the crystal control in our current software and are looking to move Microsoft reporting services

Your comments would be greatly appreciated.
Thanks

View 1 Replies View Related

SQL Server 2005 Reporting Services Problem

Jun 10, 2007

I have recently installed SQL Server 2005 on Windows 2003 R2 Server (Standard Edition). When I run Reporting Services Configuration Manager, I get a message "Invalid Namespace". What could be wrong?

View 3 Replies View Related

Adding SQL Reporting Services To SQL Server 2005 SP1

Aug 7, 2006

I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases:

! Verifing Database Version

The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database.



! Creating upgrade script for database version C.0.8.40

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version.


at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)

I've reinstalled the entire SQL Server 2005 installation. As part of company installation precodure, SQL 2005 w/o Reporting Services is installed first, followed by SP1. I then perform the SQL Reporting Services installation add-on.

Thanks,

Mark



View 10 Replies View Related

SQL Server 2005 Reporting Services Integration

Jan 29, 2007

How can we Integrate SQL server 2005 Report builder, Report designer in a custom .Net Application ? . Please Help me.

I want to provide Report Designer, Report builder and Query builder functionalities to my .Net application. How can I Integrate them in my application?

View 3 Replies View Related

SQL Server 2005 Reporting Services Presentation

Feb 13, 2007

Hi, I'm looking for SQL Server 2005 Reporting Services presentation.

Anybody help, please.

Thank you.

View 1 Replies View Related

Need A Quick Answer About Reporting Services In SQL Server 2005?

Jun 26, 2007

Hi all,

I apologize in advance for the lack of homework before posting, but I am just looking for a quick answer, or a quick point in the right direction to figure this out.

I have a developer from an adjacent team that wants to use Reporting Services in a SQL Server 2005 installation.

From what I found online during what I thought was a definitive search yesterday, I gave him the MSDN SQL Server 2005 DVD and told him that Reporting Services is now part of the standard installation. Which is what my brief search yesterday indicated to me.

He did the installation (full, according to him) and said he could not find Reporting Services.

So, the quick question is...

Where is Reporting Services in SQL Server 2005? I don't have a separate MSDN DVD that contains it as was the case on SQL Server 2000. This further supports my (wavering) position that it is part of the standard installation.

Thoughts? Direction? Collective kicks in the posterior?

Thanks!

View 6 Replies View Related

Bursting Reports Using SQL Server Reporting Services 2005?

Nov 30, 2006

Can someone please let me know how to achieve Report Bursting property in SQL Server 2005 Reporting Services ?

View 3 Replies View Related

SQL Server 2005 Reporting Services Add-in For SharePoint, Installation

Nov 27, 2006

Setup:  Windows server 2003 SP1, SQL 2005 SP2, Sharepoint Office server 2007, Report Services addin (CTP v9.00.3027).

 

Using the Report server configuration tool,  setting Report Server Virtual directory, end up with RS Configuration tool crashing.

It appears to be happening on the task "Changing Secure connection level", & returns "System.NullReferenceException was unhandled
Message: Object reference not set to an instance of an object."

 

any ideas?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved