private void btnVerRelat_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; timer1.Enabled = true; rptEstoque rpt = new rptEstoque(); //The report you created. cmd = new SqlCommand(); SqlDataAdapter myDA = new SqlDataAdapter(); POS_DBDataSet myDS = new POS_DBDataSet(); //The DataSet you created. con = new SqlConnection(cs.DBConn); cmd.Connection = con; cmd.CommandText = "SELECT Product.ProductID,ProductName,Features,Price,Quantity,Price,Image from Temp_Stock,Product where Temp_Stock.ProductID=Product.ProductID and quantity > 0 order by ProductName"; cmd.CommandType = CommandType.Text; myDA.SelectCommand = cmd; myDA.Fill(myDS, "temp_Stock"); myDA.Fill(myDS, "product"); rpt.SetDataSource(myDS); frmEstoqueRelatorio frm = new frmEstoqueRelatorio(); frm.crystalReportViewer1.ReportSource = rpt; frm.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptEstoque rpt = new rptEstoque(); rpt.Site = this.Site; return(rpt); }