如何在Crosstab中ungroup rows

最近在研究报表开发, 因为Crosstab通过使用table space做成list的样式在导出CSV的时候必定会出现格式问题,所以希望在导成Excel的时候希望数据都是平铺而非merge的, 以下是网上搜到的资料

Generic Solution:

Your crosstab looks like this:

   Corner               | <#Columns#>

-----------+------------+------------

<#Node 1#> | <#Node 2#> |    <#1234#>

Drag two crosstab spaces directly before the Columns, and in the new intersections set Define Contents to Yes. By default these items won't have column titles, but for the purpose of this demonstration I'm calling them Space 1 and Space 2

   Corner               | Space 1 | Space 2 | <#Columns#>

-----------+------------+---------+---------+------------

<#Node 1#> | <#Node 2#> |         |         |    <#1234#>

Unlock the report and drag a text item into intersections of Space 1 and Space 2. You don't need to type anything into them. Click on the text item in the intersection of Space 1 and change the Source Type to Data Item Value. Set the Data Item Value to Node 1. Do the same for the Intersection with Space 2.

Finally click on the Crosstab Corner and set Box Type to None. Click on the rows, select anscestor -> Crosstab Rows and set Box Type to None.

If these instructions made any sense your crosstab should look like this now:

 Space 1  | Space 2  | <#Columns#>

----------+----------+------------

 <Node 1> | <Node 2> |    <#1234#>