protected void btnPrintAll_Click(object sender, EventArgs e)
        {
            try
            {
                if (ddlMarket.SelectedIndex == -1)
                {
                    Alert.Show("Please select a market first.");
                    ddlMarket.Focus();
                    return;
                }

                int marketId = int.Parse(ddlMarket.SelectedValue);

                DataSet ds = new DataSet();

                DataTable dtBillDetail = new BillMaster().GetBillMasterDetailForReport(marketId);
                ds.Tables.Add(dtBillDetail);

                DataTable dtCompany = new Company().GetCompanyDatatableById(1);
                ds.Tables.Add(dtCompany);

                Session["ReportDataset"] = ds;

                string myScript = "window.open('CrystalReportViewer.aspx?report=crptBillCopy.rpt');";
                //string myScript = "window.open('ReportView.aspx?report=Report1.rdlc');";
                Page.ClientScript.RegisterStartupScript(Page.GetType(), "OpenPopup", myScript, true);

            }
            catch (Exception ex)
            {
                Alert.Show("Error during leave grid event. Error: " + ex.Message);
            }
        }
        protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            try
            {

                if (e.CommandName == "btnPrint")
                {
                    GridDataItem item = (GridDataItem) e.Item;
                    int id = int.Parse(item["colId"].Text);

                    if (id != 0)
                    {
                        DataSet ds = new DataSet();

                        DataTable dtBillDetail = new BillMaster().GetBillMasterDetailForSingleReport(id);
                        ds.Tables.Add(dtBillDetail);

                        DataTable dtCompany = new Company().GetCompanyDatatableById(1);
                        ds.Tables.Add(dtCompany);

                        Session["ReportDataset"] = ds;

                        //string myScript = "window.open('reportview.aspx?report=rptBillCopy.rdlc');";
                        string myScript = "window.open('CrystalReportViewer.aspx?report=crptBillCopyWithoutCaption.rpt');";

                        Page.ClientScript.RegisterStartupScript(Page.GetType(), "OpenPopup", myScript, true);
                    }

                }
            }
            catch (Exception ex)
            {
                Alert.Show("Error during leave grid event. Error: " + ex.Message);
            }
        }