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
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
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 - Windows 10 1607 Anniversary Update
System error 53 when mounting kbox install
Can K1000 detect the computer product number?
SQL help after K1000 upgrade to 7
Unable to locate usmt tools at:
Linux Agent Issue after v5.0 Upgrade
Help Desk Question
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 Launches AppDeploy Live
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