Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Len of many fields & add them up

Posted on 2013-05-22
3
242 Views
Last Modified: 2013-05-22
is there a way take fields in my report, figure out the Len() of them, then add them all to gether to get the total number of characters for those fields.

For Example:
len(trade.settle) + len(trade.maturity) + len(trade.days) +len (trade.name) + len(trade.address) + etc = total characters
0
Comment
Question by:IO_Dork
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39189242
Exactly like that

Create a formula
Name - TotalLength
Length({Trade.Settle}) + Length({trade.maturity}) + Length({trade.days}) + ...

mlmcc
0
 

Author Comment

by:IO_Dork
ID: 39189372
I tried that, but got an error..."expects string"
0
 

Author Closing Comment

by:IO_Dork
ID: 39189649
it worked...I was trying to use the function len() instead of length().  Thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question