Jump to content
Changes to the Jaspersoft community edition download ×

Data fetch from the database in JRXML


pallavig026

Recommended Posts

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? 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...