Page History

...

Let's add a parameter to a sample query. The sample will use the AdventureWorks sample database, which ships with Reporting Services.

1. Open Microsoft Excel.
   
   
2. # Click Add DataSet on the OfficeWriter toolbar.
   
   
3. # Follow steps to Creating a Data Source and Building a Query in Creating a New Template.
   
   
4. # In the Add Tables dialog box, find the SalesOrderHeader table in the list and select Add. Click Close.
   #
   
5. In Microsoft Query, drag the following fields to the query: SalesOrderID, SalesPersonID, and TotalDue.
   !xlw_parameter1.jpg!
   #
   Image Added
   
   
6. Click the Hide/Show Criteria button on the Microsoft Query toolbar to open the criteria table.
   !xlw_parameter2.jpg!
   #
   Image Added
   
   
7. Click within the top left cell in the criteria table and select * SalesPersonID* from the drop-down list.
   #
   
8. In Value cell beneath SalesPersonID, type [Enter the Sales Person ID]. This is the text that will be used to prompt the user.
   !xlw_parameter3.jpg!
   #
   Image Added
   
   
9. Microsoft Query will prompt you to enter the default value for the parameter. Enter a sales person ID value.
   !xlw_parameter4.jpg!
   #
   Image Added
   
   
10. From the File menu, select *Return to OfficeWriter Designer*.
    
    
11. # Using OfficeWriter Designer's Data Marker button, add the fields to your report.
    #
    
12. Deploy the report.
    #
    
13. Click View on the OfficeWriter toolbar. You will be asked to enter a parameter value.
    !xlw_parameter5.jpg!
    #
    Image Added
    
    
14. Replace the 0 with 280. Every row displayed in the report will have SalesPersonID number 280.
    !xlw_parameter6.jpg!
    Image Added

Samples

• Download an .rdl file created with Microsoft Query and OfficeWriter.