AnsweredAssumed Answered

dropdown filter field in sub-summary report.

Question asked by synergy46 on May 13, 2009
Latest reply on May 14, 2009 by philmodjunk

Title

dropdown filter field in sub-summary report.

Post

I have 2 tables:

 

Patients:

  PatiendID.pk

  PatientName

    etc

 

Tests:

  TestID.pk

   PatientID.fk

 

Patients is 1 to many into Tests.

 

I have a sub-summary report that breaks on PatientName, then on TestName then on Date.  It works well.  But it shows ALL patients.

 

What I want:  I want to have a popup in the Header that will show the Patient name and when a patient is selected, the report will show ONLY that patient. 

 

I have been doing this kind of report by:  opening the Test layout, getting the Patient Name from the popup, Finding that name (which produces a 'found set' of just that name', then going to the report.   This works.

 

But, this method seems unnecessarily complicated.   I would like to hear from other developers about better methods to do the same thing.

 

Thanks for your ideas.

 

ron

 

Outcomes