Joined: 18 Feb 2008
Location: United States
Online Status: Offline
Posts: 2
Topic: Exists Posted: 18 Feb 2008 at 3:13pm
I need to identify rows in a table for a certain studyid that have a rows existing with the value of CPT or no rows existing with a value of CPT. How can this be done in Crystal Reports? Thank you for the help!
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 19 Feb 2008 at 10:48pm
Yes, you can identify this information. But how do you plan on using this identification? Will you be using it in a calclulation or simply highlighting the rows with different colors? Having a little more info will make it easier to know how to answer the question.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 18 Feb 2008
Location: United States
Online Status: Offline
Posts: 2
Posted: 20 Feb 2008 at 8:21am
Thanks for the response. I just want these rows to be on the report. They will not be color coded or used in a calculation. I'm having a hard time figuring out how to tell Crystal to return rows for a particular id that have a value of CPT in a column, and also return that same id when there are no rows with the value of CPT.
So, here's an example:
ID CODE
1 CPT
2 EXE
2 PTD
3 CPT
I want to return id's 1, 2 and 3. 1 and 2 since they have a code of CPT and 2 because it doesn't have a code of CPT.
This is a very simple example but hopefully it helps explain things a little bit better.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
