Normal Topic Truncating field data in a columnar report (Read 644 times)
Rob
Member
*
Offline



Posts: 6
Joined: Mar 3rd, 2015
Truncating field data in a columnar report
Mar 3rd, 2015 at 6:22pm
Print Post Print Post  
I would like to truncate the field data in a report and limit it to the pixel width of the column. Right now it word wraps within the column width leading to confusing spaces between the rows.

The corresponding report Q&A Column/Sort Spec option was (TR). Does Sesame2 V2.6 personal allow for field truncation with reports?

If so, what would be the protocol to provide the truncation.

Thanks
Rob
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Truncating field data in a columnar report
Reply #1 - Mar 3rd, 2015 at 10:48pm
Print Post Print Post  
I'm pretty sure Sesame does not have an equivalent to the TR option. You'd probably need to use @Left() to limit the number of characters.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Rob
Member
*
Offline



Posts: 6
Joined: Mar 3rd, 2015
Re: Truncating field data in a columnar report
Reply #2 - Mar 4th, 2015 at 4:51pm
Print Post Print Post  
Carl,

That works.

The @left () will give me the control I need to limit field length. The program code used is as follows:

Within the Sesame 2 Designer Reports, Navigate to
Program Layout, Select - in my case "Company_" from the Element List, Event - "On-Print".

In the Programming Box enter

Company_ = @left(Company_,20)

This limits the Company name to the first 20 characters.

Now. it just a matter of adjusting the the rest of the report to line up properly.

Thanks for your help. I was stuck on this.

Rob
  
Back to top
 
IP Logged