matthew.harrison
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by matthew.harrison
-
-
Hi, I've hit a bit of an issue, and am hopeful someone can give me some pointers on formatting my charts correctly.
What I'm doinf is producing a stacked bar chart, which is fine. However the problem I'm having is that the Legend (showing the Series data) should be in a defined order. In the SQL I can define the order, but this is for the Category, and then the Series, so for example if I get data that looks like this (I think - this is just made up data):
Category Series Value 1 2 5 2 1 3 2 2 8 3 3 7 Then when the graph is shown the Category is sorted fine, but the Legend (showing the Series), would look like [2, 1, 3] in this case I believe - i.e. in the order that they come in in the data.
Is there a way to sort them in a customised way?
I did try putting 'dummy' data into the data set, so that the first record would have the correct sort order for the Categories, which sort of worked, but this gets messy fast I think. So am I now looking at a customizer to get it sorted correctly? If so any pointers would be appreciated.
Thanks in advance,
Matt
-
Hmm, ok. I had a little look at the HTML exporter, and made some changes so that when it found a new style it created a class, and added a style into the page, and then used that style further on in the page. This reduced my 138Mb report down to 73Mb - still too big for us, but anyway. What we've ended up doing is pointing the users to other renditions by default.
The changes I made do seem to produce a large reduction in the HTML size (although I think to really cut it down you would need to do something more drastic to the page). Would it be something of interest for me to contribute back? (if so could you point me to the getting started point for contributions?)
Cheers,
Matt
-
I've been using Jasper Reports 6.1.0 to produce reports, and its generally going quite well. One issue I've hit is that when we produce HTML reports with quite a few results the HTML page that gets generated is too big to open in IE (effectively). It will just about open in Chrome, but that's not the target here.
I think the issue is that each cell in the report gets its own 'style=...' attribute. Whilst I can understand that this gives full control over the display in the report, in my case its making the HTML rather large - and the report layout in this case is a very simple grid. Is there any way that styles can be set externally (CSS), and/or the 'style=...' attribute can be suppressed? Or any ideas on how I might reduce the amount of style settings used?
Thanks in advance,
Matt
Ordering Series Legend in stacked bar chart
in Products
Posted
I ended up finding an answer for this in the end. If its of any use to people in the future, I created a chart customizer, which allowed me to define a property to define the legend labels: