Dynamic Report

[Valdas]

Hi,

 

I'm trying to build the report out of large numeric table dynamically created of database.

It's grouped by hierarchy of 4 elements created of database dynamically. 3 Bottom levels should have total Column And calculated average column.

Sort of:

 

                                Building

                |                                |                         |              

Floor Number          Floor Number                Floor Number

|              |         |                         |                                 |             |

Room Room Room          Room                    Room          Room

||||||||||||||||           ||||                       ||||||||||||||||

Tenants                                Tenants                                Tenants


I have excel file to show the structure , but cant upload.
How can I upload excel file?


How can I build report like that?

Thank you.

[Elian]

Hi Valdas,

This can be achieved with Grouping. You can take a look at our Product Catalog Demo which uses grouping on two levels (first it groups the products by category and then by sub-category). 
Your case is similar - you will have 3 nested groups.
Building 
--> Floor Number
--> --> Room
and the tenants will be in the detail section.

PS: The allowed extensions are zip, rar, ace, jpg, gif, css, png. You can archive files in either zip or rar. 

Kind regards,
Elian
the Telerik team