Forum Discussion
Column headers
Hi there,
I would like to clarify my post.
I am creating a report which draws data from various VFP tables.
The main one contains information of items we currently have in the warehouse.
The report shows the style, the colors the item is available in, with the amounts currently in the warehouse, by size, with a total for each style/color.
Currently these are the column headers of my report:
What I want to see is instead of the table column headers stk0, stk1, etc, I would like to see the actual size descriptions:
As an example:
Every item has a different size scale. The item table contains a column called "scale" which shows the scale code say "A1" and the scale is PP 4 5 6 7 7X.
I want to replace the current column headers stk0, stk1, etc and replace them with the actual scale sizes.
So the report would should the headers and the quantity in stock below:
How do I accomplish the custom column headings?
Thank you in advance for any assistance.
- Ashish_Mathur3 years agoSuper User
Hi,
Remove the skttot column. Select the first 2 columns, right click on the heading and select "Unpivot Other Columns". In the Query Editor, you can now join this table with the other one which has the sizes.