xmlDocument.setParameter("cProjectPhase", strProjectphase);
xmlDocument.setParameter("cProjectStatus", strProjectstatus);
xmlDocument.setParameter("cProjectPublic", strProjectpublic);
xmlDocument.setParameter("salesRep", strSalesRep);
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "C_Project_kind",
"Projectkind", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportProjectBuildingSiteJR",
strProjectkind);
xmlDocument.setData("reportC_PROJECTKIND", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "C_Project_phase",
"Projectphase", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportProjectBuildingSiteJR",
strProjectphase);
xmlDocument.setData("reportC_PROJECTPHASE", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "C_Project_status",
"ProjectStatus", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportProjectBuildingSiteJR",
strProjectstatus);
xmlDocument.setData("reportC_PROJECTSTATUS", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "LIST",
"C_Project_publicprivate", "PublicPrivate", "", Utility.getContext(this, vars,
"#AccessibleOrgTree", "ReportProjectBuildingSiteJR"), Utility.getContext(this,
vars, "#User_Client", "ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportProjectBuildingSiteJR",
strProjectpublic);
xmlDocument.setData("reportC_PROJECTPUBLIC", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR",
"M_PRODUCT_CATEGORY_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
comboTableData.fillParameters(null, "ReportProjectBuildingSiteJR", "");
xmlDocument.setData("reportC_PRODUCTCATREGORY", "liststructure", comboTableData
.select(false));
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_Region_ID",
"", "C_Region of Country", Utility.getContext(this, vars, "#AccessibleOrgTree",
"Account"), Utility.getContext(this, vars, "#User_Client",
"ReportSalesOrderProvided"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportSalesOrderProvided",
strcRegionId);
xmlDocument.setData("reportC_REGIONID", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "",
"AD_User SalesRep", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportSalesOrderProvided",
strSalesRep);
xmlDocument.setData("reportSALESREP", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
xmlDocument.setParameter("ccurrencyid", strCurrencyId);
try {
ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_Currency_ID",
"", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
"ReportProjectBuildingSiteJR"), Utility.getContext(this, vars, "#User_Client",
"ReportProjectBuildingSiteJR"), 0);
Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportProjectBuildingSiteJR",
strCurrencyId);
xmlDocument.setData("reportC_Currency_ID", "liststructure", comboTableData.select(false));
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}