Any help with this would be greatly appreciated.
I am trying to create a report for construction projects schedule. The format of the report the date of work as columns and resources(i.e. Carpenter name, Plumber name, Electrician name) as columns. The data to be displayed is the job name under the right resource and date.
My problem is my columns are not fixed. I tried creating a cross tab query, but I could not get the actual value of the job name to print, it seems only an aggregate value can be used for the data in a cross tab.
Anyone have any other suggestions?
I am trying to create a report for construction projects schedule. The format of the report the date of work as columns and resources(i.e. Carpenter name, Plumber name, Electrician name) as columns. The data to be displayed is the job name under the right resource and date.
My problem is my columns are not fixed. I tried creating a cross tab query, but I could not get the actual value of the job name to print, it seems only an aggregate value can be used for the data in a cross tab.
Anyone have any other suggestions?
