How to Bind the List Items to multile Columns In table

[Deepika]

Hello,

I have a table which is binded to a datasource,  which calls a function to get a list as the result[datasource = datasource.GetValues()]. I have a table to which I have binded this datasource.
Right now I have binded the datafields of the table to =Fields.Name, if the list has five names I see five pages.

The design of the report should be such that first item of the list should be in the first column, second item should be in the next column and so on....Please let me know how to so this.

Regards
Jess

[Stef]

Hello Jess,

You can use a Table/Crosstab/List item and set its DataSource as required to an ObjectDataSource or via binding to the data of the containing data item as explained in the How to use ReportItem.DataObject property in expressions help article and How to Databind to Collection Properties KB article. Then select a cell within the Table item and select Rotate Layout from its Context Menu. Thus the Table will grow horizontally.

If you need further help, please elaborate on the data structure, the report layout and the desired result.

Regards,
Stef
Telerik

[Deepika]

Hello Stef,

Thank you for the reply.

Problem is I have a list which has three properties that has to be binded to a table. I am able to bind it with DataSource : ReportItem.DataObject.List().
Note : I am retrieving the list during runtime and binding it to the datasource.

Now I get the report as follows:-

Column1                                                              Column2                                                                     Column3

list.item[1].property1                                     list.item[1].property2                                                  list.item[1].property3
list.item[2].property1                                     list.item[2].property2                                                  list.item[2].property3
list.item[3].property1                                     list.item[3].property2                                                  list.item[3].property3

All I want is as follows:-


                                        Group1                                                                                                      Group2

Column1                          Column2                       Column3                          Column4                    Column5                    Column6
list.item[1].property1    list.item[1].property2    list.item[1].property3  list.item[2].property1     list.item[2].property2   list.item[2].property


Please let me know how to achieve this.

Regards
Jess

[Deepika]

Hello,

Could somebody please let me know if the above design is possible using the table control or if it is required to use a different control.

Regards
Jess

[Stef]

Hi Jess,

There are various way to achieve this layout using Crosstab item. For example take a look at our local Crosstab/ProductSales report demo - the data is flatten and grouped in the rows and columns. the demo is installed by default under C:\Program Files (x86)\Telerik\Reporting Q3 2013\Examples\CSharp\ReportLibrary.

Other approach would be to use nested Table items with horizontal layout (Rotate Layout applied). Consider the attached report definition with Table item nested in a List item. The data is bound as in the How to use ReportItem.DataObject property in expressions help article

I hope this information helps you

Regards,
Stef
Telerik

[Jolanta]

Hi,

I have a small question:

In my DataSource, I have a field, which is a list of Strings. How can I refer to particular items of the list, in order to display them in table cells?

I would suppose: fields.myListName.item[1], fields.myListName.item[2]... where "item" is a key word, not my name. (This does not function, is only my supposition to write).

[Stef]

Hello Jolanta,

The collection property can be used as data source of a data item like Table/List/Crosstab, and thus all values will be displayed - How to Databind to Collection Properties.

Other approach is to use a custom function which gets as an argument the collection property and returns only a single value from it.


I hope this information is helpful.

Regards,
Stef
Telerik