这个报表如何做，帮帮看看。

[PBbaby]

我有两个table A, B

Table A
prodCode Lengh Width ..
_________________________________________
P1
P2
P3
P4
....

Table B
ProdCode Accessories Accessories_quantity
______________________________________________
P1 A1 2
P1 A2 3
P1 A3 4
P2 A1 5
P2 A2 6
.....


我想得到的报表是这样

ProdCode Lengh Width A1 A2 A3
______________________________________________
P1 2 3 4
P2 5 6
.....

我该如何作? Thanks
我用的是 Crystal Report 。。。
谢

[Jneu]

用EXCEL很方便。

[PBbaby]

如果不用excel 可以吗

[siscowet]

这是一个竖表变横表的实例
sql Server 中用存储过程实现
Access 中用transform的命令实现
msdn里的一个例子

Sub TransformX1()

Dim dbs As Database
Dim strSQL As String
Dim qdfTRANSFORM As QueryDef

strSQL = "PARAMETERS prmYear SHORT; TRANSFORM " _
& "Count(OrderID) " _
& "SELECT FirstName & "" "" & LastName AS " _
& "FullName FROM Employees INNER JOIN Orders " _
& "ON Employees.EmployeeID = " _
& "Orders.EmployeeID WHERE DatePart " _
& "(""yyyy"", OrderDate) = [prmYear] "

strSQL = strSQL & "GROUP BY FirstName & " _
& """ "" & LastName " _
& "ORDER BY FirstName & "" "" & LastName " _
& "PIVOT DatePart(""q"", OrderDate)"

' Modify this line to include the path to Northwind
' on your computer.
Set dbs = OpenDatabase("Northwind.mdb")

Set qdfTRANSFORM = dbs.CreateQueryDef _
("", strSQL)

SQLTRANSFORMOutput qdfTRANSFORM, 1994

dbs.Close

End Sub

[Sean_Jhh]

打开两个表，用程序的方法判断，可能更容易理解和调试，就是笨了点。

[PBbaby]

救命呀
能不能说详细些

[PBbaby]

up