ElementPath during webservices has datasource in report designing.

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
  

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

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

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

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

Hi ,

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

Thanks in Advance .

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

It is possible to make webservice as datasource? How?

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

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>
 

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)

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!

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?