lukas.habermayr

Hi all, I'm using a stacked column Chart in Jaspersoft Studio. Sometimes the value of a data label is 0 and thus it overlaps with the number above. Is there any possibility to show the data label only when it's greater 0? Something like "plotOptions.dataLabels.yAxis.valueY>0"? Any suggestions? Regards

Hi all, I'd like to reset a created variable after every calendarwek. Right now the variable counts a specific character in the column of the db. When I extend the time range to more than one calendarweek, the variable just sums up all characters for this range. (so the bars of the bar chart grow for every week) In order to compare the weeks correctly, I need the actual value of the character for every week. Any suggestions how to achive this?

It's an specific db environment from a company. The sql language used is SQL-92. Any other solutions (e.g. using parameters) are ok with me. Thanks

Hi all, I'm trying to substract n days from the current date. I'd like to use this in my query to filter results older than NOW()-n days. The column in the database is of type timestamp. I guess it's best to do this i the query but I haven't found any working solution yet... All the other threads are using java.util.date as type. Any suggestions.

Hi all, I want so create a query which searches for all strings beginning with %. I know % isn't very clever to use but there must be a possibility to escape the %. Something like ... ack_text NOT LIKE '%%' escape ''. Any suggestions?

For the anser have a look into the comments!

I figured it out. Just n case anybody out there has kind of the same prob: I had to use the toLowerCase() function, so the expression for the first variable looks like the following: $F(ack_text).trim().toLowerCase().startsWith("button")?1:0 The second variable in order to count the "1" remains the same! I hope that helps!

Hi all, I'm trying to count cells starting with a certain String. My idea is to create one variable with value class name "java.lang.Integer", expression "$F{ack_text}.startsWith("Button")?1:0", "no calculation function" and another variable counting the "1" as discribed in another question. This method works perfectly fine for the ".equals(String)" function but for the ".startsWith(String)" function the diagram shows 0 cells. There are no compiling errors. Can anybody help me please?