Report Layout

3 posts, 0 answers
  1. Nick
    Nick avatar
    6 posts
    Member since:
    Feb 2015

    Posted 23 May 2017 Link to this post

    Im having trouble getting a report to layout as I'd like. The report needs to have multiple rows for each record that is returned from the database. No matter what I try, I cant get the report to layout correctly. As soon as I have multiple rows per record, the rows always move to the bottom of the section and only return once. An example of what I need to look like is attached. What its returning like is also attached. Any ideas on what I can do?

    Thanks,

    Nick

     

    Needs To Be

    Currently Is - Missing most of the data

  2. Nick
    Nick avatar
    6 posts
    Member since:
    Feb 2015

    Posted 18 Jul 2017 in reply to Nick Link to this post

    I never heard back about this. Is it not possible?
  3. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 19 Jul 2017 Link to this post

    Hi Nick,

    The layout can be done with Telerik Reporting.
    You need to prepare data in a structure where you have the flatten representation of the hierarchy e.g.:
    Org,Part,Description
    Org1,Part1,test1
    Org1,Part1,test2
    Org1,Part2,test12
    Org1,Part2,test123
    Org1,Part2,test1234
    Org2,Part1,sample
    Note how grouping data is repeating. The repeating fields can be used in groupings - Grouping data.

    For example:
    1. Start a Band Report Wizard and specify a grouping by Fields.Org. Finish the wizard without adding any other data;
    2. In the GroupHeaderSection start a Table Wizard - make the Table item display Fields.Description only;
    3. Open the Group Explorer and add a parent row group by Fields.Part in the Table item's row groups;
    4. Open the Table item's bindings collection and change its DataSource to be =ReportItem.DataObject (the data associated with the parent element) - Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph);
    5. Style not needed elements and sections to be hidden.

    The approach is illustrated with the attached video, that is a SWF file that can be previewed in IE browser with installed Flash. The report from the video is a TRDP file that can be previewed with the Standalone Report Designer of Telerik Reporting R2 2017 and newer.


    Please note that we cannot guarantee responses by Telerik representatives in forums in a timely manner. Our recommendation is to use the support ticketing system if you need the issue to be addressed by the team handling the product.

    Thank you for your understanding.

    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
Back to Top