Hi Telerik,
I am new to the whole 'reporting' scene. But I'd like to layout a report that uses 2 data tables into a logical tabular format.
For example please consider the picture attached. I would like the table to grow sideways. The Subject column is data from 1 data table while the remaining property columns including adjustment columns are a flattened data table that was a result from a join.
I can't figure out how to data bind these two tables into a report table. Also I am having trouble understanding how the report will grow sideways and line up values correctly if (as the documentation suggests) I have to use a sub-report.
As you can see I'm a little bit more than confused here. Any help would be appreciated.
I am new to the whole 'reporting' scene. But I'd like to layout a report that uses 2 data tables into a logical tabular format.
For example please consider the picture attached. I would like the table to grow sideways. The Subject column is data from 1 data table while the remaining property columns including adjustment columns are a flattened data table that was a result from a join.
I can't figure out how to data bind these two tables into a report table. Also I am having trouble understanding how the report will grow sideways and line up values correctly if (as the documentation suggests) I have to use a sub-report.
As you can see I'm a little bit more than confused here. Any help would be appreciated.
2 Answers, 1 is accepted
0
Hi Craig,
To achieve a similar result as the attached image you have to flatten your data even further and join the Subject column with your other data table. Then you will be able to data bind the resulting table to a reporting table. You can read more about using tables here: Table/Crosstab/List.
As for the automatic growth of your table and adding additional "Adjustment" table columns, you can add dynamic columns to a table programmatically. I've attached a sample project that shows you how to create table dynamically (needs the AdventureWorks database).
Keep in mind that when adding columns to a table dynamically, if your table gets too wide to fit on the page it will cause a horizontal overflow and will continue on the next page. More information on the topic can be found here: Understanding Pagination
Regards,
Nasko
Telerik
To achieve a similar result as the attached image you have to flatten your data even further and join the Subject column with your other data table. Then you will be able to data bind the resulting table to a reporting table. You can read more about using tables here: Table/Crosstab/List.
As for the automatic growth of your table and adding additional "Adjustment" table columns, you can add dynamic columns to a table programmatically. I've attached a sample project that shows you how to create table dynamically (needs the AdventureWorks database).
Keep in mind that when adding columns to a table dynamically, if your table gets too wide to fit on the page it will cause a horizontal overflow and will continue on the next page. More information on the topic can be found here: Understanding Pagination
Regards,
Nasko
Telerik
Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.
0
Craig
Top achievements
Rank 1
Rank 1
answered on 30 Oct 2013, 05:46 PM
I found a much easier solution on my own. My data cannot be flattened as you suggested because there is a 1 to many relationship between the "Subject" column and the properties that follow it. This is for comparison purposes.
I was able to achieve my layout using the following layout
|-----------------Contain Table Holds 'Rows' -------------------------------------------------|
| |---------- Subject Table in 'Rotated' mode -------------------------------------------| |
| | Data Label | Databound 'Subject' DS | Grouped Column | |
| | |------ Comparable Property Table nested in parent Grouped Column ---| | |
| | | Databound Comparable Property | Databound Adjustment Column | | |
| | |------------------------------------------------------------------------------------------| | |
| |-----------------------------------------------------------------------------------------------| |
|----------------------------------------------------------------------------------------------------|
I was able to achieve my layout using the following layout
|-----------------Contain Table Holds 'Rows' -------------------------------------------------|
| |---------- Subject Table in 'Rotated' mode -------------------------------------------| |
| | Data Label | Databound 'Subject' DS | Grouped Column | |
| | |------ Comparable Property Table nested in parent Grouped Column ---| | |
| | | Databound Comparable Property | Databound Adjustment Column | | |
| | |------------------------------------------------------------------------------------------| | |
| |-----------------------------------------------------------------------------------------------| |
|----------------------------------------------------------------------------------------------------|