This is a migrated thread and some comments may be shown as answers.

How to Bind the List Items to multile Columns In table

6 Answers 219 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Deepika
Top achievements
Rank 1
Deepika asked on 28 Nov 2013, 07:39 PM
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

6 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 02 Dec 2013, 04:46 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Deepika
Top achievements
Rank 1
answered on 05 Dec 2013, 09:16 AM
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

0
Deepika
Top achievements
Rank 1
answered on 09 Dec 2013, 06:52 PM
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
0
Stef
Telerik team
answered on 10 Dec 2013, 12:31 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Jolanta
Top achievements
Rank 1
Veteran
answered on 03 Oct 2015, 05:55 PM

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).

0
Stef
Telerik team
answered on 07 Oct 2015, 09:35 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Deepika
Top achievements
Rank 1
Answers by
Stef
Telerik team
Deepika
Top achievements
Rank 1
Jolanta
Top achievements
Rank 1
Veteran
Share this question
or