finn.hoffmeister

There are a lot of additional columns like one for the date (DD.MM.YYYY) and number of month. So I was already trying to do an "ORDER BY" query, but it would still sum up the J´s.

Hey. :-) My database contains a column "month" (with is the first letter of each month only) and the matching value. Since there are several letters like "J" for january, june and july or "M" for March and May with multiple values, I have the problem that Jaspersoft is summerizing them. Is there any way I can seperate them? Do I have to change the query? Thanks in advance!

Hey, I have the same definition but unfortunately it still shows "null"... I have tried to create a subreport and somehow it worked there, but when I am trying to preview everything in the original Report, nothing will show up at all, not even a "null". Do you have an idea how why this might be? :D

Hi there, I have a table in my database, that shows different values for each month. So I created a chart showing that and I now am trying to implement a textfield that says "average value of the last 12 month: And than the average". So I have been doing some research and it seems like I have to create a Variable, which I did. I named the Variable, changed the Value Class Name to java.lang.integer, chose Average for the Calculation option and set the expression to $F{value} (which is the name of the value-table.) When I am trying to drag the Variable into my report, it will only show "null" in the preview. Does anyone know what to do / has a well written instruction for this? Thank you!

Hey :-) I am trying to style my Bar Chart, but unfortunately the Bars are grouped, which I don´t want them to be. This is my curent chart, but I want all 12 Bars to have the same space between them. The Q1 - Q4 should remain there. Do you know if there is any option in Jaspersoft Studio? Thanks a lot ;-)

Hi everyone! I am trying to create a chart, but I really don´t understand, what the phrases "Series, Value, Label, Key" really stand for. I created a database with a table: Month number January 4 February 12 So I connected the database with Jaspersoft, I ccreated a dataset and set the query SELECT month, number FROM database_name and now I have no idea how to continue. When I try to fill in all the fields in the Chart Wizard I will always get an error. Most of the time this one: Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Number Can anyone tell me what the phrases stand for? Please don´t tell me to see the instructions, they just say what to do with the sample data and I am able to build this chart. Now I want to make a chart based on my data! :) These are the ones I am talking about:

Hey :) I am trying to make a chart. I really just want to make ANY chart, but I cannot make it until the end:( . There will always be a mistake. Even when I am following the instructions from here --> http://community.jaspersoft.com/wiki/creating-charts-and-subreports-jaspersoft-studio I will only end up with this Can anybody tell me what the reason is for this displacement? I´ve tried to change the source but nothing would happen... Furthermore: is there a good (and working) instruction? Everything I´ve found was not working, because all of a sudden someone had a database out of nowhere or didn´t explain what to do in some situations.. :( I hope someone can help me :) Thanks !!

Thanks! Do you also know how the JDBC Url works? When I enter the path for the JDBC Url it will only tell me that the database "name_of_database" is not existing... The instructions from here (http://community.jaspersoft.com/questions/801825/how-create-new-remote-db-mysql-connection-jasper-etl ) are not useful :( Thank you :)

Hi, I am very new to this tool and I am failing to connect my database from phpmyadmin to Jaspersoft Studio. In which structure do I have to write the JDBC URL? is it jdbc:mysql://localhost/phpmyadmin/file ? And secondly--> When I have to add a new Data Adapter in the section "Driver Classpath" I cannot find a JAR File in my directory. Is there something I forgot to download? Thanks in advance :)