?
Solved

Crystal Reports .NET

Posted on 2004-04-13
3
Medium Priority
?
287 Views
Last Modified: 2010-05-18
Hello Expert,
I am using Crystal Reports .NET and C#.NET windows application and I am filling my report with a dataset from a datagrid I was wondering if there is anyway in crystal reports to say if JobID is 1 then dont' display the number 1 but the word Picking and if 2 then displayt he word assembly. Is that possible?
Thanks for your help
0
Comment
Question by:jvoros1
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
JaniceLaw earned 2000 total points
ID: 10813914
Try using adding a new formula field to your report and use the following as the formula.

Switch ({JobID}=1,"Picking",{JobID}=2,"Assembly")
0
 

Author Comment

by:jvoros1
ID: 10814612
When I try that it says error in formula would you know why?
0
 

Author Comment

by:jvoros1
ID: 10814630
I got it thanks i had to put the table name in too tbl_DaysBuildSheet.JobID Thanks for your help
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

850 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