Monday 2 January 2012

crystal report create in c# with coding

taken one dataset  after drag and drop datatable on dataset.
add crystal reportViewer on webform or windows form

then according to requirement taken data from sql server or my sql or orcle then 
coding file............

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace PIS_Billing.Packing.PackingList_Report
{
    public partial class reporton : Form
    {
        public reporton()
        {
            InitializeComponent();
        }
        string PackingId;
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["PIS_Billing_Connection"].ToString());
        public string _textBox
        {
            set { label1.Text = value;
            PackingId = value;
            }
        }
        private void reporton_Load(object sender, EventArgs e)
        {
            try
            {
                DataSet ds = new DataSet();
                DataTable dt1 = MyPackingList().Copy();
                DataTable dt2 = SpPackingList().Copy();

                DataTable dt3 = Summary_Vw().Copy();


                ds.Tables.Add(dt1);
                ds.Tables.Add(dt2);
                ds.Tables.Add(dt3);


                ReportDocument myreport = new ReportDocument();
                myreport.Load("D:\\PIS_Billing\\PIS_Billing\\PIS_Billing\\Packing\\PackingList_Report\\packingListReport.rpt");


                myreport.SetDataSource(ds);

                crystalReportViewer1.ReportSource = myreport;



            }
            catch (Exception)
            {

                //throw;
            }

           
        }
        protected DataTable MyPackingList()
        {
            string Query = "SELECT * FROM dbo.PackingList WHERE PackingId='" + PackingId + "' ";
            SqlDataAdapter da = new SqlDataAdapter(Query, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "PackingList");
            DataTable Pack = ds.Tables[0];
            return Pack;
        }
        protected DataTable SpPackingList()
        {
            string Query = "SELECT DISTINCT SpId,Specification FROM dbo.PackingList WHERE PackingId='" + PackingId + "'";
            SqlDataAdapter da = new SqlDataAdapter(Query, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "SpecificationInfo");
            DataTable SpecificationInfo = ds.Tables[0];
            return SpecificationInfo;
        }
        private DataTable Summary_Vw()
        {
            string Query = "SELECT * FROM pack_Summary_Vw WHERE PackingId='" + PackingId + "'";
            SqlDataAdapter da = new SqlDataAdapter(Query, con);
            DataSet ds = new DataSet();
            da.Fill(ds, "Pack_Summary_VW");
            DataTable Summary_Vw = ds.Tables[0];
            return Summary_Vw;
        }
       
    }
}



No comments:

Post a Comment