Friday 30 December 2011

Crystal report use multipal table and SubCrystal report

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());
        //----tanking value main form to report form
        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