Using same subreport pointing to different queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed four different queries (one for each quarter) that display
the data I want. I have created a subreport for the first one, and since
they are all the same (I might change the others later to work all in vb, but
baby steps), I would like to use the same subreport, but use VB to change the
data source of the subreport for each of the four instances on my main
report. Does this make sense and how do I do it?

On the main report, I have copied the subreport 3 more times, so they are
named child36, child37, child38.
 
Why four different queries as opposed to a single query with a column/field
for the quarter? You can then use the Link Master/Child properties to link
the quarter field to a bound "quarter" field in your main report.
 
Back
Top