Data fetch from the database in JRXML

0

Hi,

I want to fetch the date from the database and then need to manipulate on that date to display the due date in the jasper report.

Table name is: ACCOUNTINGLOCATION

Column name: CURRENTACCOUNTINGDATE  (dd//mm//yyyy time)

currently im using below code

declared CURRENTACCOUNTINGDATE as a field,

and <queryString> <![CDATA[Select CurrentAccountingDate from AccountingLocation]]> </queryString>

and used <textFieldExpression><![CDATA[EDATE(DATE(YEAR($F{CURRENTACCOUNTINGDATE}), MONTH($F{CURRENTACCOUNTINGDATE}), 14), 1)]]></textFieldExpression>

But in my report i alredy have a <queryString>. So is there any other way i can fetch the date from databsae? 

pallavig026's picture
Joined: Oct 17 2018 - 12:16am
Last seen: 1 week 11 hours ago

0 Answers:

No answers yet
Feedback
randomness