您可以根据需要使用交叉表报告.

使用Crystal Reports在Visual Studio 2005中创建交叉表报表 [使用PIVOT和UNPIVOT [

You can use crosstab reports for your requirement.

Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports[^]

Also you can do that by Using PIVOT and UNPIVOT[^] in SQL server.

我解决水晶报表所有问题的方法是使用记录集.

将记录集从Sql Server或另一个表结果解析为Crystal报表非常容易，您可以在将其发送到打印机之前选择所需的对象.

如果我没看错您的问题，请尝试一下，它将解决您的所有问题.

my way to solve all issues with crystal reports is to work with recordsets.

Its very easy to parse a recordset from Sql server or another table result to crystal report and you can select wathever you want before to send it to the printer.

if im reading your question right, try it, it will solve all your problems.