mark.eveleigh

No unfortunately. In the end just went with the chart by assembly as that was OK. The Area totals are in the detail so left it at that.

I have a report that lists the detail from a JDBC query, which is primarily reporting a number of counts of occurrences of data. These counts are grouped at two levels, so that in the main part of the report, I have a top level group, then one or more second level groups, then the detail records, so that the report output looks something like: Area 1 Assembly1 Part1 4 Part2 3 Part3 5 Assembly2 Part1 1 Part2 7 Area2 Assembly3 Part1 8 Partx n … This all works fine. I also have a requirement to chart the counts. These need to be in separate charts, one that is by ‘Assembly’, the other by ‘Area'. The ‘Part’ element is the series expression in the chart so that I get a line for each part, with the Assembly being Category expression. Again, this works fine and I get the graph I require. Where I get the problem is creating a graph that provides a summary at ‘Area’ level. That is, I require a graph that has the Category being the Area, then a sum of the Part items by Area. So, for Area1 in the above, I’d have a series line (bar chart) with Part1 having 5, Part 2 having 10 and so on. I’ve tried a number of different combinations of options, but this final chart does not provide the numbers required - I only get the counts for the final inner group. Am I expecting too much of charts? I would prefer not to repeat the query and perform a different summary in a sub-report as the actual query is quite complex and can cover a lot of data.

Is it possible to establish a definitive list of which HTML tags are allowed and interpreted when a text field is defined as markup=html? In the documentation for the markup sample it is stated "If the html or rtf values are set, then the engine calls a dedicated markup processor class based on the use of the javax.swing.JEditorPane processor. The structured XML fragment is parsed according to the processing rules, and its content gets formatted as included style attributes require to be." but this does not define what is and is not interpreted. I have seen comments and answers that state character formatting is supported but that positional code and items such as tables are not. I am attempting to include data that is stored in a database that can be either HTML fragments or HTML documents. For documents I am extracting items such as the "body" tag to be included in the report. Some formatting and tags are represented correctly (colours, simple lists, fonts and font sizes [once the relevant font extension is created], hyperlink [present but not formatted]), however a number are not and/or seem to be overridden by the report styles for the field (such as the base colour). It would be extremely helpful if we could get a definitive list of allowed tags and capabilities so we know what can and cannot be reported. We have looked at the HTMLComponent but this has too many restrictions in its current form around expanding and support for page breaks/multiple pages.