Jump to content
Changes to the Jaspersoft community edition download ×

Chart iReport compare same fields in different dates.


ll.rodrigo

Recommended Posts

Hi, i have some charts and need to create one that is able to compare the same fields in different dates( months and years).

My  date_field is a string. For a chart that gives me all the expenses between two dates i use :

where  STR_TO_DATE(date_field,'%d-%m-%Y') BETWEEN $P{DATE_ONE} AND  $P{DATE_TWO}.

Now i need to show it in two or more categories, each one  will show values that belongs to a year.

Does someone have an idea or example, tutorials?

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...