Creating Audited Software Report with Crystal Reports
ID: Q150814
|
1.00 1.10 1.20
WINDOWS
kbnetwork kbusage kbhowto
The information in this article applies to:
-
Microsoft Systems Management Server versions 1.0, 1.1, 1.2
SUMMARY
This article gives a brief description of how to set up a report in Crystal
Reports for Audited Software.
Crystal Reports is manufactured by a vendor independent of Microsoft; we
make no warranty, implied or otherwise, regarding this product's
performance or reliability.
MORE INFORMATION
To set up a report in Crystal Reports for Audited Software, complete the
following steps:
- From the toolbar, select the New Report button.
- From the SQL Table, select Report.
- Use the ODBC connection to the SMS database for "SQL Types."
NOTE: This option will not appear if you have already run a report for
SMS.
- In the Choose SQL Table dialog box, select SMS.dbo.vAudited_Software
from the SQL Tables list box. Click OK.
- When the report window comes up, choose Database|Add Database to
Report from the menu bar.
- From the SQL Tables list box, select SMS.dbo.vIdentification. Click
OK.
- In the Define Link dialog box, click OK.
- In the Links dialog box, click Done.
- Drag Name0 from the Insert Database Field dialog box to the Details
section of the report.
- Drag Package_Name0 from the Insert Database Field dialog box to the
Details section of the report.
- From the menu bar, choose Report|Refresh Report Data.
- Make formatting changes as necessary.
- Save the new report.
NOTE: Microsoft is unable to provide support for Crystal Reports. Crystal
Reports is supported by Crystal Services at (604) 669-8379.
The third-party contact information included in this article is provided to
help you find the technical support you need. This contact information is
subject to change without notice. Microsoft in no way guarantees the
accuracy of this third-party contact information.
Additional query words:
sms prodsms
Keywords : smssetup smshowto
Version : winnt:1.0,1.1,1.2
Platform : winnt
Issue type :
|