michaela.camson
-
Posts
8 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by michaela.camson
-
-
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
Adding a day from the programmed date in a report
in Products
Posted
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