Crystal Reports .NET

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
jvoros1Asked:
Who is Participating?
 
JaniceLawConnect With a Mentor Commented:
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
 
jvoros1Author Commented:
When I try that it says error in formula would you know why?
0
 
jvoros1Author Commented:
I got it thanks i had to put the table name in too tbl_DaysBuildSheet.JobID Thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.