如何通过Pentaho Report Designer跨越字段中的值？(How can I across the values in a field by Pentaho Report Designe

如何通过Pentaho Report Designer跨越字段中的值？(How can I across the values in a field by Pentaho Report Designer?)

我是初学者..我想知道Pentaho报告设计师如何跨越一个领域的价值观？ 它支持这个吗？ 像这样：在数据库中

name id a 1 a b c b 2 to 1 2 3 c 3

谢谢 ：）

I am a beginner.. I want to know how can I across the values in a field by Pentaho Report Designer? Does it support this? Like this : In Database

name id a 1 a b c b 2 to 1 2 3 c 3

THX :)

最满意答案

是的，您可以在最前沿的Pentaho报告中执行此操作，请参见此处：

http://www.on-reporting.com/blog/a-quick-introduction-to-crosstabs-in/

另一种方法是，如果您的数据可以在Mondrian架构中建模，那么使用OLAP输入数据源，您可以根据自己的需要调整数据！

最后的选择 - 根据建议使用Kettle选项。

Yes, you can do this in the cutting edge Pentaho reporting, see here:

http://www.on-reporting.com/blog/a-quick-introduction-to-crosstabs-in/

Another alternative is if your data can be modelled in a Mondrian schema then use the OLAP input data source and you can pivot your data however you see fit!

Last Alternative - use the Kettle option as suggested.