Suppressing a repeating column.

2 posts, 0 answers
  1. John
    John avatar
    7 posts
    Member since:
    May 2013

    Posted 04 Feb 2014 Link to this post

    How do you suppress a repeating column in a report?

    My report currently looks like this:

    SalesPerson  Product Quotes 
    John   Cars 68 
    John   Vans 25 
    June   Cars 45 
    June   Cycles 22 
    June   Trucks 17 
    Tim    Trailers 16 
    Tim    Cars 45 
    Tim    Vans 12 
    Tim    Tractors 25 

    I wish to suppress the name of the salesperson so that it looks like this:
    SalesPerson  Product Quotes 
    John   Cars 68 
              Vans 25 
    June   Cars 45 
              Cycles 22 
             Trucks 17 
    Tim    Trailers 16 
         Cars 45 
         Vans 12 
         Tractors 25 

    What feature of the report designer allows me to do this? I have tried some grouping actions and it has not worked.



  2. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 07 Feb 2014 Link to this post

    Hello John,

    To suppress the duplicate SalesPerson values you will need a Table item and appropriate grouping:
    1. Use the Table Wizard to add a new table.
    2. In the "Arrange fields" window drag the Product and Quotes fields to the Columns area and click next/finish until the end of the wizard.
    3. Select the table and open the Group Explorer window.
    4. Bring up the context menu of the (Detail) group and add a new parent group.
    5. Add a new expression in the Table Group window, which will group by the SalesPerson field and click OK.

    Another approach is to use filtering to suppress rows with a repeating SalesPerson. Then in order to show the full list of Product and Quotes you need to nest another Table inside the parent Table and bind its DataSource property to the parent's DataObject, as described in the How to use the ReportItem.DataObject property in expressions help article.

    Regards,
    Nasko
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

  3. DevCraft banner
Back to Top