We have an  Entity Attribute Values (EAV) database, which basically means we have a table with lots of rows, instead of lots of columns.  The software is sort of a long questionaire, with a persons responses being stored in this database.  So instead of a table with tons of columns each one representing a particular question, we have rows, and a id number that maps to another table that tells you the question.  So looks something like this:

ID        Value 

314    11/16/1967
317    111-11-1111
318    1 Main St
319    Apt 23
320    Podunk
321    IA
322    33445
323    802-867-5309
 

The ID value references another table which tells me what the particular question is.  For a report I want to grab answers to a certain question, and put it in a certain place on the report.  So birthday (id = 314) might go at top, phone number (id = 323) might go somewhere else, etc. I tried creating a formula field, taking value of field Value if ID = 314, but doesn't seem to work.  Only value I get is first one I come across (say birthday) and none of the others have anything. 

Any ideas how this might be able to work?

I'm using Crystal Reports 8.5.  I know that's old, but there's some reason that we need to use this version.

Thanks!