Can't use a non-fixed-column crosstab query as subreport

[KidC]

Hi,

I see this topic has been discused a few times but I couldn't find help for a solution to my problem.

My main report has multiple records (Models) and I need the subreport to change for each Model. I linked the Parent and Child fileds (Model) to try to achieve this but got the above error message when I ran the main report.

My subreport has and needs dynamic headings so fixed column headings is not an option but I need the subreport to change values everytime the main report changes records.

I used the code example from the MS Support Page (

http://support.microsoft.com/kb/328320)

to create my dynamic Crosstab Subreport.

I tried to delete the Parent and Child relationship but (as I knew would happen) the subreport now displays all records for every record on the main report.

I could add a parameter to my subreport crosstab query based on my main form to filter both the main and sub reports to print one record at a time but I want the main report to be able to print all records at the one time.

Can anyone please help me with a workaround solution. I'm stumped.

Big Thanks,
John

 

[dhookom]

The Crosstab has a solution that should work for you.

Duane
Hook'D on Access
MS Access MVP