michaela.camson

Hello everyone, How do i add a day from my programmed date. So if I have 2013/01/09 (2013/01/09 + 1 day ) how to do I make it 2013/01/10. Thanks for the help in advance, Michaela

Hi Rajesh, Thank you so much for the help I have figured out the solution... Thanks, Michaela

And then in Subtotal NetProceed1 = 40 690.00 This One is correct that value is the sum of the first group. Variable_1 = 704, 066.00 Variable_2 = 702,836.00 Group No = 34 the group number is counting the items and not the group... What do you think is the Problem? Thanks A lot for the help.. It is greatly appreciated Best regards, Michaela

Hi Rajesh, Thank you so much for responding. And thank you so much for the help.. Anyway this is the variable I made... <variable name="NetProceed1" class="java.lang.Long" resetType="Group" resetGroup="Loan Date" calculation="Sum"> <variableExpression><![CDATA[$F{Net Proceed}]]></variableExpression></variable><variable name="Variable_1" class="java.lang.Long" resetType="Group" resetGroup="Loan Date" calculation="Sum"><variableExpression><![CDATA[$V{NetProceed1}.intValue()]]></variableExpression><initialValueExpression><![CDATA[0.00]]></initialValueExpression></variable><variable name="GroupNo" class="java.lang.Integer" resetType="Group" resetGroup="Loan Date" calculation="Count"><variableExpression><![CDATA[$F{Loan Date}]]></variableExpression><initialValueExpression><![CDATA[0.00]]></initialValueExpression></variable><variable name="Variable_2" class="java.lang.Integer" resetType="Group" resetGroup="Loan Date" calculation="Sum"><variableExpression><![CDATA[iF(EQUALS($V{GroupNo},1),0,$V{NetProceed1}.intValue())]]></variableExpression></variable><group name="Loan Date"><groupExpression><![CDATA[$F{Loan Date}]]></groupExpression></group></subDataset><queryString language="SQL">

Hi thank you so much for the answer. But it didn't work for me i added 3 variable the Group No, TotalAdd , and the Variable 1. I followed your steps but then the answer came out to be the whole total of the sum of principal and it didn't starts with zero. What Do you think the problem is? Thanks for the help, Any help is greatly appreciated. Michaela

Hi everyone; I've posted this question a week ago yet still unsolve. So i'm trying to post again hope to get more answers. My Problem is about how to set the variable first Group Total Column equals to 0. 0 should be fix it should be display as the first Group Total and the second Group Total will just be 0 + the sum of the 1st principal of the items. Sample: Items Principal a. 10 b. 2 Sub Total 0 c. 4 d. 6 Sub Total 12 e. 15 Sub Total 22 Please Help! ! ! Thank you for the help in advance Michaela

Thank you for the answer but then I can't find Initialization Type so I inputted it in the Increment yet it didn't solve the problem. I'm using jasper studio 5.5.1 Thank you so much for the answer.. Best Regards, Michaela

Hi, I'm New here. So I still don't know much. I have to do Running balance by group that starts with zero. So that first group footer should start with zero and second will be 0+total of first and the 3rd would be 0+total of First+total of second and then so on and so. Please please Help me Thanks, Michaela