I have a report design in crosstab. the layout would like the following:
| 12-1-2010 | 13-1-2010 | ....
Product A | 10 | 20 |
Product B | 15 | 16 |
My product A, B is not taken from table, is hardcoded, But how do I make it that the values 10 fall under date 12-1-2010 and within Product A. 15 belongs to Product B and fall under 12-1-2010?
I have the following data stored in table:
Date Qty
12-1-2010 10
12-1-2010 15
13-1-2010 20
13-1-2010 16
any idea, thanks in advance
Edited by: Renee123 on Feb 20, 2011 5:43 AM
Edited by: Renee123 on Feb 20, 2011 5:46 AM