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?
[ + ] Show Comment
9 months 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
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:
Answer this question
on this question for clarity
Don't be a Stranger!
Sign up today to participate, stay informed, earn points and establish a reputation for yourself!
K1000 inventorying remote machines
How do we create a KACE 1000 login script that runs as the current user?
Service Desk Rule to include last comment or all comments
Problems with Quest support
K1000 7.0 No longer respecting "Also restrict by device label" for user downloads
Having issues deploying Office 2016
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
Packaging Guide: Getting Started