hello

Saturday, 23 July 2011

PRINTIG WITH ERDLC

CREATE RDLC REPORT FIRST USING DATASET
.ASPX
<center>
     <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
         Font-Size="8pt" Height="400px" Width="825px">
         <LocalReport ReportPath="PrintRequestion.rdlc">
             <DataSources>
                 <rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
                     Name="RequestionPrint_printrequestion" />
             </DataSources>
         </LocalReport>
     </rsweb:ReportViewer>
     <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
         SelectMethod="GetData"
         TypeName="RequestionPrintTableAdapters.printrequestionTableAdapter">
     </asp:ObjectDataSource>
 </center>
.CS
 public void princhallan()
    {
        try
        {
            string namep = objcom.porjectname();
            string firmname = objcom.firmname();
            string aa = "select  ITEMNAME,Qty,UNITNAME from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
            DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, aa);

            string date = "A";
            string ddate = "a";
            string narration = "a";
            string worktime = "a";
            string Name = "a";

            string aa2 = "select * from printrequestion where Mvoucher=" + Request.QueryString["id"].ToString() + "";
            SqlDataReader rd = SqlHelper.ExecuteReader(con, CommandType.Text, aa2);
            if (rd.Read())
            {
                date = rd["Date"].ToString();
                date = Convert.ToDateTime(date).ToString("dd/MM/yyyy");

                ddate = rd["DelDate"].ToString();
                ddate = Convert.ToDateTime(ddate).ToString("dd/MM/yyyy");

                narration = rd["Remarks"].ToString();
                worktime = rd["Worktime"].ToString();
                Name = rd["Name"].ToString();

                rd.Close();
            }


            ReportParameter[] param = new ReportParameter[9];
            param[0] = new ReportParameter("Report_Parameter_0", firmname);
            param[1] = new ReportParameter("Report_Parameter_1", System.DateTime.Now.ToString("dd/MM/yyyy"));
            param[2] = new ReportParameter("Report_Parameter_2", namep);
            param[3] = new ReportParameter("Report_Parameter_3", Request.QueryString["id"].ToString());
            param[4] = new ReportParameter("Report_Parameter_4", date);
            param[5] = new ReportParameter("Report_Parameter_5", ddate);
            param[6] = new ReportParameter("Report_Parameter_6", narration);
            param[7] = new ReportParameter("Report_Parameter_7", worktime);
            param[8] = new ReportParameter("Report_Parameter_8", Name);

            ReportViewer1.LocalReport.SetParameters(param);
            ReportViewer1.LocalReport.DataSources.Clear();
            ReportDataSource reportDSHeader = new ReportDataSource("RequestionPrint_printrequestion", ds.Tables[0]);
            ReportViewer1.LocalReport.DataSources.Add(reportDSHeader);

            ReportViewer1.LocalReport.Refresh();

        }
        catch (Exception ex)
        {
            MessageBox(this, "Try Again");
        }
        finally { }
    }

No comments:

Post a Comment