lmbaptista

How can I customize the charts? Things like changing colors remove or move the legend should be easy to do but I can't find a way to do it. And there are any reason to have column charts but not bar charts? Thanks in advance. Luís

Hi, all. My table have this look: Rows corresponding to each day. Columns corresponding to each hour. The cells have numeric values. I want to count all the cells that obey to an expression (bigger than 2, smaller than 4 and so on). I tried several approaches but all return errors. I can do this in excel using countif but I can't find a way to do this in JR Studio. Can anyone help me? Thanks in advance

Solved it. In the Text Filed Properties, I defined Tab Stop Width to 1px (it was 40, by default) and it worked. It is strange why that happen only with database fields with type "string" and does not happen with numbers or dates. Some JS buggy configuration. Anyway, it is fixed. Thanks.

Thanks for the effort. It was easier to upload the file than copy the code. However... I don't know what have you done but apparently you changed the field that was a database field to a text field and text fields I can aligne them. The problem only happens with database fields. And more, now i get an error exception: "java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Number" that I don't know where it is.

Yes, apparently looks fine. Correctly aligned at left.

Well... this file I shared is truncated from the original report to keep only the headers (where the problem is). I now realize that when I run it, it looks correctly aligned. However, if I keep the report with all information (variables, parameters,conditional styles) it lose the alignment and the result is like the image I attached initially. How can the code in the details band influence the code in the page header causing the loss of alignment? I share the full report with all information, maybe you can discover something I'm missing. Thanks in advance

The jrxml file is attached to the main question

ok. here you have it.

No. I'm not using any special element.

Thank you for the suggestion , Sad H, but it's not useful. I can't change the database fields because they are populated by dropdownlists in an aplication. Then, adding spaces doesn't solve the problem because the left alignment does not fix with spaces (at left or right). This is some kind of problem with Studio and I can't find it or solve it.

Hello. I'm using Jasper Studio 6.12.2 and all libraries are 6.12.2 as you can see in the image attached. However, in the preview I can't align the texts, in this case at left. What can be wrong? This happens with fields that are being retrieved from a field in the database and the datatype is text. If the datatype is somehow numeric (integer, double, float), it align. If the datatype is date and a pattern is defined, it align. However, if it's a text field it aplies some kind of identation that I can't remove. Anyone with teh same problem who can help me, please? Thanks in advance Luís

Yes. If in the header I can have the GlobalTotal, later in the details, when I need to divide the DailyTotal for the GlobalTotal, that value already exists and hopefullyI solve the problem.

Thank you Sad H, but that was my first approach, but with Doubles since that is the type of my database fields. To do that I need to chanage the type of the fields in the database (to Float) and I don't want to do that. I think the problem is exactly in the order the variables are solved. I just don't know how can I make the GlobalTotal to be the first to be made. Tried to put it in the header but didn't worked.

Thank you for your suggestion, jgust, but unfortunately I couldn't get any results. I tried several options with evaluation time and reset type and none retrieve a good result. The percentage is always calculated on each line, based on the sum of the previous lines and not considering the GlobalTotal. Only the last line will show the correct result because is the only one where the GlobalTotal is the full sum of all values.

All variables are Double.