title: RDLC Design, A column of Row number showing extra value
body: <p>My rdlc report is working fine. but displaying 0 that i need to remove. please help. attached screenshot describe the design problem.<a href="https://i.stack.imgur.com/eqVQF.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>C# code</p>
  <pre><code>protected void GenerateReport()
  {
      if (Request.QueryString[&quot;rdlcrepname&quot;] != null)
      {
          reportName = Request.QueryString[&quot;rdlcrepname&quot;].ToString();
          string strprm1 = Request.QueryString[&quot;prm1&quot;].ToString();
          var strprm2 = Request.QueryString[&quot;param2&quot;] != null ? Convert.ToInt32(Request.QueryString[&quot;param1&quot;].ToString()) : 0 ;
          SqlParameter[] clsParam = new SqlParameter[2];
          clsParam[0] = new SqlParameter(&quot;@param1&quot;, strprm1);
          clsParam[1] = new SqlParameter(&quot;@param2&quot;, strprm2);
          ds = dataAccess.GetDataSet(&quot;spname&quot;, clsParam);
          dsShow.Tables.Add();
          dsShow.Tables.Add(&quot;FinalDisplayDataHeader&quot;);
          dsShow.Tables.Add(&quot;FinalDisplayData&quot;);
          //DataColumns-Header SQL of Header
          dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Columns.Add(&quot;col1&quot;, typeof(string));
          dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Columns.Add(&quot;col2&quot;, typeof(string));
          dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Columns.Add(&quot;col3&quot;, typeof(string));
          dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Columns.Add(&quot;col4&quot;, typeof(string));
          //DataColumns SQL of data
          dsShow.Tables[&quot;FinalDisplayData&quot;].Columns.Add(&quot;col1&quot;, typeof(string));
          dsShow.Tables[&quot;FinalDisplayData&quot;].Columns.Add(&quot;col2&quot;, typeof(string));
          dsShow.Tables[&quot;FinalDisplayData&quot;].Columns.Add(&quot;col3&quot;, typeof(string));
  
          if (ds.Tables[&quot;Table&quot;].Rows.Count &gt; 0)
          {
              for (int i = 0; i &lt; ds.Tables[&quot;Table&quot;].Rows.Count; i++)
              {
                  dsQPUDisplay.Tables[&quot;FinalDisplayDataHeader&quot;].Rows.Add(); //Header
                  dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Rows[i][&quot;col1&quot;] = ds.Tables[&quot;Table&quot;].Rows[i][&quot;col1&quot;].ToString();
                  dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Rows[i][&quot;col2&quot;] = ds.Tables[&quot;Table&quot;].Rows[i][&quot;col2&quot;].ToString();
                  dsShow.Tables[&quot;FinalDisplayDataHeader&quot;].Rows[i][&quot;col3&quot;] = ds.Tables[&quot;Table&quot;].Rows[i][&quot;col3&quot;].ToString();
                  dsQPUDisplay.Tables[&quot;FinalDisplayDataHeader&quot;].Rows[i][&quot;col4&quot;] = ds.Tables[&quot;Table&quot;].Rows[i][&quot;col4&quot;].ToString();
                  for (int k = 0; k &lt; 4; k++)
                  { 
                      dsShow.Tables[&quot;FinalDisplayData&quot;].Rows.Add(); //Data
                      dsShow.Tables[&quot;FinalDisplayData&quot;].Rows[k][&quot;col1&quot;] = ds.Tables[&quot;Table1&quot;].Rows[k][&quot;col1&quot;].ToString();
                      dsShow.Tables[&quot;FinalDisplayData&quot;].Rows[k][&quot;col2&quot;] = ds.Tables[&quot;Table1&quot;].Rows[k][&quot;col2&quot;].ToString();//This is right
                      dsShow.Tables[&quot;FinalDisplayData&quot;].Rows[k][&quot;col3&quot;] = ds.Tables[&quot;Table1&quot;].Rows[k][&quot;col3&quot;].ToString();
                  }
              }
                  reportPath = string.Empty;
                  rdlcReportViewer.LocalReport.ReportPath = GetReportPath(reportName);
                  //rdlcReportViewer.LocalReport.DataSources.Clear();
                  ReportDataSource rdsHeader = new ReportDataSource(&quot;DataHeader&quot;, dsShow.Tables[&quot;FinalDisplayDataHeader&quot;]);
                  ReportDataSource rdsData = new ReportDataSource(&quot;Data&quot;, dsShow.Tables[&quot;FinalDisplayData&quot;]);
                  rdlcReportViewer.LocalReport.DataSources.Add(rdsQPUheader);
                  rdlcReportViewer.LocalReport.DataSources.Add(rdsQPUData);
          }// for complete batch students loop closed
          rdlcReportViewer.DataBind();
          rdlcReportViewer.LocalReport.Refresh();
      }
  }
  </code></pre>
  <p>RDLC is in design. code above give you idea how i am generating the rdlc report. <a href="https://i.stack.imgur.com/7Y3wS.png" rel="nofollow noreferrer">enter image description here</a> this link describe issue of <strong>RowNumber</strong> display</p>