Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Reports: One field - multiple names

Posted on 2014-02-19
1
Medium Priority
?
276 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
[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
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

670 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