Jeff21
November 10th, 2009, 02:14 PM
I am looking to create a CR that displays data in vertical columns. I have 50 stores that all carry the same product and I want to display the price or inventory. I want the item list to appear down the left, stores across the top and results to appear in the cells. There may be instances of NULL values.
. . . . . . . . . Store 1 . . . Store2
Product 1 . . . . . 3 . . . . . 3.5
Product 2 . . . . . 2 . . . . .
Product 3 . . . . . 1 . . . . . 1
Initially, I thought a crosstab would work. However, I am finding it too limiting with regards to formatting and presentation. Additionally, I seem to have less control over how pages break, etc.
I have attempted to use the feature FORMAT WITH MULTIPLE COLUMNS, but I cannot seem to get it to work for multiple headers - it seems to want to wrap the text. Perhaps I am not grouping the data in the columns properly?
Is the crosstab the ONLY way to get the Header and Details to align?
Thoughts or comments greatly appreciated.
Thanks!
. . . . . . . . . Store 1 . . . Store2
Product 1 . . . . . 3 . . . . . 3.5
Product 2 . . . . . 2 . . . . .
Product 3 . . . . . 1 . . . . . 1
Initially, I thought a crosstab would work. However, I am finding it too limiting with regards to formatting and presentation. Additionally, I seem to have less control over how pages break, etc.
I have attempted to use the feature FORMAT WITH MULTIPLE COLUMNS, but I cannot seem to get it to work for multiple headers - it seems to want to wrap the text. Perhaps I am not grouping the data in the columns properly?
Is the crosstab the ONLY way to get the Header and Details to align?
Thoughts or comments greatly appreciated.
Thanks!