Solved

Crystal Reports .NET

Posted on 2004-04-13
3
283 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
[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
 
LVL 2

Accepted Solution

by:
JaniceLaw earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

A short article about a problem I had getting the GPS LocationListener working.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Starting up a Project

691 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