none
Dataset, Table and DataSource Names in VS 2010 Local Reporting RRS feed

  • Question

  • Hello,

    My problem is that i cant values to show in my report. It seems i dont understand where to put what name of what table, Dataset or Source.

    I have a an dataset defined by an XSD that is added to the project looking like this:
    ...

    <xs:element name="Dataset_CR" msdata:IsDataSet="true" msdata:Locale="en-US">

        <xs:complexType>

            <xs:choice minOccurs="0" maxOccurs="unbounded">

                 <xs:element name="Angebote">
    ...

     

    The application is called Ikarus the data set "Dataset_CR" and the table i want to read out is "Angebote".

    Now a XML snippet from the rdlc:

     

    <DataSources>

        <DataSource Name="IKARUS">

              <ConnectionProperties>

                    <DataProvider>System.Data.DataSet</DataProvider>

                    <ConnectString>/* Local Connection */</ConnectString>

              </ConnectionProperties>

              <rd:DataSourceID>569a2a27-a7ae-4579-aef4-2481af0b1ed6</rd:DataSourceID>

       </DataSource>

    </DataSources>

    <DataSets>

         <DataSet Name="Angebote">

                         <Fields>

    ...

     

             <rd:DataSetInfo>
                   <Query>
                           <DataSourceName>IKARUS</DataSourceName>
                          <CommandText>/* Local Query */</CommandText>
                   </Query>
              <rd:DataSetInfo>
                          <rd:DataSetName>Dataset_CR</rd:DataSetName>
                          <rd:TableName>Angebote</rd:TableName>
                          <rd:ObjectDataSourceSelectMethod>Angebote</rd:ObjectDataSourceSelectMethod>
                          <rd:ObjectDataSourceType>IKARUS.Dataset_CR, Berichte.Datasets.Dataset_CR.Designer.vb, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</rd:ObjectDataSourceType>
                 </rd:DataSetInfo>
                  </DataSet>
             </DataSets>

     

    When trying the wizard for dataset creation in the report data field i select as name the name of the table "Angebote" and in the "available datasets" field then "Dataset_CR (Angebote).

    In the form:

     

     Dim rds As New Microsoft.Reporting.WinForms.ReportDataSource("Angebote", Dset.Tables(0))

     rds.Name = "IKARUS"
    ReportViewer1.LocalReport.DataSources.Add(rds)

     

     

    Could some point me in the direction of what i am doing wrong. The dataset is definatly filled as i can generate a report with another method.

    Thanks for helping, in advance.

    Max

     

    EDIT: Sorry for formating problems

     

    • Edited by max_L Thursday, May 20, 2010 12:41 PM Formating
    Thursday, May 20, 2010 12:32 PM

All replies

  • If someone knows a good tutorial for using VS Reporting Services in local mode with a dataset not filled directly from a SQL Server, it would also help me and maybe even solve my problem.

    I looked arround but only found tutorials for situations that didn't fit me.

    Thx in advance

    Max

    Friday, May 21, 2010 8:36 AM
  • Try removing the following line, based on you RDLC it looks like rds.Name should be "Anegbote" which is the initial value that you set in the constructor.

     rds.Name = "IKARUS"

    Matt M.


    This posting is provided "AS IS" with no warranties, and confers no rights

     

    Friday, May 21, 2010 5:32 PM
  • Sorry that did not fix my problem.

    I have an dataset with the name Dataset_CR

    What name do i have to give the ReportDataSource object in my VB.Net Code?
    The name of Dataset Itself or the name of the table which i want to add specifically.

    When i use the report wizzard what do i have to put into the three availble fields corresponding to the information i used in the vb.net code?

    One complete example woudl really help me.

    Thursday, May 27, 2010 12:04 PM