![[Intel Navigation Header]](/CONTENT/PIX/HEADER.GIF)
LANDesk(R) Management Suite v2.x: ReportTool Usage Tips
Contents:
LANDESK(R) MANAGEMENT SUITE V2.X: REPORTTOOL USAGE TIPS
LANDesk(R) Management Suite v2.0x
CONTENTS
This document discusses issues commonly encountered with ReportTool. It
supplements the files in LANDesk(R) Management Suite's Readme Viewer.
SQL DATABASE SUPPORT
The report tool of LDMS 2.0 can read in information from SQL databases.
You can write filters for Btrieve* files so they can be read into SQL
databases.
RPTFIX1.EXE AND RPTFIX2.EXE FILES ADDRESS THE FOLLOWING ISSUES IN
LANDESK MANAGEMENT SUITE v2.01A OR EARLIER
Summing formula errors in SQL due to functionality
Changes from ODBC 1.0 to 2.0
ODBC error associated with numerical CSV filenames (i.e. 12345.csv)
Report templates installing older ODBC drivers
Inserting OLE objects
Printing only specific pages of a report, Prints the header for all
pages
Incorrect section border width
ODBC ERRORS
To avoid problems with different versions of ODBC drivers being accessed
for Report Tool, on each LANDesk administration station that has run
Report Tool, do the following:
a. Run the Windows* Control Panel
b. Run ODBC
c. Delete any "Reporter Data Text" Data Sources (ODBC v1.0) We
currently use "Reporter Text Files" drivers, ODBC v2.0
If the drivers are recreated, download and apply the RPTFIX1.exe and
RPTFIX2.EXE files.
NOTE ON DTM.RPT REPORT TEMPLATE
The Item and Value data fields in the Detail section should be of type
String. Because of parsing algorithms, a type is not associated with
them, and the fields will need to be reassigned as type String each time
the report is opened until a fix to the algorithm is available. To
reassign it, right click on the field, choose Data Type, then choose
String.
TABLE COULD NOT BE PROCESSED; ODBC SINGLE TIER DRIVER; NON-UNIQUE COLUMN
REFERENCE
Symptom:
The .CSV file contains more than one column heading with the first 30
characters being identical. Two displayed components have the same 30
characters.
Solution:
Either remove one of the "duplicate" components given in the error
message or modify LDAPPL.INI to shorten the component name.
REPORT TOOL COMPATIBILITY WITH CRYSTAL REPORTS
LANDesk report tool does not support Crystal Reports at this time.
TABLE COULD NOT BE PROCESSED - [ODBC TEXT DRIVER] TEXT IS TOO LARGE -
SELECT * FROM LANDESK\REPORT\CSV.[TEST.CSV] [TEST]
When choosing the component set for a CSV file to print inventory
information, choose fewer inventory items.
This document discusses issues commonly encountered with ReportTool. It
supplements the files in LANDesk Management Suite's Readme Viewer.
SQL DATABASE SUPPORT
The report tool of LANDesk(R) Management Suite 2.0 can read in
information from SQL databases.
You can write filters for Btrieve* files so they can be read into SQL
databases.
Trademark information