How to output a list (single column in db) as a multicolumn list on a report?

[Nick]

Hi,

Please help me with the following:

to output a list (a single column in a database) as a 4 columns list on a report, I have added a panel with four table/lists on it.The following expressions are here:

=RowNumber()%2   =0

=RowNumber() < (ReportItem.DataSource.Count / 4)   =True

The report returns the same information in all four columns. What should be done to enforce each other table/lists continue to output the list.

Thank you.

[Stef]

Hi Nick,

You need only one Table item with column and row groupings making it render its cells in a specific position - How to: Create Multi-Column Report - Across the Page and Then Down.
You can produce a multi-column layout through the report's PageSettings properties as well, where the content will be rendered in columns in print preview  How to: Create a Multi-Column Report help article.


Let us know if you need further help.

Regards,
Stef
Progress Telerik

[Nick]

Hi Stef,

 

Thank you. I followed How to: Create Multi-Column Report - Across the Page and Then Down

The report returns an error:  MyDataIndex is not defined. The report means =Fields.MyDataIndex/5

Sorry, as I understand MyDataIndex, should be replaced but with what? 

Thank you.

 

[Stef]

Hi Nick,

In the How to: Create Multi-Column Report - Across the Page and Then Down KB article is sued a Table item bound to data having such field - MyDataIndex - which is an integer field representing a column of consecutive numbers. The value of this field and the specified row and column groupings of the Table item determine the position of the record in the Table item's structure.

You can add such field in the data source and use it for the groupings.

Regards,
Stef
Progress Telerik

[Nick]

Thank you, Stefan.

Sorry, the data source cannot not be updated. May we count the existing records to get the number, then divide on the number of columns?

Thank you.

[Stef]

Hello Nick,

Grouping expressions cannot use the RowNumber function.
If you are using a .NET object as data source, you can add another method thet gets the data and add a field with consecutive numbers. If you use a SQL query, you can add a field in the Select statement that will get the row_number over the received data.

In order to provide you more accurate suggestions, please post details about the data retrieval method.

Regards,
Stef
Progress Telerik

[Nick]

Hi Stef.

Thank you. We use a .NET object as data source.

Thank you,

Nick

[Stef]

Hello Nick,

In such case, test to create a top layer for the provided you data model/object e.g. a class with methods which call the corresponding methods of the original data object. In your wrappers you can extend the underlying model to your needs e.g. by adding the needed index field.

Regards,
Stef
Progress Telerik

[Nick]

Hi Stef,

Thank you.

Best,

Nick

[Pavithra]

I followed the approach given here - https://www.telerik.com/support/kb/reporting/details/how-to-create-multi-column-report---across-the-page-and-then-down. Instead of 3 I used 6 since I wanted my data to appear in 6 columns.The problem is I'm getting the data in steps (row n, col n).The first data appears in row 1 col1. The next one appears on row 2,col 2 and so on. Also the static text is repeating across 6 columns. Can you please let me know where I'm missing?

Thanks,

Pavithra

 

 

 

[Ben]

Having the exact same problem as described above, data is filling the table diagonally. Were you able to resolve this? If so, mind sharing?

[Ben]

Was able to resolve by using row detail group expression as follows:

= Floor(Fields.MyDataIndex/3)