This is a migrated thread and some comments may be shown as answers.

How to set DataTable as DataSource to report

2 Answers 135 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Raka
Top achievements
Rank 1
Raka asked on 07 Jan 2016, 08:52 PM

Hello

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 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 11 Jan 2016, 10:31 AM
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.

Regards,
Stef
Telerik
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
0
Raka
Top achievements
Rank 1
answered on 11 Jan 2016, 04:42 PM

Yes, it does.  Thank you very much.

Sandhia

Tags
General Discussions
Asked by
Raka
Top achievements
Rank 1
Answers by
Stef
Telerik team
Raka
Top achievements
Rank 1
Share this question
or