Section | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Panel |
---|
What is SSRS Integration?OfficeWriter Reporting Services Integration |
...
...
by allowing users to design and deliver their reports in native Word and Excel. |
...
Two Parts
Reporting Service Integration |
...
consists of two components:
|
Benefits of ExcelWriter Renderer over Native Excel Renderer
- OfficeWriter allows Microsoft Excel users to maintain and create spreadsheets that contain:
** Pivot tables
** Interactive charts
** VBA and macros
** Advanced formulas
* OfficeWriter allows you to separate roles of query developer and report designer. A developer can create shared data sources and build queries, and a business user can design the report in Word or Excel.
* OfficeWriter delivers reports directly from Excel or Word. Use the OfficeWriter toolbar to browse the Reporting Services server and display the OfficeWriter rendered reports directly in Office.
* The familiar Word and Excel design environments eliminate the learning time required by more complex development environments like Visual Studio .NET.
* Avoid the cost of additional Visual Studio licenses by using the freely-distributed OfficeWriter designer in Word or Excel.
* OfficeWriter generates real RDL files, allowing you to take full advantage of Reporting Services' report management, security, and delivery options.
Benefits of WordWriter Renderer over Native Word Renderer
- The Microsoft Word format has only limited support in Reporting Services 2008 and no support in Reporting Services 2005 without the use of OfficeWriter.
* OfficeWriter delivers reports directly from Excel or Word. Use the OfficeWriter toolbar to browse the Reporting Services server and display the OfficeWriter rendered reports directly in Office.
* The familiar Word and Excel design environments eliminate the learning time required by more complex development environments like Visual Studio .NET.
* Avoid the cost of additional Visual Studio licenses by using the freely-distributed OfficeWriter designer in Word or Excel.
* OfficeWriter generates real RDL files, allowing you to take full advantage of Reporting Services' report management, security, and delivery options.
|