How does the principal investor and the study link? Do you have a table of studies and each record has the field principal investor? Or are the two seperate tables connected by a key, if so what is the relationship?
I have a list of studies, each of which has a principal investigator. One principal investigator may have multiple studies, but one study cannot have more than one principal investigator and they are in the same table.
First, you really should have the investigator info in its own table. The studies table can should have a foreign key that references the investigator.
Second, all you have to do is basically create one report. Then if you want it for a specific investigator, all you would have to do is perform a find for that investigator (ID) in the the studies table. Thje report should always reflect your found set.