Page History

...

1. Open Microsoft Excel
   # Go to the OfficeWriter Designer tab and click Open Report
   # If your report defintion file was saved on a local or network drive, navigate to the folder containing the file, select it, click Open, and continue to Adding Fields to your report
   \If your RDL file was deployed to Reporting Services, click the Retrieve on the bottom right corner of the dialog box.
   !xlw_FirstfromRDL1.jpg! \\\ Image Added
   # In the Report Browser dialog box, type in your report server's URL or Domain name and click Refresh. This will load all the available report folders into the list box. Navigate to your report file, select it, and click Ok.
   !xlw_FirstfromRDL2.jpg! \\\ Image Added

Adding Fields to Your Report

...

For this tutorial we will use an RDL that was created in Visual Studio containing a data set with the following query:

\

1. Place your curse in the cell A2 and click inside it. This is where we will insert the data marker.
   # Click Data Markers on the Designer toolbar and locate your data set from the drop-down list.
   !excel_designer_datasets.jpg! \\\ Image Added
   # 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! \\\ Image Added
   # 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! \\\ Image Added
   # 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.

...

1. From the OfficeWriter Designer toolbar select Save. 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, click Save and select Deploy To Remote Server.
   # From the Publish dialog box select the drop-down to display the Server or URL.
   # Choose the server on which Reporting Services is installed.
   #  
   1. If you have never browsed to the server from the designer before, you will need to manually enter the URL the first time.
   2. Use the Web Service URL, which can be found in the SSRS Configuration Manager on the report server.  It usually looks something like this:  http://<servername>/ReportServer, or if there is a named instance of SQL Server, http://<servername>/ReportServer_IntanceName
2. 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! \\\ Image Added
   # Select Close Report View to return to your report template.

...