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

9 posts, 0 answers
  1. Nick
    Nick avatar
    12 posts
    Member since:
    Jun 2017

    Posted 06 Jul 2017 Link to this post

    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.

  2. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 07 Jul 2017 Link to this post

    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
    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
  3. Nick
    Nick avatar
    12 posts
    Member since:
    Jun 2017

    Posted 07 Jul 2017 in reply to Stef Link to this post

    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.

     

  4. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 10 Jul 2017 Link to this post

    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
    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
  5. Nick
    Nick avatar
    12 posts
    Member since:
    Jun 2017

    Posted 11 Jul 2017 in reply to Stef Link to this post

    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.

  6. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 12 Jul 2017 Link to this post

    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
    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
  7. Nick
    Nick avatar
    12 posts
    Member since:
    Jun 2017

    Posted 12 Jul 2017 in reply to Stef Link to this post

    Hi Stef.

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

    Thank you,

    Nick

  8. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 13 Jul 2017 Link to this post

    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
    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
  9. Nick
    Nick avatar
    12 posts
    Member since:
    Jun 2017

    Posted 13 Jul 2017 in reply to Stef Link to this post

    Hi Stef,

    Thank you.

    Best,

    Nick

Back to Top