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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

ElementPath during webservices has datasource in report designing.

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

Hi,

I have a requirement to create a webservice which returns dataset, once dataset is consumed by client application(here client app is SSRS report), I need to show dataset 's table value in SSRS rdl report.

When i see XML structure returned to client look like this

<?xml version="1.0" encoding="utf-8" ?>
<DataSet xmlns="http://tempuri.org/">
 <xs:schema id="Results" xmlns=""  
xmlns:xs="http://www.w3.org/2001/XMLSchema"  
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"  
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
  <xs:element name="Results" msdata:IsDataSet="true"  
msdata:UseCurrentLocale="true" msprop:QueryTerms="Cool Bikes;"  
msprop:IgnoredNoiseWords="" msprop:Keyword="" msprop:ElapsedTime="938"  
msprop:Definition="" msprop:SpellingSuggestion="">
   <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
     <xs:element name="RelevantResults"
msprop:IsTotalRowsExact="False">       



View Complete Post


More Related Resource Links

Unable to use XML datasource to run a report on Report server( Report runs fines in Report designer

  
We are trying to run a report which uses a xml file  to load a report on SSRS. We have copied the xml to the Pages folder  and are able to access the xml via the link https://<servername>/Reports/Pages/test.xml This runs fine in the report designer.(i,e we are able to get create xml data source and use a dataset to retrieve the data from xml to the report designer) However when I try to create a XML datasource on the development server and try to run the report , we get the following error Error: An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized. I have updated the XML datasource to use Windows Account which is in the adminstrators group.   Any suggestions or hints are appreciated  

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription

  

Hello,

I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

SQL Server Reporting Credentials work when I edit my DataSource but when I try to preview a report I

  

I have a 64-bit SQL Server 2008 SP1 installation with SSL enabled, Reporting Services, Analysis Services and Integration Services are all running.

When I go into Business Intelligence Studio (on a 32-bit Windows XP client) and create a DataSource it works fine when I click on "Test Connection" but when I try to use the same connection to run a report it fails with an error message of "Login failed for user sa". 

I have saved the password so it isn't something as simple as that.

I am obviously using the "sa" user, not passing through Windows credentials, the password is definitely correct as if I make it wrong on purpose it doesn't work when I click on "Test Connection" any more.

I have tried the OLE-DB connection type and also the "Microsoft SQL Server" connection type, both show the same behaviour.

On the server I can see in the SQL Server logs, "login failed for sa user, password does not match" type errors; loads of them.

I can connect to SQL Server Management Studio using the same credentials and it is all fine.  So this is just a problem with SSRS.

This DOES work for some users.  I can save the project, load it on another PC and it works fine.  Getting the same user to log on to my PC doesn't help so it must be something about my PC??


Error trying to select analysis services datasource for new report

  
Does anyone know how to resolve the issue when presented with the following error message when trying to select a datasource for a report in SQL Server Analysis Services?

Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.

using connection strings in the report server than the datasource in 2005

  

Hi!

I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.

Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).

Any idea plz


Using connection string instead of datasource in report server 2005

  

Hi!

I am using a datasource in the report server where all the reports use that shared datasource while calling the reports from asp.net pages.

Now, as asp.net pages uses the connection string for the databases which is assigned in the web.config file, i want the reports also use the same connection string because you don't need to change on both places( web.config and report server datasource).

Any idea plz

i am working on VS2005 and ssrs 2005

 


Do not feel regret.... just try to improve..... its far better

problem in writing Element Path in Webservices has datsource for SSRS report

  

Hi,

I have a requirement to create a webservice which returns dataset, once dataset is consumed by client application(here client app is SSRS report), I need to show dataset 's table value in SSRS rdl report.

When i see XML structure returned to client look like this

<?xml version="1.0" encoding="utf-8" ?>
<DataSet xmlns="http://tempuri.org/">
 <xs:schema id="Results" xmlns=""  
