[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

substring in crystal reports 2008 formulas

Posted on 2010-08-16
3
Medium Priority
?
4,817 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
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 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