[Intel Navigation Header]

    LANDesk(R) Management Suite v2.x: ReportTool Usage Tips

    Contents:

    • LANDESK(R) MANAGEMENT SUITE V2.X: REPORTTOOL USAGE TIPS
    • SQL DATABASE SUPPORT
    
    

    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