Normal Topic Truncating Columns in Report Printouts.. (Read 455 times)
kim33
Member
*
Offline


No personal text

Posts: 6
Joined: Jun 30th, 2005
Truncating Columns in Report Printouts..
Jun 30th, 2005 at 9:44am
Print Post Print Post  
Hi there everyone,

I have been trying to create a report printout for my music catalogue but I havne't been able to find a way of truncating a column. 

In the Artiste & Title column for example,  instead of the column wrapping the text to the next line I just want it to cut the text off if it's too long for the column.

In Q&A when printing out a report you could type into the Column/Sort Spec the letters TR which would truncate to fit the column.

Is there any way of doing this in Sesame?

Thanks.  ???
  
Back to top
 
IP Logged
 
Rob
Ex Member


Re: Truncating Columns in Report Printouts..
Reply #1 - Jul 1st, 2005 at 2:10pm
Print Post Print Post  
Yes, using some sbasic programming truncating is possible.   LE1 is the name of the element you want to truncate and the 14 is the number of characters that will display in that column.  You will want to put this code in the LE1 on print event.

LE1 = @Left(LE1, 14)

Rob
  
Back to top
 
IP Logged