Solved

Crystal Reports .NET

Posted on 2004-04-13
3
282 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
A short article about problems I had with the new location API and permissions in Marshmallow
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 …

730 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