<p>[color=rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;]I am using eclipse Birt for reporting an application which is built is apache ofbiz. I want to report some information in a table format and want to get the output in a pdf format,that is my purpose.I am posting the class which is getting the data from the source ..[/color]</p><p> </p><p> </p><p>[font="Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;"]public static void getReport(HttpServletRequest request, HttpServletResponse response){[/font]</p><p>Delegator delegator = (Delegator) request.getAttribute("delegator");<br />
String reportType = request.getParameter("reportType");<br />
String compId = request.getParameter("companyId");<br />
<br />
List empTaskLists = FastList.newInstance();<br />
<br />
//check employee position<br />
try {<br />
//use Company Id from global context<br />
List<GenericValue> partyList = EntityUtil.filterByDate(delegator.findByAnd("PartyRelationshipAndDetail", UtilMisc.toMap("partyIdFrom", compId)));<br />
//child<br />
for( GenericValue party : partyList) {<br />
GenericValue partyInfo=delegator.findByPrimaryKey("PartyAndPerson", UtilMisc.toMap("partyId", party.get("PartyId")) );<br />
String partyName = partyInfo.get("firstName") +" "+partyInfo.get("lastName");<br />
<br />
List<GenericValue> taskList = delegator.findList("WorkEffortAndPartyAssign", EntityCondition.makeCondition(UtilMisc.toMap("partyId", party.get("partyId"), "currentStatusId", "PTS_CREATED" , "statusId", "PAS_ASSIGNED")), null, null, null, false);<br />
<br />
for( GenericValue task : taskList) {<br />
<br />
Map taskMap = FastMap.newInstance();<br />
String taskName=task.getString("workEffortName");<br />
<br />
taskMap.put("empId", party.get("partyId"));<br />
taskMap.put("empName", partyName);<br />
taskMap.put("taskName", taskName);<br />
taskMap.put("start", task.get("estimatedStartDate"));<br />
taskMap.put("end", task.get("estimatedCompletionDate"));<br />
<br />
empTaskLists.add(taskMap);<br />
}<br />
<br />
<br />
}<br />
<br />
<br />
} catch (Exception e) {<br />
e.printStackTrace();<br />
}</p><p> </p><p> </p><p> </p><p>[color=rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;]This class is responsible for populating the data to the birt.And Under Birt i have a dataset which is getting empty.i am posting the open and fetch script[/color]</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">open script</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">var compId= "DemoScrumCompany";<br />
emptaskList = FastList.newInstance();<br />
<br />
partyList = delegator.findList("PartyRelationshipAndDetail", EntityCondition.makeCondition(UtilMisc.toList("partyIdFrom",compId)),null, null, null, false);<br />
<br />
//child<br />
for( party in partyList) {<br />
partyName = PartyHelper.getPartyName(party, true);<br />
var conds = FastList.newInstance();<br />
conds.add(EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, party.get("partyId")));<br />
conds.add(EntityCondition.makeCondition("currentStatusId", EntityOperator.EQUALS, "PTS_CREATED"));<br />
conds.add(EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "PAS_ASSIGNED"));<br />
<br />
taskList = delegator.findList("WorkEffortAndPartyAssign", EntityCondition.makeCondition(conds), null, null, null, false);<br />
for( task in taskList) {<br />
taskMap = FastMap.newInstance();<br />
taskName=task.get("workEffortName");<br />
//taskName="Task1";<br />
taskMap.put("empId", party.get("partyId"));<br />
taskMap.put("empName", partyName);<br />
taskMap.put("taskName", taskName);<br />
taskMap.put("start", task.get("estimatedStartDate"));<br />
taskMap.put("end", task.get("estimatedCompletionDate"));<br />
//taskMap.put("empId", "EMp01");<br />
//taskMap.put("empName", "EMP1");<br />
//taskMap.put("taskName", taskName);<br />
//taskMap.put("start", "2014-05-21");<br />
//taskMap.put("end", "2014-05-31");<br />
emptaskList.add(taskMap);<br />
}<br />
<br />
}<br />
totalRow = 0;<br />
countOfRow = 0;<br />
<br />
if (emptaskList.size()> 0 ) {<br />
totalRow = emptaskList.size();<br />
}</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">[font="Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"]fetch script[/font]</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">[font="Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;color:rgb(34,34,34);"]if (countOfRow >= totalRow) {[/font]</p>
<br />
<br />
<p>var emptaskMap =emptaskList.get(countOfRow);<br />
row["employeeId"] = emptaskMap.get("empId");<br />
row["employeeName"] = emptaskMap.get("empName");<br />
row["taskName"] =emptaskMap.get("taskName");<br />
row["startDate"] = emptaskMap.get("start");<br />
row["endDate"] = emptaskMap.get("end");<br />
countOfRow++;<br />
return true;<br />
}</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">[color=rgb(34,34,34);]return false;[/color] </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">these i have done to have the data .is it enough????.I also have a dataset which i have attached in the picture.I need the dataset to be populated with the data</p>
