Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

OfficeWriter Designer .NET

...

for

...

64-bit

...

and

...

32-bit

...

Excel

...

You

...

will

...

find

...

the

...

OfficeWriter

...

Designer

...

.NET

...

toolbar

...

on

...

the

...

Excel

...

ribbon,

...

under

...

OfficeWriter

...

Designer

...

.NET

...

Image Added

 

Note

As of OfficeWriter 8.6,

there

are

two

OfficeWriter

Designers

available

for

Excel:

the

OfficeWriter

Designer

and

the

OfficeWriter

Designer

.NET.

The

differences

between

the

two

Designers

are

outlined

in

[

OfficeWriter

Designer

vs

OfficeWriter

Designer

.NET

]. {note} h2. File | *Open* | The *Open* button provides the option to *Open From Disk* and *Open From Server.* \\*Open From Disk:* open an RDL file stored locally on your machine. \*Open From Server:* Download an RDL file from a report server. \\ \\ | !Dropdown_Open.PNG! \\ \\ | | *Save* | The *Save* button provides the option to *Save to Disk* and *Deploy to Remote Server.* \\*Save To Disk:* save your template as an RDL file. \*Deploy To Remote Server:* Publish your report on the Reporting Services server. Once you do this, your report will be available for viewing in Excel and through Reporting Services Report Manager. \\ \\ | !Dropdown_Save.PNG! \\ \\ | | *Import Template* | The *Import Template* button allows you to import an existing XLS, XLSX, or XLSM file and use it as the template for the RDL. This will remove any existing design information. \\ \\ |!Button_Import.PNG! \\ \\ | | *View* | The *View* button sends a request to Reporting Services to run your report, then displays the results in another window in Excel. If you click this button with an unpublished report open, you will be prompted to publish before viewing. \\ \\ | !Button_View.PNG! \\ \\ | h2. Report | *DataMarkers* | The *Data Markers* button provides a list of all the data sets in the RDL file. \\ \\ Navigating to and hovering over one of the data sets will expose the fields in the data set query. Clicking on a field from the list will insert the data marker for that field into the current active cell. | !Dropdown_DataMarkers.PNG! \\ \\ | | *Report Properties* | The *Report Properties* button will launch the [Report Properties|RS8:Designer .NET Excel - Report Properties] dialog. \\ \\ |!Button_ReportProps.PNG! \\ \\ | h2. Help | *Help* | The *Help* button provides links to information about the OfficeWriter Designer toolbar. \\ \*About OfficeWriter* will display the version of the Designer toolbar. \*OfficeWriter Documentation* is a link to the OfficeWriter Docs. \\ \\ | !Dropdown_Help.PNG! \\ \\ |

.

File

Open

The Open button provides the option to Open From Disk and Open From Server

Open From Disk: open an RDL file stores locally on your machine.

Open From Server: Download an RDL file from a report server.

Image Added
Save

The Save button provides the option to Save to Disk and Deploy to Remote Server.

Save To Disk: save your template as an RDL file.

Deploy To Remote Server: Publish your report on the Reporting Services server. 
Once you do this, your report will be available for viewing in Excel and through
Reporting Services Report Manager.

Image Added
Import Template

The Import Template button allows you to import an existing XLS, XLSX, or XLSM file
and use it as the template for the RDL. This will remove any existing design information.

Image Added
View

The View button sends a request to Reporting Services to run your report, then
displays the results in another window in Excel. If you click this button with an
unpublished report open, you will be prompted to publish before viewing.

Image Added

Report

DataMarkers

The Data Markers button provides a list of all the data sets in the RDL file.

Navigating to and hovering over one of the data sets will expose the fields in the data
set query. Clicking on a field from the list will insert the data marker for that field into
the current active cell.

Image Added 
 Report Properties 

The *Report Properties* button will launch the Report Properties dialog.

 Image Added

Help

Help

The Help button provides links to information about the OfficeWriter Designer toolbar.

About OfficeWriter will display the version of the Designer toolbar.
OfficeWriter Documentation is a link to the OfficeWriter Docs.

 

 Image Added