Trying to convert this series of gridviews to one report in telerik. Was wondering what would be the best way to display this data in a telerik report would be as I am a newbie. The listing of the years in the first column are fed by a stored proc. Each row of totals is essentially is a gridview which is also fed by their own individual stored proc. Like I said, I am new to this but was thinking that either a table or cross tab controls would be the way to do this. (Or a series of...) The databinding is an issue i am dealing with as well.Any suggestions would be greatly appreciated.
The table item is just what you need (the Table, Crosstab and List items are actually the same Table item with different initial settings, according to the documentation - http://www.telerik.com/help/reporting/table-working-with-table-cross-table-list-items.html).
What you need to figure out is which fields would be the Row and which Column group hierarchies. The groups in the RowGroups hierarchy define rules how the rows of the Table will be repeated, while the groups in the ColumnGroups hierarchy are responsible for the columns. So the leaf groups in the RowGroups (leaf group has no child groups) defines the rows in the Table Body while the leaf column groups define the columns of the Table Body. The documentation covers these in more detail - http://www.telerik.com/help/reporting/table-overview.html