I have created a CrossTab Query which displays correctly in Datasheet View.
When I create a Report based on this query it displays correctly (see attached SubReportDesignView.gif and SubReportReportView.gif).
However I wish to add this Report to my Main Report (i.e. make it one of several Sub-Reports appearing on the Main Report).
When I create my Main Report and drag and drop the Sub-Report onto it, the column headings disappear (see attached MainReportDesignView.gif and MainReportReportView.gif).
Please does anybody know what is going on here?
I am a newbie and desparately short of time to get this project completed.
Please help.
Thank you.
When I create a Report based on this query it displays correctly (see attached SubReportDesignView.gif and SubReportReportView.gif).
However I wish to add this Report to my Main Report (i.e. make it one of several Sub-Reports appearing on the Main Report).
When I create my Main Report and drag and drop the Sub-Report onto it, the column headings disappear (see attached MainReportDesignView.gif and MainReportReportView.gif).
Please does anybody know what is going on here?
I am a newbie and desparately short of time to get this project completed.
Please help.
Thank you.