Report Designer (Standalone)

2 posts, 0 answers
  1. shilpa
    shilpa avatar
    1 posts
    Member since:
    Jun 2019

    Posted 13 Jun Link to this post

    Hi All, 

    I am new to standalone Telerik report designer, i have a issue , created a report using crosstab.

    In preview , i see the crosstab is repeating with data.

    EX:

    Crude Oil
    NYMEX Swap 2019 57.04
    2019 57.04
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75

    Crude Oil
    NYMEX Swap 2019 57.04
    2019 57.04
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75
    2019 56.75

     

    .

     

  2. Neli
    Admin
    Neli avatar
    188 posts

    Posted 18 Jun Link to this post

    Hello Shilpa,

    This behavior is expected if the Crosstab is located in the detail section and there is a DataSource set to the report. The detail section is rendered as many times as the amount of the records in the Report data source, hence all the content of the detail will be rendered the same number of times. In this case there are two options to avoid the undesired outcome:
    1) Move the crosstab to the Report Header or Report Footer. The controls which the Report Header and the Report Footer contain are displayed only once at the top and bottom of the entire report respectively. By default these two sections are not included in the report. To reveal them, right-click outside the report area and select Report Header or Report Footer

    2) If the Report and the crosstab use the same data source, remove the DataSource of the crosstab and set it with the following Binding:
    Property path: DataSource
    Expression: = ReportItem.DataObject
    Note that in this case the Crosstab will still be generated multiple times, however, with only one record - the one for which the detail section gets generated. You may use band type report, e.g. remove the Crosstab and place the TextBoxes to display the information directly in the detail section.

    In the attached sample both approaches are demonstrated. For more information, refer to Report Structure article.  

    Regards,
    Neli
    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