Crosstab query results as a subreport

[tquigley]

I am trying to build a report that takes a basic query and links a cross tab
query to it for each row in the original query.

More specifically I have an original query that returns 52 records related
to certain mergers and acquisitions that have happened over the last 30 or so
years. Each record has a company name for the acquiring firm and target firm
as well as a unique identifier for the acquiring firm and a year that the
deal closed.

I can easily build a report that displays this data but what I also need is
a subreport containing 7 years worth (deal year plus and minus 3 years) of
sales info by business segment for the acquiring firm. This info comes from
a table that has the following columns: unique identifier for the firm,
year, segment, sales. There are multiple segments for each firm each year
and they can change from year to year, hence the need for a crosstab query.
I am limiting it to +/- 3 years from the year the deal closes so at least I
have a fixed number of columns in the cross tab.

Any recomendations on how to make this happen?

Thanks!
Tim

 

[Jeff C]

Try dropping your crosstab query into a new query and adding all those
fields, then properly join this new query to your other datasource for your
subreport