Solved

Crystal Reports: One field - multiple names

Posted on 2014-02-19
1
272 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

636 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