No data in my rdlc from DataSet

Question

I have a rdlc file that I am trying to populate on runtime.  I created my DataSet in my Data Source and when I run the application I am trying to load some dummy data to just get it started.  The dummy data never appears.  Can someone tell me what is wrong with the code.

//Build DataSet
DataSet1.DataTable1DataTable dt = new DataSet1.DataTable1DataTable ();
DataRow row = dt.NewDataTable1Row ();
row["split"] = 70;
row["split_name"] = "row A";
row["acdcalls"] = 1234;
         
dt.Rows.Add (row);
         
DataSet1 ds1 = new DataSet1 ();
ds1.Tables.Add (dt);
         

//Set report viewer to show report
ReportViewer.LocalReport.ReportPath = "Skill_combined.rdlc";
         ReportViewer.LocalReport.DataSources.Add (new ReportDataSource
          ("DataSet1_DataTable1", ds1.Tables[0]));
ReportViewer.RefreshReport ();

Thanks Very Much

Answer 1

Hi.
What is the error (if any) that you are getting?

Have you checked to make sure that the dataset name in the RDLC matches "DataSet1_DataTable1"?

Thanks.

Stella Chan
SQL Server Reporting Services

Answer 2

Stella

As far as errors I don't receive any, just never see the data that I manually entered in the code above.

I did verify the DataSet name.   I have pasted a section of my rdlc file below.

<DataSets>

    <DataSet Name="DataSet1_DataTable1">

      <Fields>

        <Field Name="split">

          <DataField>split</DataField>

          <rd:TypeName>System.String</rd:TypeName>

        </Field>

        <Field Name="split_name">

          <DataField>split_name</DataField>

          <rd:TypeName>System.String</rd:TypeName>

        </Field>

        <Field Name="acdcalls">

          <DataField>acdcalls</DataField>

          <rd:TypeName>System.String</rd:TypeName>

        </Field>

      </Fields>

      <Query>

        <DataSourceName>DummyDataSource</DataSourceName>

        <CommandText />

        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>

      </Query>

      <rd:DataSetInfo>

        <rd:DataSetName>DataSet1</rd:DataSetName>

        <rd:TableName>DataTable1</rd:TableName>

      </rd:DataSetInfo>

    </DataSet>

  </DataSets>

Answer 3

I have resolved the issue.  I changed my code to following.

//Build DataSet
         DataSet1 ds1 = new DataSet1 ();                  
         DataRow row = ds1.DataTable1.NewRow ();
         row["split"] = 70;
         row["split_name"] = "row A";
         row["acdcalls"] = 1234;         

         DataRow row2 = ds1.DataTable1.NewRow ();
         row2["split"] = 71;
         row2["split_name"] = "Row B";
         row2["acdcalls"] = 4567;
         
         ds1.DataTable1.Rows.Add (row);
         ds1.DataTable1.Rows.Add (row2);
         
         //Set report viewer to show report
         ReportViewer.LocalReport.ReportPath = "Skill_combined.rdlc";
         ReportViewer.LocalReport.DataSources.Add (new ReportDataSource
          ("DataSet1_DataTable1", ds1.DataTable1));
         ReportViewer.RefreshReport ();

It works now... WHOO HOO!