Adjusting width of columns in a LiveReport

Dan_Duffy

How can I adjust with width of the columns in a LiveReport?Some of the columns in the tables have a lot of characters in them. I want to limit the width of the results to about 30 characters. If stuff is truncated that is no big deal.

Bhupinder_Singh

Message from Bhupinder Singh via eLinkYou could try using the substring function in your SQL. For example, "selectsubstr(name, 1, 10), dataid from DTREE" in a LiveReport will display thewidth of the name column with a maximum of 10 characters.To display fixed width you could try something like this:select rpad(substr(name, 1, 10) , 10) "Name" , dataid from DTREEHope that helps...- Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, November 19, 2003 2:14 PMTo: eLink RecipientSubject: Adjusting width of columns in a LiveReportAdjusting width of columns in a LiveReportPosted by BofA, Developers @ on 11/19/2003 02:12 PMHow can I adjust with width of the columns in a LiveReport?Some of the columns in the tables have a lot of characters in them. I wantto limit the width of the results to about 30 characters. If stuff istruncated that is no big deal.[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe