Crosstab Size in Active Report

[LDJB81]

Hi

Third post today, this report is proving to be a challenge.

I have one crosstab in a report driven by a data deck. The file is rendered in less than a minute with a size of 6.6mb and crosstab spread out over 4 decks. I have one query driving the control and the data deck and another query driving the crosstab. There is a master detail link between then 2 queries. If I build the crosstab online and run in to excel then the file size is 48kb. There are 615 rows and 14 columns.

Is there something I am missing here? Why is this data table consuming 6.6mb? I am having a hard time explaining this to a client! I have tried using a filter instead of a data deck but the mht doesn't perform too well once its open. I thought it was charts that were the problem when it came to file size.

I have attached my debug output.

thanks
Lloyd