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.
(Click on the image to see a larger version.)
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.
(Click on the image to see a larger version.)
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.
(Click on the image to see a larger version.)
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.
(Click on the image to see a larger version.)
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.
(Click on the image to see a larger version.)
| 
