dynamic crosstabs as subreports

[dmeehanjr]

I'm trying to link 2 dynamic crosstabs as subreports (Sales and Purchases) by Product Id, but get error that cannot do using dynamic crosstabs. (Number of column data can change, depending on user selection - also column names based on monthly data)

Found a solution for Forms - using dynamic crosstabs as subforms - but not sure how to handle totals, as subforms are in datasheet format. (Duane Hookum solution to use dynamic crosstab as subforms).

any help appreciated!

thanks,

Don