Export the original ResultSet but not the chart?

[leeyuiwah]

When our users see a graphical chart (i.e. not a table of numbers) and do an export to Excel or CSV, they will get an image of the chart, but they actually want to see the original resultSet (the raw numbers) so that they can further play with the data.

 

Is there a way to do this?

 

Thanks! 

[mgeise]

This would require a second report to drill through to and export the details.

 

Your best bet here would be to create a report that leverages the same query but generates a detailed listing of records and use it as a drill through, where you pass the same parameters from the chart to the second report to generate the details for the user to drill into.  For what it is worth, with the right controls, etc. you could even use the same report  to allow for drilling into the specific details of the chart.  For example, a particular slice of a pie chart could have a URL that links to the report with specific parameters for that slice of the pie, allowing the user to drill into the records that are represented only by that slice, rather than all records represented in the chart.

 

Thanks!

Matt

Jaspersoft