Creating a report on the fly

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

Guest

In a group footer section on a report, I have an ID that I need to create a
subreport for. The subreport is based on a cross-tab query. And since the
results of the query will change based on that ID I need to be able to create
a subreport on the fly. The number of controls for the report will change
from one query result to the next which is why I cannot predefine the report
to access. If someone can please direct my search for an example of creating
reports on the fly, I would appreciate it. Thank you
 
What you're looking for is called a "dynamic" crosstab, where the number of
rows and columns will vary.
I've used the dynamic crosstab method found in the old Microsoft
Sample97.mdb, but there are many methods out there.
Try
http://www.invisibleinc.com/download.cfm?filFilID=8
Or try a web search on...
microsoft access "dynamic crosstab"
hth
Al Camp
 
Back
Top