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."); } }
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."); } }