AnsweredAssumed Answered

Create a Single Report with Lists of Records from Multiple Unrelated Tables

Question asked by evanscl on May 12, 2014
Latest reply on May 14, 2014 by evanscl

Title

Create a Single Report with Lists of Records from Multiple Unrelated Tables

Post

     How do you create a single report that list records from multiple unrelated tables?

     I want to display records from four unrelated tables: Bird, Veterinary, Human, and Vector. 

     I want to display four lists on the report where [Diagnosis is not equal to "Negative"], and each list is sorted by Diagnosis, County, City, and DateOnset:

         
  1.           Bird: CaseIDN, Diagnosis, CaseStatus, County, City, ZIPcode, Species, DateOnset
  2.      
  3.           Veterinary: CaseIDN, Diagnosis, CaseStatus, County, City, ZIPcode, Breed, DateOnset
  4.      
  5.           Human: CaseIDN, Diagnosis, CaseStatus, ClinicalSyndrome, BloodDonor, County, City, ZIPcode, DateOnset
  6.      
  7.           Vector: CaseIDN, Diagnosis, CaseStatus, County, City, ZIPcode, Species, DateOnset

      

     I also want to display a fifth list from the Human Table, which is sorted by Diagnosis, CaseStatus, and ClinicalSyndrome:

         
  1.           Human: CaseIDN, Diagnosis, CaseStatus, ClinicalSyndrome, BloodDonor, ImportedFrom, CountryOfOrigin, County, City, ZIPcode, DateOnset

      

---Begin Report---

      
Arboviral Activity in Birds, Animals, People, and Mosquitoes
(Listed by Type, Diagnosis, County, City, and DateOnset)
                                                                                                                                                                       
          
          Animals
                    CaseIDN                     Diagnosis                     CaseStatus                     County                     City                     ZIPcode                     Breed                     DateOnset
                                                                                                                                                                                                                                                                                                                             
          
          Birds
                    CaseIDN                     Diagnosis                     CaseStatus                     County                     City                     ZIPcode                     Species                     DateOnset
                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                                                                             
          People
                    CaseIDN                     Diagnosis                     CaseStatus                     ClinicalSyndrome                     BloodDonor                     County                     City                     ZIPcode                     DateOnset
                                                                                                                                                                                                     
                                                                                                                                                                                                                                                                                                                             
          Mosquitoes
                    CaseIDN                     Diagnosis                     CaseStatus                     County                     City                     ZIPcode                     Species                     DateOnset
                                                                                                                                                                               
      
Arboviral Activity in People
(Listed by Type, Diagnosis, Case Status, and Clinical Syndrome)
                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                   
                    CaseIDN                     Diagnosis                     CaseStatus                     ClinicalSyndrome                     BloodDonor                     ImportedFrom                     CountryOfOrigin                     County                     ZIPcode                     DateOfOnset                      
                                                                                                                                                                                                                                                 

--End Report--




      

Outcomes