xmlns:xs="http://www.w3.org/2001/XMLSchema"  
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"  
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
  <xs:element name="Results" msdata:IsDataSet="true"  
msdata:UseCurrentLocale="true" msprop:QueryTerms="Cool Bikes;"  
msprop:IgnoredNoiseWords="" msprop:Keyword="" msprop:ElapsedTime="938"  
msprop:Definition="" msprop:SpellingSuggestion="">
   <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
     <xs:element name="RelevantResults"
msprop:IsTotalRowsExact="False">       

Report Designing Practices ?

  

Hi ,

Best practices  to embed  a Table/Chart in a list  so as to fit exactly into the list ?

Thanks in Advance .


Rajkumar Yelugu

Report Builder 3.0 Can NOT see 2005 built reports, report models or datasource

  

We have 2005 bids but have installed 3.0,  thought I would be able to use datasources and report models and retrieve RDL for review or changes.  Is this possible?  I sort of understand that If I want to republish these reports it would have to be on an 2008 installed instance of visial studio.

How far off am I and can any help or point me in the right direction,

Thanks in advance,

Terry


webservices as datasource

  

It is possible to make webservice as datasource? How?


an instance of a class used for Report viewer datasource

  

Hi all.

I have a class that inherited from object type and has some string properties, also I have a report(.rdcl) that use the fields of that class.

I add a webpage in my project, then I drag a reportviewer component into it. then I set the report to my existing report mentioned before using choose report (small arrow). in my page load code behind, I create an instance of that class and now, I don't have any idea how to bind that data. can anyone help me out please?

thanks


Hide a repeater in ASP.NET C# if the DataSource contains no items?

  
I have an ASP.NET page that uses a repeater nested within another repeater to generate a listing of data. It's to the effect of the following:
In the (C#) code-behind I'm basically using LINQ to pull a listing of information from an XML document and bind that information to the first repeater.

Searching for the answer to this, it seems the method is to determine whether the data for the nested repeater is empty. If it is, then you set the visibility of the repeater to false.

Manually sorting and paging Gridview without using datasource control

  
Many a times while working with Gridview we want to work with the paging and sorting functionality without using any datasource control. Gridview is flexible enough to perform these tasks without the use of any datasource control and only a few lines of code.

Alternating row background for first column of a report

  

is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

<TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="PartNumber">
                      <rd:DefaultName>PartNumber</rd:DefaultName>
 

Dynamic Data, Domain datasource, Poco and lookups

  

Mr. Edward,

Excuse my question but: it is necessary to involve in our projects something more than just Dynamic Data or should we make use of all other features available in VS2010 (which will make assume taht they had been left out of the Dynamic Data framework) like: wef, poco, azure, wcf, cloud, mvc, silverllight, ajax, odata, agile, workflow, etc.?

Sorry my ignorance, I'm just transcribing names as they come to my mind and of which I don't know anything about

 

Carlos Porras (El Salvador)


How to write SQL Datasource programatically in VB

  

Can someone pls help me to rewrite this programatically!

 

<asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                SelectCommand="SELECT * FROM [Products] WHERE ([ProductID] = @QSID)">
                <SelectParameters>
                    <asp:QueryStringParameter DefaultValue="" Name="QSID" QueryStringField="ID"
                        Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>

 

Thank You in advance!

 


Configure Datasource using gridview problem

  

Hi i  have one asp.net textbox control..

and one dropdownlist inside gridview itemtemplate textbox..

what my problem..?

A Textbox36 has values some thing like this A1','A2','A3

i wirte this below query in sqldatasource1 and this sqldarasource1 is binded to gridview ItemTemplate Dropdownlist..

Select ItemName from Table1 where code in (@C)

Here @C im refering to Textbox36..

It show me the record if it has one value if its multiple like A1','A2','A3 it not showing/filtering ItemName data..

Whatz the probel?


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