Excel filtering for Grouped data in Telerik Reports

[Sijeesh]

Hello Telerik,
We are not able to filter the Grouped data in Excel after exporting from Telerik Reports.
Grouping of data is done through CrossTab in Telerik reports.
A sample excel file is shared for your reference.
As you can see in the excel, i have grouoed the data based on COL1, COL2, COL3.
Now when i filter COL3 and select value as BAA, then it shows only row 1 data instead of showing rows 1,2,3 and 4
similarly when i filter COl2 and select XYZ, then it shows only row 10 data instead of showing rows 10,11,12,13,14,15,16,17,18
What am i missing here. Or is it the limitation in Excel exported from Telerik Reports

 

[Todor]

Hello Sijeesh,

Generally, the Excel rendering targets at optimal document layout according to the report design. It does not pass any interactivity or expressions to the generated Excel file.

From the screenshot, I see that there is no text in the cells of Col1, Col2, and Col3. I suspect that is why the filtering selects only the first cell that has the corresponding value. It looks like these columns are row group headers that by default appear merged. As a workaround, you may try to display the corresponding group header in all of them instead of only in the first one.

Regards,
Todor
Progress Telerik

[Sijeesh]

Hello Todor,

Thanks for the quick response.

But how to display the corresponding group header values in all the rows inside the Cross-tab. Right now the Grouped header value is displayed only once in the Cross-tab.

In the property window of the Cross-tab, I couldn't find anything related to the Grouped values.

[Todor]

Hi Sijeesh,

I have attached a sample report based on your screenshot. The generated Excel file is also in the archive. Note that now you may filter the values correctly.

I used the Table Wizard to add all the fields as columns in the table. This way I assured that the grouping fields will be repeated on each row. Then I introduced table groups through the Group Explorer. You need to click on the ellipses beside the group and select Add Group -> Parent Group. Start from the default detail group and add first the innermost group to the detail group, in my sample I added a group by =Fields.Gr3. Then to the new group add the next one, in my case to gr31, I added a group by =Fields.Gr2. And so on. Make sure you check the 'Add Footer' checkbox for each new group - you will enter there the Total. See the attached screenshot AddLastTableGroup.png for clarity.

Then, I hid the columns added by the introduced groups in the beginning of the Table. It was also necessary to add the Totals for each group with the corresponding Expression.

Regards,
Todor
Progress Telerik

[Sijeesh]

Thanks Todor, It worked finally.