...
- Open Microsoft Word and create a new document.
# - Click Add Query on the OfficeWriter toolbar.
- # Follow the steps to Create a Data Source and Building a Query in Creating a New Template.
- # In the Add Tables dialog box, find the SalesOrderHeader table in the list and select Add. Click Close.
# - In Microsoft Query, drag the following fields to the query: SalesOrderID, SalesPersonID, and TotalDue.
!ww_parameter1.jpg!
#
- Click the Hide/Show Criteria button on the Microsoft Query toolbar to open the criteria table.
!ww_parameter2.jpg!
#
- Click within the top left cell in the criteria table and select SalesPersonID from the drop-down list.
- # In Value cell beneath SalesPersonID, type*[Enter the Sales Person ID]*. This is the text that will be used to prompt the user.
# - Microsoft Query will prompt you to enter the default value for the parameter. Enter a sales person ID value.
!ww_parameter4.jpg!
#
- From the File menu, select Return to OfficeWriter Designer.
- # Using OfficeWriter Designer's Merge Fields button, add the fields to your report and set the import behavior for your dataset.
# - Deploy the report.
# - Click View on the OfficeWriter toolbar. You will be asked to enter a parameter value.
!ww_parameter5.jpg!
#
- Replace the 0 with 280. Every row displayed in the report will have SalesPersonID number 280.
!ww_parameter6.jpg!
\
Samples
Download an .rdl file created with Microsoft Query and OfficeWriter.