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

Cannot get grouping to work

1 Answer 341 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Manu
Top achievements
Rank 1
Manu asked on 08 May 2017, 02:05 PM

Hello,

I have designed a report with the report wizzard and used the table template for the layout. The dataSource comes from an azure sql database. In preview and html preview I get all records displayed properly on one single page ( ... notice that the entry in Report.Properties.ApplicationSettings.DataSource is set to 'none' !!).

Now I want to group the records, but when I go to add new group, in the 'Edit Grouping / new expression' there is no field to select.

Otherwise, when I enter in Report.Properties.ApplicationSettings.DataSource the same dataSource that I selected when the report was built with the wizzard, I can select a field in the 'Edit Grouping' dialog -> but then in preview and html preview I get 101 pages each with all the same records on it (besides it takes a lot of time to show them eventually).

Please help

Regards, Manfred

 

1 Answer, 1 is accepted

Sort by
0
Accepted
Katia
Telerik team
answered on 10 May 2017, 12:26 PM
Hello Manfred,

I believe this questions was partially answered in the support ticket you opened earlier (# 1107591). 

When you use the Table Report Wizard it will set the data source for the Table item but not for the report itself. The data is displayed in the report with data items (Table item is a data item) and each data item will have its own data source.

When the data source is set for the Table item the data will be available only inside this table. If you need the data in report sections and the table item you can set the DataSource property of the report and use the data binding approach suggested here to reuse the parent's (report's) data source for the inner table.

Note that when the report has a data source its Detail section will be repeated for each row from the data source. If the Table item is placed inside the Detail section it will be repeated the same amount of times which will cause repeating data and performance issues - Data Binding Problems - repeating data.
In this case you can move the Table item from the Detail section to Group Header section (repeated once for the group) or Report Header section (repeated once for the report).

If you rather want to add the grouping to the table you can use a CrossTab Wizard - Understanding Crosstab Areas.
You can also add groups to the existing table - How to: Add groups to Table item and Crosstab item.


Regards,
Katia
Telerik by Progress
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
General Discussions
Asked by
Manu
Top achievements
Rank 1
Answers by
Katia
Telerik team
Share this question
or