Actuate BIRT in version 11 has a new Excel emitter that creates analysis ready live Excel spreadsheets. I have created a few videos to highlight some of these enhancements:?
[b]Live Excel Formulas[/b] ? BIRT exports calculated fields and aggregations as Excel formula and functions that enables users to perform ?what-if? analysis within spreadsheet. [url="http://www.birt-exchange.org/org/devshare/designing-birt-reports/1164-export-birt-output-to-excel-with-live-formulas/#description"][u][b]Watch video[/b][/u][/url]
[b]Editable Charts[/b] ? BIRT charts are now converted to live Excel charts with an associated data sheet containing the underlying data that could be edited to see how data changes reflects back in the chart. [url="http://www.birt-exchange.org/org/devshare/designing-birt-reports/1165-create-editable-excel-charts-with-birt/"][u][b]Watch video[/b][/u][/url]?
[b]Pivot Tables[/b] ? BIRT crosstabs are exported as pivot tables containing the underlying data for further analysis. These pivot tables can be used to analyze the data based on different dimensions or to perform what-if analysis by altering the underlying data sheet. [url="http://www.birt-exchange.org/org/devshare/designing-birt-reports/1166-convert-birt-crosstabs-to-excel-pivot-tables/"][u][b]Watch Video[/b][/u][/url]?
[b]Images[/b] ? The enhanced Excel emitter also adds support for images in the Excel output. [url="http://www.birt-exchange.org/org/devshare/designing-birt-reports/1167-preserve-images-from-birt-output-in-excel/"][u][b]Watch Video[/b][/u][/url]?
[b]Export Objects[/b] ? Export the entire BIRT output to Excel or choose a specific table, chart or crosstab to export. [url="http://www.birt-exchange.org/devshare/designing-birt-reports/1168-export-specific-objects-from-birt-output-to-excel/#description"][u][b]Watch Video[/b][/u][/url]
[b]Multiple Worksheets[/b] – A simple check box control enables creation of multiple worksheets. [url="http://download.birt-exchange.com/products/demos/A11/Live%20Excel/MultipleWorksheets/Multiple%20Worksheet.html"][u][b]Watch Video[/b][/u][/url]
To download the Actuate 11 milestone builds visit http://www.birt-exchange.org/wiki/Actuate_11/