private void ShowReport()
{
DSBD Ds = new DSBD();
DSBDTableAdapters.sp_Generator_MonthlyReport1TableAdapter da = new DSBDTableAdapters.sp_Generator_MonthlyReport1TableAdapter();
da.Fill(Ds.sp_Generator_MonthlyReport1, Convert.ToInt32(ddlGenerator.SelectedValue), Convert.ToInt32(ddlMonth.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue));
//int i = Ds.Tables["sp_Generator_MonthlyReport1"].Rows.Count;
//int j = 1;
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rd1 = new ReportDataSource("Generate", Ds.Tables["sp_Generator_MonthlyReport1"]);
ReportViewer1.LocalReport.DataSources.Add(rd1);
String path = Server.MapPath("GeneratorMonthlyServiceReport.rdlc");
ReportViewer1.LocalReport.ReportPath = path;
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("ReportParameter1", "Site: " + ddlLocation.SelectedItem.Text);
parameters[1] = new ReportParameter("ReportParameter2", "Report: " + ddlMonth.SelectedItem.Text + " " + ddlYear.SelectedItem.Text);
parameters[2] = new ReportParameter("ReportParameter3", "Generator: " + ddlGenerator.SelectedItem.Text);
ReportViewer1.LocalReport.SetParameters(parameters);
ReportViewer1.KeepSessionAlive = true;
ReportViewer1.LocalReport.Refresh();
}
private void ShowReport()
{
ReportViewer1.LocalReport.DataSources.Clear();
DSBD ds = new DSBD();
string reportPath = Server.MapPath("OrganizationDevelopmentStructure.rdlc");
DSBDTableAdapters.usp_OrganizationDevelopmentStructureTableAdapter da1 = new DSBDTableAdapters.usp_OrganizationDevelopmentStructureTableAdapter();
da1.Fill(ds.usp_OrganizationDevelopmentStructure, Convert.ToInt32(ddlDepartment.SelectedValue), Convert.ToInt32(ddlFunction.SelectedValue), Convert.ToInt32(ddlsFunction.SelectedValue), Convert.ToInt32(ddlActiviy.SelectedValue));
ReportViewer1.LocalReport.ReportPath = reportPath;
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables["usp_OrganizationDevelopmentStructure"]));
ReportViewer1.LocalReport.Refresh();
}
public static string GetEmpList(string vals)
{
string[] v = vals.Split('½');
DSBD Ds = new DSBD();
DSBDTableAdapters.EmployeeDataTableTableAdapter da = new DSBDTableAdapters.EmployeeDataTableTableAdapter();
da.Fill(Ds.EmployeeDataTable, v[0], v[1]);
// DataTable dt = Ds.Tables["EmployeeDataTable"];
JavaScriptSerializer serializer = new JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
Dictionary <string, object> row;
foreach (DataRow dr in Ds.Tables["EmployeeDataTable"].Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in Ds.Tables["EmployeeDataTable"].Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return(serializer.Serialize(rows));
}
private void ShowReport()
{
DSBD Ds = new DSBD();
DSBDTableAdapters.tblEmployeeTableAdapter da = new DSBDTableAdapters.tblEmployeeTableAdapter();
da.Fill(Ds.tblEmployee, ddlGenerator.SelectedValue, ddlLocation.SelectedValue);
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rd1 = new ReportDataSource("EmpRpt1", Ds.Tables["tblEmployee"]);
ReportViewer1.LocalReport.DataSources.Add(rd1);
String path = Server.MapPath("EmployeeReport.rdlc");
ReportViewer1.LocalReport.ReportPath = path;
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("ReportParameter1", "Site: " + ddlLocation.SelectedItem.Text);
parameters[1] = new ReportParameter("ReportParameter2", "Designation: " + ddlGenerator.SelectedItem.Text);
parameters[2] = new ReportParameter("ReportParameter3", "Generator: " + ddlGenerator.SelectedItem.Text);
ReportViewer1.LocalReport.SetParameters(parameters);
ReportViewer1.KeepSessionAlive = true;
ReportViewer1.LocalReport.Refresh();
}
