Jeff Moden (12/2/2008)
Comments posted to this topic are about the item
Thansk for a nice articles on Cross-Tab.
I have one report format which is related to Dynamic Cross Tab report.
In which I am extracting data in row wise and designing it in fornt end like cross tab.
Can I directly desing that report in Cross-Tab in Query itself..
The for of report is as follows..
I have to show Sale of Item week wise...Which are group by their item group.
ItemGroup ItemCode Sale_Week40 Sale_Week_41 Sale... Total
1001 101 50 45 95
1001 102 10 50 60
1001 103 5 2 7
SubTotal of Item Group 65 97 162
Can I do above format report in SQL with good performance..?