.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSRS DatsSource as XML (using WebService)

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :ASP.Net
 
Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error:"You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)


View Complete Post


More Related Resource Links

SSRS 2005 WebService Programatic Multiple Parameters?

  
I am using ssrs webservices with c#. Works great until I try to pass in multiple parameters then I get: "Default value or value provided for the report parameter 'X' is not a valid value." I am at a loss - I have the split function in my stored procedure and can pass in the values like '01/05/2010,01/062010' etc no problems. I have tried wrapping the comma seperated string with single quotes and without, tried adding them as seperate inputs with no luck same response. Report works fine from SSRS interface but not when calling it using web services. Any assistance is greatly appreciated - I have done numerous web searches and found no answers. Below is the c# code snipet: //set up the parameters List<ParameterValue> input = new List<ParameterValue>(); ParameterValue pval = new ParameterValue(); pval.Name = param.Name; pval.Value = "'" + paramsSelected + "'"; input.Add(pval); //call the report service.Render( ReportName, "PDF", null, null, input.ToArray(), null, null, out encoding, out mime, out outParams, out outWarn, out outStreams);

SSRS DataSource as XML (Using WebService) Error: Credentials

  
Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error: "You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)

Is there any Sharepoint 2010 Webservice call that I can point my SSRS Report at to retrieve an execu

  

I want to create an SSRS report that displays all the steps in an executing workflow along with its current stage.

SharePoint 2010 webpart shows the current state of the executing workflow but I want to display all the steps including ones that have been completed and ones that are still to come.


SSRS Webservice issue on the hosting account

  

 I have couple of reports deployed on a hosting server. When I run my code to generate PDF files using these reports from my local machin it works fine. But when I run the same code on the hosting server I get the following error message. It seems that the service acocunt does not have enough permission in Temp ASP.NET folder on the hosting server. What can be done to resolve this issue?

Error Details:

Server Error in '/' Application. 
________________________________________
The request failed with HTTP status 401: Unauthorized. 
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.Net.WebException: The request failed with HTTP status 401: Unauthorized.

Source Error: 

Line 264:        [return: System.Xml.Serialization.XmlElementAttribute("executionInfo")]
Line 265:        public ExecutionInfo LoadReport(string Report, string HistoryID) {
Line 266:            object[] results = this.Invoke("LoadReport", new object[] {
Line 267:                        Report,
Line 268:                        HistoryID});

Source File: c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\3a1f18d1\6aa08967\App_WebReferences.hy

saving XML output from webservice

  

 I created a webservice that takes casenum as input and gives results as a dataset in an XML.

I could make a web client to display the resulting dataset in a grid view. Pls see my code copied below.

Now I want to create a console client that takes the casenum as input, to call the webservice and saves the resulting xml for further processing, but can't figure out how to just capture the xml to save. Here's the code for my web client. I would appreciate if you could help modify this tocapture the resulting xml to save file locally.

Thank You.

namespace ResultsWebServicesClient
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }

        private void BindDataToGrid(string CaseNum)
        {
            FG_Results results = new FG_Results();
            DataSet ds1 = new DataSet();
            ds1 = results.Get_FG_Results(CaseNum);
            GridView1.AutoGenerateColumns = true;
            GridView1.DataSource = ds1.Tables[0];
            GridView1.DataBind();
        }

        protected void GetResults(object sender, EventArgs e)
        {
            BindDataToGrid(CaseNo.Text);
        }

    }
}
 

HTTP Post and WebService

  

I am working on a application which will accept the data in the post request. My application also wants to expose a web service and want to call another web service. Considering all these 3 action that I want to do, can I create a single application which will have a web form which will accept the POST request and expose a web service at the same time.

Although it may be possible to achieve this, Is this a correct way of doing it?


Calling webservice from the server

  
Hi

I have a sample web service and aspx file. I deployed them to an existing website that contains classic asp files.

web-service: --- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; [WebService(Namespace = "http://localhost/MyWebServices/")] public class MembershipRegisWebService : System.Web.Services.WebService { public MembershipRegisWebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string HelloWorld() { return "Hello World."; } }

aspx.cs file: --- using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Services; public partial class CallWebService : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { MembershipRegisWebService mrWs = new MembershipRegisWebService(); Response.Write("Calling web service:" + mrWs.HelloWorld()); } }

It runs locally, but it shows an error when running it from the server:

Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the follow

C# / Java webservice

  

I am writting a client applicatin that acesses a webservice written by another company.  I need to test against this webservice but since it is live I need another place to test with.  I don't have access to the code from the webservice but have added a reference to my project.  I would like to create a test platform using C# which will run on IIS and not Java.

I have created a basic webserive using both the NetBeans platform and the VS/C# platform.  The problem I am having is if I dynamically change the web address from one to the other my client application complains that the webservice is invalid.  I have verified all the calls are the same.

Are there any setting with VS/C# that allow me to configure it to behave more like the Java webservice?  I don't have the server support to host the Java application for full testing along with other problems using the Java version.

I have run both services in the "WCF Test Client" and can see where the WCF service uses the varibles for request and the Java uses body/request but can't get the WCF to follow that format.  I read somewhere about changing the OperationContract with SoapRpcMethod but then the mentod is not longer exposed. I also tried a Web Service in .NET 3.5 instead of a WCF server but that seems to be more trouble and does not

where can i download from SSRS?

  

Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?

 

Thanks in advance

Suresh


MDX Query parameter from SSRS

  

Hello,
I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )

 

 


How to change text in columns in SSRS?

  

I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.


Printing crystal report from webservice

  

Hi,

I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?

Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you

Arya


Writing Data to database with jQuery Forms, ASMX Webservice, & JSON - help!

  

Hi, 

Can someone point me in the right direction on how to submit data from a jQuery form to a ASMX webservice? I have gotten everything on the form ready to be submitted to the database and now I am stuck on how to send it over using $.ajax(). Everything I have read tells me how to get data from a webservice and display it with jQuery, but not the other direction nor how to access the json data within the within the webservice service(similar to a Request.Form approach with ASP.NET forms).

In other words: 

1. What do I need to do to my webservice to make sure it can receive data from the jQuery form. 

2. What do I need to do in jQuery to receive an acknowledgement the save on the server side was successful. 

I can explain more if need be, but if there is a comprehensive tutorial on not only reading, but also WRITING data with jQuery, JSON, etc. I would love to get pointed in that direction. 


Webservice using socket layer programming

  

Hi,

   I want to access a webservice in asp.net programming. This webservice was done using socket layer programming and also i am having the ipaddress and port address. Did any one know about how to access webservice using socket layer and if know let me know how to access the webservice. Thank you





Is Conditional Subscription possible in SSRS 2005?

  

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???

 


problem with webservice

  

Hi

I wrote a program that connects to a webservice (with client side script such as jquery) and fetches data from  the webservice.

Now the program is working properly in local system, but when I upload it to host, the script cannot connect to the webservice.

What is the problem?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend