I am working with basketball stats (girls high school – many seasons). I have 3 queries that I ‘need’.

(a) v1 – list of girls with sisters that have played – varsity, reserve and/or freshman

(b) v21 – list of points scored by individuals at the varsity level

(c) v31 – list of points scored by the sisters combined

Each query includes a sister_code.  (Most of the players do not have a sister_code)

I have created a report showing the (i) code, (ii) Last name, (iii) total points and (iv) number of sisters.

I am (trying) to create/link a subreport to each detail line of my report that then shows the scoring for each of the individual sisters.  (When I am finished the sister_code will NOT be visible.)

My ‘ideal’ report will look like:

Most points scored by sisters at the varsity level

Sis_code    Name                    Points             Sisters

Smi            Smith                     2500                 3

      Smi               Amy Smith         1200        1984-87

     Smi               Beth Smith            900        2000-02

     Smi               Chris Smith           400         1992-95

JL              Jones                    2200                  2

     Deb Jones           1300         2007-10

     Ellie Lopez             900         2013-16    

Right now I get my report to print ‘nicely’.  But, my sub-report prints all of my 60 sisters, not just the 2 or 3 from the detail.

Yes, my sub-report is the reports detail part.  BUT I have not done anything to limit(link) my sub-report.  What do I need to do?

​I am working with basketball stats (girls high school – many seasons). I have 3 queries that I ‘need’.(a) v1 – list of girls with sisters that have played – varsity, reserve and/or freshman(b) v21 – list of points scored by individuals at the varsity level(c) v31 – list of points scored by the sisters combinedEach query includes a sister_code.  (Most of the players do not have a sister_code)I have created a report showing the (i) code, (ii) Last name, (iii) total points and (iv) number of sisters.I am (trying) to create/link a subreport to each detail line of my report that then shows the scoring for each of the individual sisters.  (When I am finished the sister_code will NOT be visible.)My ‘ideal’ report will look like:Most points scored by sisters at the varsity levelSis_code    Name                    Points             SistersSmi            Smith                     2500                 3      Smi               Amy Smith         1200        1984-87     Smi               Beth Smith            900        2000-02     Smi               Chris Smith           400         1992-95JL              Jones                    2200                  2     Deb Jones           1300         2007-10     Ellie Lopez             900         2013-16    Right now I get my report to print ‘nicely’.  But, my sub-report prints all of my 60 sisters, not just the 2 or 3 from the detail.Yes, my sub-report is the reports detail part.  BUT I have not done anything to limit(link) my sub-report.  What do I need to do?  Read More

​