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

Excel filtering for Grouped data in Telerik Reports

4 Answers 46 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sijeesh
Top achievements
Rank 1
Veteran
Sijeesh asked on 26 May 2020, 05:01 AM

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

 

4 Answers, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 28 May 2020, 04:07 PM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Sijeesh
Top achievements
Rank 1
Veteran
answered on 28 May 2020, 07:23 PM

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.

0
Todor
Telerik team
answered on 02 Jun 2020, 11:56 AM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Sijeesh
Top achievements
Rank 1
Veteran
answered on 03 Jun 2020, 06:49 AM
Thanks Todor, It worked finally.
Tags
General Discussions
Asked by
Sijeesh
Top achievements
Rank 1
Veteran
Answers by
Todor
Telerik team
Sijeesh
Top achievements
Rank 1
Veteran
Share this question
or