Bug In SSRS SetItemDataSources Web Service Method

Dec 19, 2007

Bug:

An existing SSRS 2005 data source at the root directory cannot be used by the SSRS SetItemDataSource web method.

Steps to reproduce:
1. On the machine running SSRS 2005, create a folder named Reports and upload an RDL file named "Existing.rdl" into that directory. For clarity the SSRS path to this report is /Reports
2. Set up a valid data source at the root directory (For illustrative purposes we'll name it DS).
3. Set up a web reference to a SQL Server Reporting Web Services 2005. e.g. http://localhost/reportserver/reportservice2005.asmx

3. Try to set the DS data source to the "Existing" report by calling the SetItemDataSource web method.

C# Code Excerpt:
...
try{

ReportingService2005 reprtSrvc = new ReportingService2005();

DataSource[] dsarray;
string reportName = "Existing"
string _selectedFolder = "/Reports/"
DataSourceReference reference = new DataSourceReference();
DataSource ds = new DataSource();
dsarray = new DataSource[1];
reference.Reference = "/";
ds.Item = reference;
ds.Name = "DS";
dsarray[0] = ds;
//Exception thown ...
_reprtSrvc.SetItemDataSources("/" + _selectedFolder + reportName , dsarray);
}
catch (SoapException ex)
{
//Exception
Message.displayMessage(ex.Detail["Message"].InnerXml, MessageType.Error);

}
...

Exception details...

ex {"System.Web.Services.Protocols.SoapException: The operation you are attempting on item "" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "" is not allowed for this item type.
at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.ResolveNewDataSources(DataSourceInfoCollection newDataSources, Boolean forModel)
at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.SetReportDataSources(CatalogItem item, DataSource[] dataSources)
at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetItemDataSources(String Item, DataSource[] DataSources)"} System.Web.Services.Protocols.SoapException

View 4 Replies


ADVERTISEMENT

SSRS Web Service Render Method Documentation?

Dec 28, 2007

Hi all does anyone know where I can find more information on the Render method of the Reporting Services WS?
Specifically there is a DeviceInfo parameter that you need to pass in and it is a string that is in an XML format but I cannot seem to find any documentation on the specifics of it. I have seen a few examples but no specifics.

Any help with this is greatly appreciated?

Thank you,
John



View 3 Replies View Related

Best Method To Access Web Service

Aug 14, 2007



We have a billing web service where you passs in the account and amount and get returned an XML string with result.
I had suggested that I open up an endpoint and have the service listen for messages but the programming team wont go for it.

What is the best method for me to call an external web service? I have tried sp_OACreate and run into memory leaks and have not had much luck with assemblies. See http://www.codeproject.com/script/comments/forums.asp?forumid=1725&select=2180035&df=100&msg=2180035

View 1 Replies View Related

Does The SSRS Web Service And Windows Service Share A Common Engine?

Sep 27, 2007

All,

I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.

My question is:

Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?

Any help is greatly appreciated!

Mark

View 4 Replies View Related

Bug - SSRS WS Render Method Not Working As Documented?

Dec 31, 2007



Hello all, according to the documentation for the DeviceInfo parameter of the ReportingService.Render method the Xml string fragment of PageHeight and PageWidth for the Image Device Information Settings should and I quote.


The page height, in inches, to set for the report. You must include an integer or decimal value followed by "in" (for example, 11in). This value overrides the report's original settings.


Emphasis mine. Page width is similar. However when I change that value to what is desired for the IMAGE format it has no effect whatsoever no matter what value I place in there.

Indeed the size that is rendered is more related to the current display resolution setting rather than the PageHeight/PageWidth values passed in. In otherwords if my laptop has a higher resolution of 1920x1200 and the server that I deploy this WS to has a lower resolution of 1280x1024, the image rendered on the higher resolution display fits on to an 8.5x11.0 in page with room to spare but on the lower resolution display it is clipped because it does not fit the page.

Is there something that I am doing wrong or is this indeed a bug?

Thank you,
John

View 4 Replies View Related

ShowhideToggle For Render Method ? - Ssrs 2000

Apr 26, 2007

Hi there.



I had been looking around for some info about this.

So far I understand that the showhidetoggle parameter determines which drilldowns are visible or hidden.



I am trying to use the render method, and try to show the drilldowns on my html page.



First question:

How does the showhidetoggle work in the URL or even show an example of how the drilldowns work through showhidetoggle ? In other words, how does the showhidetoggle knows which one to display if I have only one string value ? Maybe there is another way to do this or another way to define this syntax ?



Second question:

How do i determine the number or the string parameter without having to look through html ? is there a way to do this so that I can pass this string to the parameter in the ASMX ?



Thanks for reading this post !

View 1 Replies View Related

SetItemDataSources Keeps Telling Me The Data Source Cannot Be Found, But It's There... What's The Trick?

Apr 16, 2007

I have a custom folder layout for reporting services on our test environment so each tester can test the reports against the data in their own instances. The developers have reports in a different layout that's more in line with what will be in production. So I figured some simple RS scripting would handle things.



It was easy to create the folder structure, easy to create the shared data sources in each testers reports folders, and easy to deploy the report from the developers folder (source) to the testers report folders. However, when I try to use SetItemDataSources to change the data source in the newly duplicated reports, I keep getting an error telling me that the data source cannot be found.



Here's the relevant code fragment:



'Set report DataSource references

Dim DataSources(0) As DataSource

DataSources(0) = New DataSource



' update with new data source info

DataSources(0).Name = strDSName

Dim Item1 as DataSourceReference = New DataSourceReference

Item1.Reference = strRef

DataSources(0).Item = Item1

Console.WriteLine( "Setting report {0}, data source to {1}", strTargetReport, strRef)

RS.SetItemDataSources( strTargetReport, DataSources)



strDSName is "OLTP", strRef is the path to the shared data source, "/Reports/Tester1/Data Sources/OLTP". strTargetReport is the name of the report itself, full path name to "/Reports/Tester1/Report1".



Each tester has their own folder off the main reports folder "Reports", with an incremental number, as in "Tester1". Each testers folder has it's own Data Sources folder. There is only one data source for all reports, "OLTP".



/Reports

/Reports/Tester1

/Reports/Tester1/Data Sources

/Reports/Tester1/Data Sources/OLTP

/Reports/Tester1/Report1

/Reports/Tester1/Report2



I even went into SQL Server Management Studio and tried changing the (now broken) data source setting for a report to point to the correct data source (OLTP), then copied the generated script, then ran it - and still got the data source cannot be found error. That's what my latest code shown above was based on.



Anyone got any clues?



Thanks,

--Stan

View 3 Replies View Related

SQL 2012 :: SSRS Virtual Directory - HTTP GET Method Appending Default Path

Sep 27, 2015

There was a 2008 SSRS service running on server "abc".

I have a .Net UI that uses the wsdl at [URL] ....

They deployed SSRS 2012 service on a new server "xyz".

DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.

when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.

I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?

View 0 Replies View Related

Calling Web Service Using SSRS!!!

Feb 4, 2008

Hi,
Is it possible to call a Web Service using SSRS and bind the dataset to the the table in the Report? Please share your views.

Thanks and Warm Regards
Saanj

View 4 Replies View Related

SetPolicy - Using SSRS Web Service

Mar 23, 2006

Am using the Web service of SSRS to assign the roles for a user (which is already available in Report Manager).

Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetPolicies(@"/",p);

The same I have tried with SetSystemPolicy method also.

Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetSystemPolicies(p);



Where, MyMachineName - is the machine name where SSRS is residing.

bvikas - windows local machine user



I have used the above codes in achieving the mapping between the SSRS role and the windows local user. Getting error on this. I even thought of directly doing the mapping by putting entry in SSRS database. But found that few fields are encrypted and I would prefer to acheive it through API way.

-Muthu

View 3 Replies View Related

Send Request To Stored Procedure From A Method And Receive The Resposne Back To The Method

May 10, 2007

Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString)    {      //call stored procedure  } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.  

View 3 Replies View Related

SSRS WEB Farm ReportServer Service

Jun 28, 2007

Server Software

SQL Server 2000 (all sps up to date)

SSRS 2000 (all sps up to date)



Scenario:

1 - SSRS + SQL2000 Database server

2 - Web servers



We have installed SSRS on 2 web servers that are acting as a web farm for a central Report Server.



After we installed SSRS on the 2 web servers the scheduled reports on the central Report Server stopped working.



We tried disabling the ReportServer service on the web servers and then the scheduled reports began to work again.



Why would the ReportServer service on the 2 web servers interfere with the central Report Server?



Can the web servers be used to load balance the scheduled reports?



Any advice would be appreciated.

View 1 Replies View Related

Service Unavailable - SSRS 64bit

Sep 6, 2006

We've recently attempted to get RS 2005 64bit up and running on MS Virtual Server and the installation seems to have worked properly (the RS Configuration all seemed fine also). However, when going to http://localhost/Reports or http://localhost/ReportsServer, it gives me the message "Service Unavailable". Everything looks good in IIS (using 2.0).

What else can I do to troubleshoot this issue?

View 5 Replies View Related

SQL 2012 :: SSRS Report Deployment To Web Service?

Jun 12, 2014

I created two reports in SSRS and have configured both the web service and report manager URLs in report services configuration manager.

whenever I try to open either one of the two reports from the manager or service I get the following error msg.

"An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

(rsReportServerDatabaseError)

Invalid object name 'DataSets'. Could not use view or function 'ExtendedDataSets' because of binding errors."

I get a similar msg when I try to deploy the reports from VS 2010. Only the first 2 sentences are returned.

I'm mystified as to why DataSets is an invalid object name. It shows as the TargetDatasetFolder name WebsiteReports Property Page. I've looked around for the error source and can not find where this error is stemming from.

View 0 Replies View Related

SQL Service Broker To Send Message To SSRS

Jan 23, 2008

Hi All,
I want to send notification to SSRS on change in database for that I am using SSB to send message to SQL Server Reporting Services.
Can I use SSB and if yes, how? Please guide me I am new to this.

Thanks,
Omkar.

View 1 Replies View Related

Is There A Separate SSRS 2005 Service Pack?

Apr 21, 2008

Hi,

Is there a separate service pack 2 for SQL Server Reporting Services 2005? I know there is a SP2 for SQL Server 2005 that was just released. I'm asking because SRS 2000 had a service pack separate from the SQL Server service pack.

Thanks.

View 3 Replies View Related

Sql Server 2005 Reporting Service (Chart) Help SSRS

Aug 6, 2007

Hi frineds,

i created the 1 report with pie chart ,but i am unable to display the values in the pie chart region inside the each colors


i am displaying the marks of a studnet ,but here

just like for each region we need the value HOW TO SET please help me in the properties or else (WHERE ?)
-------------------------
10 (red color)
-------------------------
30 (green color)
--------------------------------

View 4 Replies View Related

Return Dataset Field Collection With SSRS Web Service

Apr 15, 2008

Is there a way to return the fields collection of a dataset using the Reporting services Web Service? I can get to the reports but not the datasets. Thank you in advance for any support you can provide.

View 1 Replies View Related

Update Method Is Not Finding A Nongeneric Method!!! Please Help

Jan 29, 2008

Hi,
 I just have a Dataset with my tables and thats it
 I have a grid view with several datas on it
no problem to get the data or insert but as soon as I try to delete or update some records the local machine through the same error
Unable to find nongeneric method...
I've try to create an Update query into my table adapters but still not working with this one
Also, try to remove the original_{0} and got the same error...
 Please help if anyone has a solution
 
Thanks

View 7 Replies View Related

How Can I Find Out If SSRS 2005 Service Pack 2 Is Been Installed On My System?

Aug 30, 2007

How can I find out if SSRS 2005 service Pack 2 is been installed on my system?

View 4 Replies View Related

Reporting Services :: Domain Account Used For SSRS Service Keeps Getting Locked Out

Oct 15, 2015

Sometimes I have to unlock the account 3 or 4 times a day. This is getting annoying. Why would my service account keep getting locked out?

View 3 Replies View Related

SQL 2012 :: Change Existing SSRS Mail Service From Internal To Office 365

Oct 22, 2015

We were recently acquired and need to move our existing SSRS 2012 mail server from our internal SMTP service. The internal service doesn't need to have a 'real' account to send email out. Everything seems to be setup and running under the internal service.I think I need to change the Email Settings information in "Reporting Services Configuration Manager". Namely the Sender address and SMTP Server fields. But without actually making these changes, I don't see where it is going to ask for the password. Really hate to make changes on a production server.

Do I need to change the "Log On As" account in the "SQL Server Configuration Manager" as well? If so, does this need to be the same account as used in the Sender Address (above)?. there is a lot of ink about making additions to the "rsreportserver.config" file. Our existing file does not have any of these entries.

View 0 Replies View Related

Reporting Services :: How To Enable HTTP For Existing SSRS Service With HTTPs

May 19, 2015

How to enable http for SSRS service in my current sharepoint 2013 environment with https.

this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.

View 3 Replies View Related

Reporting Services :: Passing Parameters To SSRS That Is Using Web Service As Data Source

Jul 16, 2009

I am building a webapp that calls an SSRS instance to display a report based on another servers web service.I can make a call from the ssrs server using this in the RDL:

<Query>
<Method Namespace="http://machine/webservices" Name="HelloUser">
                <Parameters>
                                <Parameter Name="user">
                                <DefaultValue>Craig</DefaultValue>
                                </Parameter>
                </Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
</Query>

This works no problem.  but.. I want to have the user parameter "Craig" be a parameter passed in from the web app.  If it were a regular SQL data source you would put @user in the query.  How do you do it with XML text queries?

View 5 Replies View Related

Error Logon Failed - SSRS Service User Account Rights

Jun 12, 2006

I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link:



Logon failed.

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool



Thanks,





Thomas

View 6 Replies View Related

How To Figure Out If The Dataset Returned Any Data Or Not While Rendering The Report Through The SSRS Web Service

Jan 12, 2007

In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out.

I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body).

Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of the resultset, before calling the SSRS Render method. But it might not be an efficient method.

Was wondering the the SSRS Web Service provides an property or method that can let me figure out whether the resultset was empty or not (after the report execution).

Thanks.

View 1 Replies View Related

Full Feature Demo For SSRS Web Service Rendering (with Interactive Sort)?

Dec 16, 2006

Is there any example I can find a full feature demo of SSRS Web Service Rendering with Interactive Sort and other features enabled?

For MS: Indeed I think ReportViewer Control should be an open source component as we as developer needs the flexibility to customize the report viewer interface as well as can learn directly from the control source so to understand how can we integrate better with SSRS.

View 2 Replies View Related

Stopping Cancelling Report Execution Reporting Services Ssrs 2005 Using The Web Service Api

Mar 23, 2008

Hello,
How can I stop a report I started by using:
ReportExecutionService rs = new ReportExecutionService()
.
.
.
rs.Render(...)


I need to stop the report when a user clicks a button in my aspx page.

TIA
gad

View 1 Replies View Related

List Of Parameters Used Together With Rs: Parameter In SSRS 2000 And SSRS 2005

Apr 24, 2007

Hi,

Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?

Thanks,

View 1 Replies View Related

Reporting Services :: Interface Code Compatibility Between Custom Delivery Extension Of SSRS 2008R2 And SSRS 2012?

Sep 3, 2015

Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012

My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?

if not what code changes we should do?

View 3 Replies View Related

The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.

Jul 12, 2007

I have an almost virgin install of SQLExpres running on a WIN2K Pro system.

Have been able to create and connect db to Access 2000 without problem.



Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.

Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:



System Log:



The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.



Application Log:



Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.



TDSSNIClient initialization failed with error 0x271d, status code 0xa.



TDSSNIClient initialization failed with error 0x271d, status code 0x1.



Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.



SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.





If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.



After five days of investigating, researching, reinstalling and waiting I have to ask for help.



Any suggestions or leads?



Thank You in advance.

View 14 Replies View Related

Power Pivot :: Cannot Create Service Instance Because Parent Service Does Not Exist

Sep 28, 2013

I have a VM with SP2013 and SQL Server 2012 SP1. I have installed the powerpivot plugin SP1.But when I run the PowerPivot for SharePoint 2013 configuration tool.

View 3 Replies View Related

What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?

May 18, 2007

Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)

Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.

What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.

View 1 Replies View Related







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