Crosstab reporting problem

[John]

Hi

I have a report bound to a crosstab query. The problem is that under
different conditions crosstab returns different column headings. This causes
problems with binding of fields on report. Is there any way to make the
column headings fixed in the crosstab query so the field names can be bound
to report fields without problem?

Thanks

Regards

 

[Jeff C]

Open your crosstab in design view and open the properties of the
crosstab

There is a column properties that allows you to force your row headings
ie:

"01";"02";"03";"04";"05"; etc etc