Jump to content
We've recently updated our Privacy Statement, available here ×

ll.rodrigo

Members
  • Posts

    7
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by ll.rodrigo

  1. Hi i have a chart where i want to show a label in this format "R$1.235,00" .At the chart i have a field  $F{soma} that is a BigDecimal. If i print just $F{soma} i'm getting something like: "1.235,00".And like  i said i need it like "R$1.235,00".

    I've tred  this:

    new java.text.DecimalFormat("R$ #,##0.00").format($F{soma})[/code]

                 But then i get this exception:

    java.lang.String cannot be cast to java.lang.Number[/code]

     

    How can i solve that, can anyone help?Thanks.

    MYsql database and the type of soma is in java class is Bigdecimal, and at the database it says decimal(19,2).

    I was told that printing just $F{soma} it shouldn't format the soma as "1.235,00". So i gues it have something to do with my database.

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

  3. Hi, i have some charts and reports, now i need to do a line chart that display  the sum of sales by each year and product. I send to report initial date and final date to do them.

    I already have the sum and the products.

    I want somethig like : 2013 - gloves, shorts, shirts,

                                           2014 - gloves, shorts, shirts.

    Any help would be great, thanks!

×
×
  • Create New...