Questions & Answers
How helpful is this to you?
Kace K1000 Management Appliance
KACE Product Support
I have created a report but I cannot seem to define the column lengths, so the summary field takes up most of the width of the report.
Can I set the column width for reports?
[ - ] Hide Comment
1 year ago
FYI: as a way to avoid this in my environment I truncate HD_TICKET.SUMMARY like this:
CONCAT(LEFT(HD_TICKET.SUMMARY,64),"\[...\]") as 'Summary'
Then the column will only include the first 64 chars of the Summary field
Answer this question
on this question for clarity
if you create with sql vs the wizard yes. You can also take a wizard report and view it as sql, copy the code and then just modify it for the widths you want and create a new report with that code
Answered 05/13/2016 by:
Don't be a Stranger!
Sign up today to participate, stay informed, earn points and establish a reputation for yourself!
I need help writing a SQL report to show all tickets INCLUDING any tickets in the archive.
Any Hope of Continuing to Use the K2000 with High Sierra/SSDs/APFS?
Opening KACE Service Desk in Multiple Browsers
Helpdesk Ticket All history report
Windows 10 Computers not Showing in Inventory
K1000 Ticket Report: Tickets that were raised for a months period
Auto Assign a user to an asset pt2
K1000 Management Appliance Documentation
K1000 Management Appliance Support
K1000 Management Appliance Product Page
IT certification gives federal job seekers an edge
K1000 UserVoice Feedback Forum
ITNinja Feedback Forum at UserVoice
KACE Extends Leadership in Systems Management Appliances with Significant KBOX 1000 Series Upgrade
KACE Takes The Sting Out of 2007 Daylight Saving Time Changes
KBOX Systems Management Appliances Updated With Solaris Support, New Security Policies and Easier Agent Deployment
Education Market Manages Networks with KACE
New KBOX Appliances Bring Enterprise-Grade, Cross Platform IT Automation to Mid-Market
KACE Launches New Help Desk Module For Upgraded KBOX IT Management Applicance
Managing Dell Servers with the Dell KACE K1000 and Dell Open Manage
K2000 KBE Manipulator and Clonezilla