| Design
Reports Using Microsoft Word |
 |
The OfficeWriter Designer for Word allows end-users to create a Microsoft
Word template that can be dynamically populated with data by SQL Server
Reporting Services. Extremely easy to use, the OfficeWriter designer for
Word takes report designing out of the developer's hands and allows the
end-user to set up the Word report exactly as they want it. Because the
designing tool is Microsoft Word, the learning curve is very short
and no additional time is required for training. |
| |
| |
| How
it Works: |
 |
| |
| |
| Step
1: Design Your Template in Word |
|
Create
your Word template in Microsoft Word just like any other document.
When you're finished designing, select OfficeWriter Designer for Word from
the toolbar. |
| |
 |
| |
| |
| Step
2:Configure Data Source |
|
Use
the OfficeWriter Designer for Word to create and configure your data sources.
The screenshot below shows how database columns are selected for use in
the document. |
| |
 |
| |
| |
| Step
3: Insert Merge Fields |
|
Use
the OfficeWriter Designer for Word to insert merge fields as placeholders
for data.
In the screenshot below, an OrderID field is being inserted. |
| |
 |
| |
| |
| Step
4: Set Repeat Blocks |
|
WordWriter
also handles repeating regions. Use the Designer to configure a Repeat Block.
This Word table will grow depending on how many records are in the Repeat
Block's data source. |
| |
 |
| |
| |
| Step
5: Upload RDL to Reporting Services |
|
| Export
the report as a Report Definition Language (RDL) file and upload it to Reporting
Services, directly from Microsoft Word. |
| |
 |
| |
| |
| Step
6: Render the Report |
|
| Select
the SA Word Template custom rendering extension to render the report to
native Word. |
| |
 |
| |
| |
| Step
7: View the Processed Report |
|
| Data
is dynamically inserted into the Word template document. |
| |
 |
| |
| |