Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Group Footer not printing the calculated values correctly(Group Footer)
Group Footer not printing the calculated values correctly [message #1702523] Wed, 22 July 2015 22:01
KRISHNAKUMAR CHINNASAMY is currently offline KRISHNAKUMAR CHINNASAMYFriend
Messages: 1
Registered: July 2015
Junior Member
Hi Gurus,
This is my first post in Eclipse Community Forum. I apologize if i put this topic in wrong place.

I have created a below calculations on Detail row onCreate.
estLabHrs = this.getRowData().getColumnValue("ESTLABHRS");
actLabhrs = this.getRowData().getColumnValue("ESTLABHRS");

if ((BirtComp.equalTo(this.getRowData().getColumnValue("PMNUM"),null)) || (BirtComp.equalTo(this.getRowData().getColumnValue("PMNUM"),"")))
{
	prmGrpWOCnt += 1;
	DateToCompare = this.getRowData().getColumnValue("WOREPORTDATE");

	tempA0 = this.getRowData().getColumnValue("ACTLABHRS").split(":");
	minutes = 60 * parseInt(tempA0[0]) + parseInt(tempA0[1]);
	prmGrpActHrsWO = prmGrpActHrsWO+minutes/60;


	temp0 = this.getRowData().getColumnValue("ESTLABHRS").split(":");
	minutes = 60 * parseInt(temp0[0]) + parseInt(temp0[1]);
	prmGrpEstHrsWO = prmGrpEstHrsWO+minutes/60;
	
	prmGrandEstHrsWO =this.getRowData().getColumnValue("ESTLABHRS") ;


}

else
{
		if (BirtComp.lessThan(this.getRowData().getColumnValue("PMTARGETDATE"),today))
		{
			prmGrpPMCntOD += 1
						
			tempA1 = this.getRowData().getColumnValue("ACTLABHRS").split(":");
			minutes = 60 * parseInt(tempA1[0]) + parseInt(tempA1[1]);
			prmGrpActHrsPMOD = prmGrpActHrsPMOD+minutes/60;

			temp1 = this.getRowData().getColumnValue("ESTLABHRS").split(":");
			minutes = 60 * parseInt(temp1[0]) + parseInt(temp1[1]);
			prmGrpEstHrsPMOD = prmGrpEstHrsPMOD+minutes/60;

			
		}
		else
		{
			prmGrpPMCntFuture += 1
			
			tempA2 = this.getRowData().getColumnValue("ACTLABHRS").split(":");
			minutes = 60 * parseInt(tempA2[0]) + parseInt(tempA2[1]);
			prmGrpActHrsPMFuture = prmGrpActHrsPMFuture+minutes/60;

			temp2 = this.getRowData().getColumnValue("ESTLABHRS").split(":");
			minutes = 60 * parseInt(temp2[0]) + parseInt(temp2[1]);
			prmGrpEstHrsPMFuture = prmGrpEstHrsPMFuture+minutes/60;

		
		}
		DateToCompare = this.getRowData().getColumnValue("PMTARGETDATE");
		
		if ((BirtComp.equalTo(this.getRowData().getColumnValue("TARGCOMPDATE"),null)) || (BirtComp.equalTo(this.getRowData().getColumnValue("TARGCOMPDATE"),"")))
		{
			prmGrpPMMissTar += 1;
			
			prmPMMissTarFlag = 1;
		}
}
if (BirtComp.equalTo(this.getRowData().getColumnValue("ESTLABHRS"),0))
{
	prmGrpMissEst +=  1;
	
	prmMissEstFlag = 1;
}
if(BirtComp.greaterThan(this.getRowData().getColumnValue("ACTLABHRS"),this.getRowData().getColumnValue("ESTLABHRS")))
{
	prmGrpActGrtEst += 1;
	
	prmActGrtEstFlag = 1;
}


if (BirtDateTime.diffDay(DateToCompare,today)< 30)
{
	if (BirtDateTime.diffDay(DateToCompare,today)<= 0)
	{
			
		prmGrpAgeEarlyGen += 1  
	}
	else 
	{
		prmGrpAge0to1Months += 1   
	}
}

if(BirtComp.between(BirtDateTime.diffDay(DateToCompare,today),30,59))
{
	prmGrpAge1to2Months	+= 1      
}

if(BirtComp.between(BirtDateTime.diffDay(DateToCompare,today),60,179))
{
	prmGrpAge2to6Months  += 1
}

if (BirtDateTime.diffDay(DateToCompare,today)>= 180)
{
	prmGrpAgeAbove6Months += 1 	
}

The calculations are correct. When i print the variables (prmGrpAge0to1Months ,prmGrpAge1to2Months .. etc) in group footer, some how it is detecting by 1 for example if total value of the variable prmGrpAge0to1Months is 5 after the loop it is printing 4. When i Print in oncreate method it says 5 but it shows 4 all the time. there is no other calculation made in data element. it is simply printing. Some one please help me to figure out what i am doing wrong..


Thanks
Krishna
  • Attachment: wotrack.zip
    (Size: 40.84KB, Downloaded 110 times)
Previous Topic:Report works fine in RCP but loaded into application errors out. MySQL 5.5 and BIRT 3.7.1
Next Topic:Does BIRT integrate with Windows AD?
Goto Forum:
  


Current Time: Thu Apr 25 12:55:07 GMT 2024

Powered by FUDForum. Page generated in 0.03280 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top