Solved

rename data in crystal reports

Posted on 2009-04-07
2
190 Views
Last Modified: 2012-05-06
This is quite a basic question so i'm sorry, i know how to do this in basic but my programming isn't brilliant beyond that.

I have a field Project Type {ProjectIMAPIView.Field37166}

which is either Highly Probable, Probable, Prospect or Business Development

The report that I am creating sorts by this field in the order as above. I would also like to display which record belongs to which group but would prefer for the words to be abbreviated

Highly Probable = HB
Probable = PR
Prospect = PS
Business Development = BD

How can I do this?

Thanks Ed.
0
Comment
Question by:edmacey
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 24085908
You just need a formula field which derives the abbreviation and add it to your detail line.

If {ProjectIMAPIView.Field37166}= "Highly Probable" then
"HP"
else if {ProjectIMAPIView.Field37166}= "Probable" then
"PR"
else if {ProjectIMAPIView.Field37166}= "Prospect" then
"PS"
else if {ProjectIMAPIView.Field37166}= "Business Development" then
"BD"
else
"N/A"


0
 

Author Closing Comment

by:edmacey
ID: 31567430
Brilliant, thank you, I tried something like that but couldn't get it to work, I feel slightly like a numskull. Ed.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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 …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now