etienne.girot

Thank you for your help. Actually doing it the SQL query is already the solution I'm using (with highchart). I thought that introducing a BI tool such as Jaspersoft would save me the effort of formatting programmatically the data before-hand... I saw some videos of jasper where they were doing complete reports only with the UI but maybe it's what they call "Ad-hoc report designer" which is only available in the non-community version, can you confirm it?

Thank you for your help. Actually doing it the SQL query is already the solution I'm using (with highchart). I thought that introducing a BI tool such as Jaspersoft would save me the effort of formatting programmatically the data before-hand... I saw some videos of jasper where they were doing complete reports only with the UI but maybe it's what they call "Ad-hoc report designer" which is only available in the non-community version, can you confirm it?

Hi everybody, I need a little help to get started with Jasper, I read the different tutorial but I can't find what I'm looking for: I have the following "FavoriteFruit" table in my SQL DB: User_idAppleBananaStrawberryOrangeWatermelon110000200001310000401000And I want the following result: My dataset query is "SELECT * FROM FavoriteFruit". What do I need to insert in the bar chart assistant for the fields "Values" and "Category" to obtain this?

As mentioned, the example above is a simplification, actually it is really difficult for me to obtain the 2nd table as a SQL query (which I think you would consider to be the sub-dataset). On the other side, the crosstab does it really easily, that's why I would like to use the crosstab output as input for a bar chart. Is it possible?

Hi everyone, I'd like to know whether it is possible to reuse the values of a table as input to draw a bar char? For example I get the following tuples from a dataset "SELECT * FROM User": User idFavorite fruitAge1Apple362Apple143Banana564Apple51I use the "table" widget to get AVG(age)Apple33,7Banana56And I'd like to draw it this way Can I reuse the table data or should I change my dataset ? Obviously, this is a huge simplification of what I need to do to make it understadable... The point is, I have to perform difficult crosstab calculations on a complex dataset query and draw them into a graph and it would same me a huge amount of time and headaches to use the capabilities of crosstab widget instead of writing them myself in SQL. Thank you for your help!