Data appearing on multiple lines 1

[Meg09]

Hi,

I am working on a report where I am pulling data from a patient's chart. I need to pull 1) a yes or no answer to a question & 2) if yes to first question, then the type of equipment. Problem is, both values for question #1 & #2 are the same field. The way I can distinguish them is by another field, which is type. I am obtaining the data for both questions, however the answer to question #1 appears in one line and then the answer to question #2 appears in a separate line below. Is there a way to have both answers to both questions appear on the same line?

My current data shows as:

Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes
Mr. Smith 1234567 1/1/2013 Walker

I would like to appear as:

Patient Account Number Date Question #1 Question #2
Mr. Smith 1234567 1/1/2013 Yes Walker

Any help would be greatly appreciated.

Thanks,
Meg

 

[IanWaterman]

Group by account number move all fields except question into group footer, suppress group header and details

Create two formula

@Question1
If QuestionType = 1 then answerfield else ''

@Question1
If QuestionType = 2 then answerfield else ''

Add Maximum summaries of these two formual to the group footer

Ian

 

[Meg09]

Thanks Ian. Only other step I had to add was to group by visit date as many of the patients had multiple visits and I needed to report their equipment for each visit. Thanks again!