Report with Horizontal / Vertical group

[Saeed]

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?

 

           

[Stef]

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