• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Crystal Reports: One field - multiple names

I have a table called SOURCE_EXTID for external ID's and their types. The two fields I'm trying to use are ID and TYPE.  

One sample that comes in can have multiple ID types and values. When the techs enter the info on the sample, the have a drop down list to choose as many types as they need eg. Ear Tag, Brand, Patient Ext. ID, QA Number, Name, etc.
So, my SOURCE_EXTID.type can have one, none, or multiple values that I then need to match up to the actual ID.

On my report, i have two groups from other tables FOLDERNO which gives me the case number that sample is in and then ORDNO which gives me that specific sample info.
Now I need to create multiple columns, specifically where SOURCE_EXTID.TYPE = 25 (name) and one for SOURCE_EXTID.TYPE = 26 (QA Name) and then show it's matching ID's.

I created a formula for one of them that looks like this:
IF {SOURCE_EXTID.TYPE} = 25 THEN {SOURCE_EXTID.ID} ELSE " "

thinking it would show it but it's just staring at me completely blank.  I've placed it on the group header, the footer, and I get nothing. I thought about adding a crosstab but this is going to be exported to Excel so I can't have too much formatting going on.

Any ideas?
0
CAHFS
Asked:
CAHFS
1 Solution
 
CAHFSAuthor Commented:
Never mind. I created two views and solved the problem :) Yay me!
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now