How to set DataTable as DataSource to report

3 posts, 0 answers
  1. Raka
    Raka avatar
    71 posts
    Member since:
    Sep 2011

    Posted 07 Jan 2016 Link to this post


    I have a DB table that looks like --

    Type     SubType   Count

    A                            5

    B                            10

    C           C1             4

    C           C2             2

    D                             1

    E                            100


    I want to show the report as --

    A: 5                             B: 10

    C:                                D: 1

         C1: 4

         C2: 2

    E: 100


    Preferably I would like to do this w/o creating a wrapper for the table.

    How can I do it?

    Thanks, Raka

  2. Stef
    Stef avatar
    3611 posts

    Posted 11 Jan 2016 Link to this post

    Hello Raka,

    Please test adding a group by Fields.type in the Table item. For more details, check Grouping Data.
    You can also add a group by Fields.SubType before adding the outermost group by Fields.Type.

    An example of grouping data via Table item is illustrated by the Product Sales demo, available also in the local examples under C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples.

    I hope this information is helpful.

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Raka
    Raka avatar
    71 posts
    Member since:
    Sep 2011

    Posted 11 Jan 2016 in reply to Stef Link to this post

    Yes, it does.  Thank you very much.


Back to Top