I'm trying to make a report based on a cross tab query and I need to give alias's to my report fields as I dont know the colume heading names untill the query is run.
I've had a look and found some examples and I think I know how I'm going to do it but I'm stuck on the folowwing problem. I need to generate a alias name colum from a query or some other. Say 1 to how ever many number of records the query returns or maybe A, B, C etc. Whats the easiest way to do this.