Excel Reporting

• New Java™ Application Object - Full runtime control of the Excel file format in Java™
• Pure .NET Application Object
  • No dependency on COM; no need to register DLLs
  • Run different versions side-by-side
• Refactored API/Object Model - More intuitive and straightforward
• Conforms to platform expectations Properties, enumerations, indexers on .NET
• Complete API for charting
  • Manipulate existing charts created in Excel
  • Create or modify any type of Excel chart
  • Remove unwanted charts
  • More customization than is possible through Excel
• Create, modify, and delete visual Excel features, including:
  • Comments
  • Drawing objects and shapes
  • Images
• Insert and delete rows and columns
• Formula support for all built-in Excel functions
• Read and write Array-entered formulas
• Support for 3D ranges
• Full control of the worksheets collection – insert, remove, reorder
• Layer styles or apply parts of styles to:
  • Cells
  • Areas
  • Ranges
  • Rows
  • Columns

Word Reporting

• New Application Object for both Java™ and .NET – Full runtime manipulation of the Word file format
• Create, modify, and delete Word features, including
  • Formatted Text
  • Paragraphs
  • Sections
  • Tables
  • Lists
  • Fields
  • Document Properties

SQL Server Reporting Services

• New parameters support – Create powerful spreadsheets with parameterized queries
• Open existing RDLs
  • Leverage existing reports configured in VS.NET
  • Build reports using pre-defined queries, connections, report and query parameters
  • Retrieve reports from Reporting Services servers or open reports from disk
  • Add full Excel & Word support to existing RDL files
• Use number and date formatting
• Use Reporting Services formulas in Excel and Word to create totals or place report parameters or global variables on the template report
• Browse and execute reports from Reporting Services servers right into Excel and Word