Report Designer (Standalone)

[shilpa]

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

 

.

 

[Neli]

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