Page History

...

1. Open Microsoft Excel 
   
   
2. Go to the OfficeWriter Designer.NET tab and click Open.
   
   
3. If your report definition file was saved on a local or network drive, choose Open From Disk from the drop down.  
   
   
   
   
4. If your RDL file was deployed to Reporting services, choose Open From Server.
   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. 
   

Once the RDL file is opened in the Designer, there are two ways to design your report.

1. Manually Add Fields to Your Report
2. Import a Template 

Anchor
AddFields AddFields

Adding Fields to Your Report

When you open the report, the Designer.NET parses the RDL for information about the data sets and makes that information available while you are working in Excel. Data sets will appear in a drop-down list and you will be able to insert fields from those data sets into the Excel template as data placeholders called data markers.

...

Your finished report template should look like this:

Image Removed

Image Added

Anchor
Import Import

Importing a Template

With the Designer.NET you can use the Import Template button to import a pre-existing .xlsx template file containing data markers and formatting. 

Publish and View Your Report

...