.
...
- Click Data Markers on the Designer toolbar and locate your data set from the drop-down list.
!excel_designer_datasets.jpg!
# Hover over your data set to see the fields that are available. - Select the ProductId field to insert the data marker into cell A2. Your template should now look like this:
!xlw_FirstfromRDL6.jpg!
# Place your cursor in cell B2 cell and click inside it.
# Click Data Markers again, hover over your data set, and select the Name field. Your template should now look like this:
!xlw_FirstfromRDL7.jpg!
# Place your cursor in cell C2 cell and click inside it.
# Click Data Markers, hover over the data set, and select the ListPrice field.
# Place your cursor in cell D2 cell and click inside it.
# Click Data Markers, hover over your data set, and select the Days to Manufacture field.
# In cell A1 type Product ID, in cell B1 type Product Name, in C1 type List Price, and in D1 type Days to Manufacture.
...
Before publishing the report on the Reporting Services server, we must save the Excel template locally as an RDL file.
- From the OfficeWriter Designer toolbar select Save As.
. You will have the option to Save to Disk or Deploy to Remote Server. - Select Save to Disk.
# Navigate to a local folder where you will store the template report file. This will be where you store your work file in case you want to edit it later, not a location on the Reporting Services server.
# Save the template as an RDL file.
# To publish the report, from the toolbar, select Publish.
# From the Publish dialog box select the drop-down to display the Server or URL.
# Choose the server on which Reporting Services is installed.
# Click Refresh.
# Select a folder for which you have publish rights and click Ok.
# If your report published with no errors, you will receive a Publish Successful message dialog. Click Ok to continue.
# To view the report, click View on the OfficeWriter Designer. The report viewer will open another Excel window with the report results. It should look like this:
!cfxr_figure13.jpg!
# Select Close Report View to return to your report template.
...