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

Report with Horizontal / Vertical group

1 Answer 82 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Saeed
Top achievements
Rank 1
Saeed asked on 13 Mar 2017, 04:12 PM

I want a report like this, How much sales, for each city (vertical) in each season (horizontal) :

Cirty1                     City2                   City3
      Spring                  Spring                 Spring
      day1   1000          day1    2000        day1   3000
      day2   1100          day2    2100        day2   3100
                  ...                        ...                         ...

      Summer               Summer              Spring
      day1    1200          day1     2200      day1     3200
      day2    1300          day2     2300      day2    3300
                  ...                           ...                        ...

How can it can be built in telerik reporting?

 

           

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 13 Mar 2017, 04:42 PM
Hi Saeed,

You can use groupings on report level based on City and Season fields - How to: Add groups to Report.

Or you can use a Table item with row groups, see the attached TableGroupings.zip video in IE browser.


you can also mix report groups with Table items, where the Table item can be rotate to grow horizontally. To bind the table item to the report's data object, test the approach from Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph).


I hope this helps.

Regards,
Stef
Telerik by Progress
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
Tags
General Discussions
Asked by
Saeed
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or