ReportViewer in local mode not displaying data from table in chart RSS

• • Reply
  

  bonna guitar

  Member

  50 Points

  29 Posts

  ReportViewer in local mode not displaying data from table in chart

  Aug 27, 2012 11:39 PM|LINK

  I am adding a table as the datsource to a ReportViewer displaying a chart and running in localmode, but the chart is empty. 

  The table definitely contains populated data rows.  The code is:

   string connStr =  "server=localhost;Trusted_Connection=true;database=MDX_Extract";

  SqlConnection conn = new SqlConnection(connStr);

  DataSet ds = new DataSet();

  using (SqlConnection conn = OpenSqlConnection())

  {

  SqlDataAdapter da = new SqlDataAdapter(sSQL, conn);

  da.Fill(ds);

         da.Dispose();

  }

   ReportViewer rV = FindReportViewer(activeReport);

  ReportDataSource rds = new ReportDataSource("DataSet1", ds.Tables[0]);

  ReportViewer1.LocalReport.DataSources.Clear();

  ReportViewer1.LocalReport.DataSources.Add(rds);

  ReportViewer1.LocalReport.Refresh();

   Any ideas what's happening?

• • Reply
  

  CatchBugs

  Member

  638 Points

  75 Posts

  Re: ReportViewer in local mode not displaying data from table in chart

  Aug 27, 2012 11:42 PM|LINK

  You can use something like that 

  <asp:SqlDataSource
                  id="SqlDataSource1"
                  runat="server"
                  ConnectionString="<%$ ConnectionStrings:MyNorthwind%>"
                  SelectCommand="SELECT AYFS.CaseNumber, Clients2.firstName, Clients2.lastName, AYFS.DFC, AYFS.DFCPhone, AYFS.Recvd, AYFS.Expires, AYFS.DateClosed, AYFS.Closed, AYFS.Outcome FROM AYFS INNER JOIN Clients2 ON AYFS.ClientId = Clients2.clientID"
                  FilterExpression="CaseNumber='{0}'">
                  <FilterParameters>
                      <asp:ControlParameter Name="CaseNumber" ControlId="txtcaseno" PropertyName="Text"/>
                  </FilterParameters>
              </asp:SqlDataSource>

   

  useful links must visit too

  • http://msdn.microsoft.com/en-us/library/ms252123(v=vs.80).aspx
  • http://www.codeproject.com/Articles/15597/Using-the-ASP-NET-2-0-ReportViewer-in-Local-Mode
  • http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/77b279e6-efbe-43bd-9fa0-f00210221503/
  • Marked as answer by bonna guitar on Aug 27, 2012 11:47 PM