Ejemplo n.º 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                Report rpt = new Report();
                ReportViewer rptViewer = ReportViewer1;
                Connections.Connections conn = new Connections.Connections();
                string commandText = "GetAssetSoftwares";
                bool r = rpt.ShowReport(rptViewer, "DataSet1", "Reports/Report Files/Report1.rdlc", commandText, 2, conn.MainConnection());

                if (r)
                {
                    rptViewer.Visible = true;
                    rptViewer.SizeToReportContent = true;
                    rptViewer.ZoomMode = ZoomMode.FullPage;
                }
                else
                {
                    rptViewer.Visible = false;
                    Response.Write("No records were found.");
                }

            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            //ReportParam[] reportParamsArray = new ReportParam[2]
            //{
            //  new ReportParam("divisionid",DropDownList1.SelectedValue),
            //  new ReportParam("employeeid",DropDownList2.SelectedValue),
            //};
            //Report rpt = new Report();

            //if (rpt.ShowReport(ReportViewer1, "DataSet1", "sp_getAssetsByEmployee", "Reports/Report Files/UserAssetsDivision.rdl", reportParamsArray))
            //{
            //    Label1.Visible = false;
            //}
            //else
            //{
            //    Label1.Text = "There were no records found for the search criteria you provided...";
            //    Label1.Visible = true;
            //}
            ReportParam[] reportParamsArray = new ReportParam[2]
            {
              new ReportParam("divisionid",DropDownList1.SelectedValue),
              new ReportParam("employeeid",DropDownList2.SelectedValue),
            };
            Report rpt = new Report();
            ReportViewer rptViewer = ReportViewer1;
            Connections.Connections conn = new Connections.Connections();
            string commandText = "sp_getAssetsByEmployee";
            bool r = rpt.ShowReport(rptViewer, "DataSet1", "Reports/Report Files/UserAssetsDivision.rdl", commandText, 2, conn.MainConnection(),reportParamsArray);

            if (r)
            {
                rptViewer.Visible = true;
                rptViewer.SizeToReportContent = true;
                rptViewer.ZoomMode = ZoomMode.FullPage;
            }
            else
            {
                rptViewer.Visible = false;
                Response.Write("No records were found.");
            }
        }