JPivot chart - line chart

[nicholas]

I was unsure if this was best posted here, or over at a JPivot forum. I selected here to start with, as if I can achieve this with editing some code maybe it is JasperServer specific help that I might need.

 

I have this MDX query shown in the chart:

 

Code:

select {[Measures].[unit Sales]} ON COLUMNS,
  {[Time].[2006].[Q1].[1]} ON ROWS
from [sales]

 

I've done this to see what happens to the chart when it has only a single data point to show, and Vertical Line is set as the Chart Type. We're testing to see if single points are still shown at all, or they get hidden.

 

It looks like nothing is drawn at all, because the line needs at least two points. My client says that Excel (their current application) would draw a small cross if a line wasn't possible.

Could JPivot/JasperServer Pro 2.1 do this? If not, what might I need to do to make this happen?

 

Much thanks,

 

Nick

[swood]

I have been talking with Alex at JasperSoft about this. It looks like a JPivot/JasperAnalysis bug. JFreeChart running within JasperReports will show the single point.

 

 

Sherman

JasperSoft

[nicholas]

Thanks for trying this out and confirming the problem.