udaysriturangi

Members

Community Answers

udaysriturangi's post in How to use lag functions in jasper was marked as the answer   April 3, 2017

Hi imran,

In query, i am using lag function, so that i am able to get last row last column data in second row, But it is not allowing me to do calculation saying nested window functions are not allowed,It is just simply printing previous row value.

my table data:

January     0      55019.17      221    242      0   54556.17
February     54556.17         32139.07      20      5967115.32   0   -5934996.25
March        -5934996.25   18026.1          493   0                      380   17153.1
April       17153.1            0   6           0   0   -6

Thanks ,

Udaya.
udaysriturangi's post in How to give condition to subreport was marked as the answer October 19, 2016

Hi ,
Actually i found the solutionhttp://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/tounge_smile.gif !! For subreport1 jst edit the condition as $P{columns}.contains("A") && !$P{columns}.contains("B").. It is working fine for me. Tq!!