Solved

Crystal Reports: One field - multiple names

Posted on 2014-02-19
1
263 Views
Last Modified: 2014-02-19
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
Comment
Question by:CAHFS
1 Comment
 

Accepted Solution

by:
CAHFS earned 0 total points
ID: 39872138
Never mind. I created two views and solved the problem :) Yay me!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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