This is a migrated thread and some comments may be shown as answers.

Report Designer (Standalone)

1 Answer 74 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
shilpa
Top achievements
Rank 1
shilpa asked on 13 Jun 2019, 02:27 PM

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

 

.

 

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 18 Jun 2019, 10:35 AM
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
Tags
Report Designer (standalone)
Asked by
shilpa
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or