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

Row groups with merged cell above?

10 Answers 269 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Joe
Top achievements
Rank 1
Joe asked on 31 May 2016, 10:17 PM

I have a table with several columns. Some of the rows have repeating data in their columns. Using Row Groups, I can group the data like so:

Patter     

10 Answers, 1 is accepted

Sort by
0
Joe
Top achievements
Rank 1
answered on 31 May 2016, 10:24 PM

No Edit options for posts? Weird.

Anyway....

 

Pattern     Width

1                0.1

                  0.5

2                1.5

                   .4

                  1.1

3                1.2

With Row Groups, I can hide the repeating pattern numbers. However, I have some data (a message) that sometimes needs to be posted above the pattern number and span all the columns. like

Pattern      Width

Message about pattern 1
1                0.1
                  0.5
2                1.5
                   .4
                  1.1
A message about pattern 3.
3                1.2            

How do I create a table with merged cells above the Parent Group? Or, is there some another way to show this data?

0
Katia
Telerik team
answered on 03 Jun 2016, 12:42 PM
Hi Joe,

Check the sample attached demonstrating the scenario you described. 

The main idea is to insert additional row (right-click on Pattern detail cell -> Add row -> inside group above) and set cells' borders to 'None' in the required area.
Optionally, you can hide the row without any data using conditional formatting.


If your scenario or data is different please open a new support ticket where you can send us a sample report with your current settings and test data so we can give you further suggestions.

Regards,
Katia
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
0
Joe
Top achievements
Rank 1
answered on 03 Jun 2016, 08:49 PM

I'm running version 8.2.14.1204, and it won't open the file :-(

I'll play around with the idea you outlined.

Thank you VERY much for your help!

-Joe

0
Katia
Telerik team
answered on 07 Jun 2016, 02:30 PM
Hello Joe,

Check the report attached that is compatible with the version you use.


Regards,
Katia
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
0
Joe
Top achievements
Rank 1
answered on 07 Jun 2016, 03:08 PM

Thanks Katia, you've been a tremendous help!

I would still like to merge and display each message across all columns (and center it nicely), but there doesn't seem to be a way to do that. However, adding an "Inside Group - Above" to a cell has solved the biggest part of our problem.

 

Thanks!
-Joe

0
Cezar
Top achievements
Rank 1
answered on 07 Jun 2016, 05:35 PM
I had the same problem before. I have a step clear and easy to understand step , but in a different file extension of the permitted here. Send me a contact in cezar-augusto1@hotmail.com I answer you with the same attached
I had the same problem before. I have a step clear and easy to understand step , but in a different file extension of the permitted here. Send me a contact in cezar-augusto1@hotmail.com I answer you with the same attached
0
Katia
Telerik team
answered on 09 Jun 2016, 08:31 AM
Hi Joe,

Unfortunately, merging the cells from different column groups is not supported. You can only merge cells within the same group group.

You can also test using groups and TextBoxes instead of Table item and the detail information into Detail section and message into GroupHeader section.


Regards,
Katia
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
0
Mike
Top achievements
Rank 1
answered on 22 Oct 2018, 10:15 AM

Hi Katia

 

Do you have some step by step instructions on how to replicate this functionality?

I can do it using a standard report but cannot do it with a table which I need as I can't use sub-reports in my scenario.

I've attached a screenshots that shows a report design and the final preview that I need to somehow replicate in a table?

Thanks

 

Mike

0
Mike
Top achievements
Rank 1
answered on 22 Oct 2018, 10:16 AM
I have also added a rwo shot of the data used to produce this if it helps?
0
Ivan Hristov
Telerik team
answered on 25 Oct 2018, 09:12 AM
Hello Mike,

Such layout can be easily achieved with a List item (which is essentially a Table with one column and Panel as container), that has group by Category and nested table that obtains its data through Bindings. The Category textbox and the nested table are placed in the list's Panel so if the Category textbox grows vertically, it will push the table below.

Please find a sample TRDX file that demonstrates how such a layout would look like. I hope you will find it useful.

Regards,
Ivan Hristov
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
General Discussions
Asked by
Joe
Top achievements
Rank 1
Answers by
Joe
Top achievements
Rank 1
Katia
Telerik team
Joe
Top achievements
Rank 1
Cezar
Top achievements
Rank 1
Mike
Top achievements
Rank 1
Ivan Hristov
Telerik team
Share this question
or