...
You can open a saved RDL file in Excel and add OfficeWriter template information to it.
Opening a Saved RDL File
This section assumes that the RDL file being opened was created in Visual Studio contains the following query:
\
\
To open the RDL:
...
Info |
---|
Since this report was designed in Visual Studio, the MS Query functions to Add, Edit, and Delete datasets are not available. They will only be enabled for reports that are created in the OfficeWriter Designer using MS Query. |
Designing the Template
The next step is to design the report with the OfficeWriter Designer toolbar. We have several articles for how to develop reports with the OfficeWriter Designer in Excel:
- Adding Data Markers
- Adding Formulas to an Excel Report
- Excel Reports with Parameters
- Working with Charts
- Working with PivotTables
- Working with PivotCharts
Saving the Template Information to the RDL
When you save the file, the OfficeWriter template information will be added to the RDL file. To save the template information to the RDL:
...
See Saving and Deploying Your Excel Report for more information.
Deploying and Viewing the Report
- To deploy a report from the OfficeWriter Designer select Save > 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.
# 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.
\
Once the report has been deployed to the report server, you can view the report from within the OfficeWriter Designer by clicking View or going to Report Manager and exporting the report in the OfficeWriter for Excel rendering option.