Save Reports as Word Files
Packeteer provides you with a Microsoft Word document that can pull
live data from your unit and create a Network Performance Summary report.
You can then save the generated report for future reference. This report
is just an example of what can be done with Visual Basic for Applications
(VBA) — you can create your own VBA scripts to produce other types
of reports.
Allow Offline Reports
By default, PacketWise's authentication process does not allow third-party applications to access data on your unit. If you want to be able to create external reports, you can enable the feature that allows third-party applications to create graphs from your unit's data, without requiring authentication.
1. Click the setup tab.
2. From the Choose Setup Page list, select
security. The security settings appear on the Security Settings
screen. 
show screen
3. In the Offline Reports field, select allow.
4. Click apply changes to update the security settings.
Download the Word Document
Next, download the summary.zip file to a PC or network drive. This ZIP file contains a Microsoft Word document named summary.doc.
1. Click the report tab. The Network Performance
Summary appears; the offline report button is in the upper-right
corner. show screen
2. Click offline report.
3. Click OK to download and save the file.
4. Save the file to a PC or network drive with the name summary.zip.
5. Unzip the file. You should have the summary.doc file on a PC or network drive.
Generate the Report
The summary.doc document contains a small form to fill in the IP address of the PacketShaper, the SNMP password, and the time period. The document also contains macros for retrieving the data from the unit and generating a report.
1. Start Microsoft Word.
2. Make sure Word's macro security level is set to Medium. (To check the level, choose Tools > Macro > Security.) The Visual Basic script will not run when Word has a High security level.
Note: If you have already opened the summary.doc document, you will need to close the file and reopen the document in order to run the macros.
3. Open the summary.doc document. A message box asks if you want to enable macros.
4. Click enable macros. The Packeteer Report
Generator document appears. show screen
5. Fill in the IP address of the Packeteer unit from which you want to generate a report.
6. Enter the Look SNMP community string in the SNMP Password field. The community string is usually public. To check, go to the SNMP setup page (see Configure PacketWise for SNMP Support for instructions).
7. Specify the time period for which you want to create a report (for example, 2 days).
8. Click generate report. After a moment, the Network Performance Summary appears in a new window.
If the generated report does not contain any graphs, the offline reports option in PacketWise was not enabled. See "Allow Offline Reports" above.
Save the Report
The generated report can be saved as a Word document. Simply use Word's File > Save As command.
Create Other Reports
The sample macros included in this report use the "INCLUDEPICTURE" directive to ask Microsoft Word to download graphs from the PacketShaper and automatically insert them in a specific range in a new Word document. Parameters in the URL specify what time period, variables, and graph type are to be used. When used with a URL, INCLUDEPICTURE requires authentication information to be embedded in the URL and hence the SNMPPASSWORD= parameter. Here is the macro code used in the provided Word document:
' Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty,
Text:= _
' "INCLUDEPICTURE
""http://10.0.0.2/Cgi?OP.MEAS.GETGRAPH=&MEAS.NAME=/Outbound&MEAS.TYPE=link&MEAS.PERIOD=3600&MEAS.VARLIST=avg-bps%20peak-bps&MEAS.VARLISTLABEL=Average%20Rate%2CPeak%20Rate&MEAS.GRAPHTYPE=line&MEAS.YLABEL=&MEAS.GROUP=day&SNMPPASSWORD=public"""
_
' , PreserveFormatting:=True
For more information about syntax to instruct PacketWise to generate specific graphs, refer to Include Graphs on a Portal Page which describes custom reports with the Customer Portal feature.