martinjones

It would be great if this was included. Or even an option in some config file to say 'output as XHTML instead of HTML'. That way, people (like me) with no prior JasperServer knowledge could easily change the default output method without having to delve too deeply into the code.

After a day of trying, I am still nowhere near a solution. I thought I may be able to change the expression of the variable to ( TYPE == '1' ? VALUE : Nothing ) thinking that when it evaluates the expression in order to add to the sum, it would only add VALUE if TYPE = 1. However, this does not work. Could someone maybe point me in the right direction? Thanks

I have a table with three columns KEY TYPE VALUE Data in the field would be KEY TYPE VALUE 1 1 100 2 1 200 3 2 400 4 2 500 5 3 1200 I need to show the subtotals for all type 1, all type 2 and all type 3 on a report So, the single line in the report would be Total A Total B Total C 300 900 1200 How would I achieve this in iReport? I have tried doing three sum variables, but cannot seem to work out how to only sum the different types for the three variables. Thanks Martin

OK - got it working - had the report parameters set up incorrectly, so wasn't displaying lines, and was showing alternating shapes at each point on the line. I changed the series expression to a single value and now it displays with lines.

Add a second series to the line graph, and you will get another set of data.

I am trying to plot a line chart. However, I cannot get the line to actually display. I can get the shapes to display, but no line. I have both ShowLines and ShowShapes displayed. Also, the shapes seem to be random. I would expect series one to have a certain shape, series 2 a different shape and so on. Not so. It seems to put a circle, then a square, then a triangle etc for each series, which seems wrong. Help! Martin

I have managed to implement the desired functionality by overlaying three separate charts, with different series colours for each chart. FYI, in each chart, in each category series, I had to put the following in the value expression So, chart 1 has the value expression ($V{Amount} >= 75) ? $V{Amount} : 0 Chart 2 has ($V{Amount} >= 65 & $V{Amount} < 75) ? $V{Amount} : 0 and chart 3 has ($V{Amount} < 65) ? $V{Amount} : 0 That way, the charts overlay each other with separate colours, but do not display the bars if they are out of the range I wish to display. Thanks for the inspiration about hiding and overlaying.

Hi, Thanks for getting back to me. I will try to be more clear and explain a bit more: I am using iReport to make the charts, and using JasperServer to display them. I guess they are static charts as I am not generating them through java code. I don't think the 3 overlayed charts will work, since this seems to only display the entire chart if the condition is met. I wish to have individual bars on the same chart in different colours. e.g. The first 5 columns (>75%) will be green, then next 4 columns (>65 & < 75) will be yellow, and everything less than 65 will be red. Is this possible? Thanks Martin

Is it possible to colour a bar chart's columns differently depending on some value? I have a chart where I want to colour everything over 75% green, everything 65-74% yellow, and everything below 64% red. Can I do this? If so, how? Thanks in advance, Martin

I have downloaded the latest releases of both JasperServer (3.5) and iReport (3.6.1) However, after adding a report to the server, when trying to run the report unit, I get 1 - org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'itemLabel'. One of '{"http://jasperreports.sourceforge.net/jasperreports":categoryAxisLabelExpression, "http://jasperreports.sourceforge.net/jasperreports":categoryAxisFormat, "http://jasperreports.sourceforge.net/jasperreports":valueAxisLabelExpression, "http://jasperreports.sourceforge.net/jasperreports":valueAxisFormat, "http://jasperreports.sourceforge.net/jasperreports":domainAxisMinValueExpression, "http://jasperreports.sourceforge.net/jasperreports":domainAxisMaxValueExpression, "http://jasperreports.sourceforge.net/jasperreports":rangeAxisMinValueExpression, "http://jasperreports.sourceforge.net/jasperreports":rangeAxisMaxValueExpression}' is expected Having searched around, there appears to be incompatibility between the .jar files. As suggested here: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=62006 I copied the jar files from my locally installed iReport to the server. The files I copied were jasperreports-3.6.1.jar jasperreports-chart-themes-3.5.3.jar jasperreports-extensions-3.5.3.jar to c:program filesjasperserver-3.5.0scriptslib on my server (running Windows 2008 Server) but still get the error. I have tried rebooting the server but still get the error. I renamed the existing jasperreports-3.5.0.jar and jasperreports-chart-themes-3.5.0.jar to .OLD. The extensions jar didn't exist there. Please help Thanks Martin PS: From a usability point of view, I would expect the latest builds of iReport and Server should be compatible with one another, 'out of the box'. New users shouldn't have to experience issues such as this. Otherwise, they may just give up and go and use Crystal Post Edited by martinjones at 11/12/2009 14:49

Please ignore. I found the answer here: http://www.jaspersoft.com/how-set-role-based-jasperserver-home-pages

I have created a dashboard which I can display without problems. I have also created a new user. How do I configure JasperServer so that when my new user logs in, they are presented with this dashboard, instead of the View / Create / Analyze options? Thanks Martin