Sai Ram

Sai Ram

  • NA
  • 237
  • 116.6k

CrystalReports

Sep 20 2011 10:31 AM

  In Crystal Reports, if i create, Report from VS 2008 Report Template using SQL Command.(All Data will display when we preview Crystal Report in Designing)...While Calling from Windows Form is it required to use Dataset again to Report Document to display Crystal Report....

I am giving my Code below:-

 private void btnGenerate_Click(object sender, EventArgs e)
  {
  try
  {
    string repquery = "SELECT Building_No,Building_Name FROM Buildings order by Building_No ";
  SqlDataAdapter da1 = new SqlDataAdapter(repquery, con);
  DataSet ds = new DataSet();
  da1.Fill(ds, "Buildings");

  DataTable dt = new DataTable();
  dt = ds.Tables["Buildings"];
  if (dt.Rows.Count != 0)
  {
  label7.Text = "Report is loading...";
  ReportDocument rpt = new ReportDocument();
 
  rpt.Load("\\Reports\\Buildings.rpt.rpt");
  string comp = rpt.GetComponentName();

  rpt.SetDataSource(dt);
  SummaryInfo sinfo = rpt.SummaryInfo;
  sinfo.ReportTitle = "Buildings ";
  Form frm1 = new Form();
  label7.Text = "";
  frm1.SetDesktopBounds(0, 0, 1024, 768);
  CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
  crystalReportViewer1.ReportSource = rpt;
  crystalReportViewer1.Dock = DockStyle.Fill;
  crystalReportViewer1.Refresh();
  frm1.Controls.Add(crystalReportViewer1);
  frm1.MaximumSize = new System.Drawing.Size(1600, 1000);
  frm1.TopMost = true;
  frm1.Show();

  //frm1.WindowState=
  frm1.Text = "Buildings.";
  }
  else
  MessageBox.Show("Records Are Empty!", "Alarm Reports Message");
  }
  catch (FormatException ex)
  {
  //MessageBox.Show(ex.Message, "Alarm Reports Message");
 }
}


Answers (1)