/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Report Formatting

05/12/2016 761 views
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?
1 Comment   [ + ] Show comment

Comments

  • 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

All Answers

0
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: SMal.tmcc
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