|
I've run a Report but I want to save the results
in Excel. Can I do this?
Contributed By:
Cliff Hobbs [MVP
ConfigMgr/ SMS]
Natively you can't save the results of a Report
into an Excel file. However, you can either copy the results from a Report
to the Clipboard or export the results to a Comma Separated Value (CSV) file
(you can also Print the results).
To copy the results into Excel (or
to another application), simply click on the "Copy" item at
the very top of the Report Viewer window (above the "Report Name:"
field), which copies the results to the Windows Clipboard. Switch to Excel
and paste the results.
To save the results to a .CSV file:
- Click
on the "Export" item at the very top of the Report
Viewer window (above the "Report Name:" field). This
will open the "File Download" dialog box.
- Click "Save" and
browse to the location where the CSV file should be stored.
- Click "Save" on
the "Save As" screen to save the file to the desired
location (you can change the file name if required).
- Open Excel and import the CSV file.
|
