[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

substring in crystal reports 2008 formulas

Posted on 2010-08-16
3
Medium Priority
?
4,599 Views
Last Modified: 2012-05-10
hi

i want only the 3 first characters in my report , i use formulas but have an error
i have this
for this field
BCCDAHFFD
left({P1011.codigo},1,3)
the result i need
is BCC
thank you a lot
0
Comment
Question by:Ernesto
[X]
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
  • 2
3 Comments
 

Author Comment

by:Ernesto
ID: 33446961
or

mid({P1011.codigo}1,3)
but give me an error
0
 
LVL 12

Accepted Solution

by:
JayConverse earned 2000 total points
ID: 33446963
left({P1011.codigo},3)

or

mid({P1011.codigo},1,3)
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 33446972
What's the error?  Is {P1011.codigo} a string?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

650 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