Grouping within table item

4 posts, 0 answers
  1. Gerd
    Gerd avatar
    2 posts
    Member since:
    Mar 2015

    Posted 25 Mar 2015 Link to this post

    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
  2. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 30 Mar 2015 in reply to Gerd Link to this post

    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.
  3. Gerd
    Gerd avatar
    2 posts
    Member since:
    Mar 2015

    Posted 30 Mar 2015 in reply to Hinata Link to this post

    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
  4. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 01 Apr 2015 in reply to Gerd Link to this post

    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.
Back to Top