Grouping within table item

[Gerd]

Hi,

I'm using the table item to display a simple table with columns A and B:

Column A     Column B
Value_A_1   Value_B_1
Value_A_1   Value_B_2
Value_A_1   Value_B_2
Value_A_2   Value_B_4
Value_A_2   Value_B_5
Value_A_2   Value_B_6

I'd like the report to look like this:
Value_A_1
     Value_B_1
     Value_B_2
     Value_B_3
Value_A_2
     Value_B_4
     Value_B_5
     Value_B_6

If I use a row group grouping by Column A the report looks like this:
Value_A_1  Value_B_1
                   Value_B_2
                   Value_B_3
Value_A_2  Value_B_4
                   Value_B_5
                   Value_B_6

If I use a column group grouping by Column A the report looks like this:
Value_A_1
     Value_B_1
     Value_B_2
     Value_B_3

<Pagebreak>
Value_A_2



     Value_B_4
     Value_B_5
     Value_B_6

Why it does a page break after each group and why it displays the emtpy lines in group Value_A_2?

Best regards,
Gerd

[Hinata]

Hi Gerd,

The desired layout can be achieved using grouping in the report (Table is not needed).
Place the detail value inside the Detail section. Add a group by the Value_A field, then place the Value_A field in a text box in the Group Header section.

[Gerd]

Hi Hardik,

The problem is that I have to use a table since the data is passed by an external application, which a requires a table with a certain name. Is there a way to achieve the layout with a table?

Regards,
Gerd

[Hinata]

Hi Gerd,

Not that I'm aware of. This is why you have a tabular (grid-like) layout for arranging data similar to an Excel sheet.
Then you have a band report layout which uses report sections and can be used to achieve the tree-like structure which you require.
The application which retrieves the data for the data source requiring a Reporting.Table item is a bad practice.
However you can create an empty Table item with only a name set to it, pass it to the application and then get the Table.DataSource of the returned Table object.