Row groups with merged cell above?

[Joe]

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     

[Joe]

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?

[Katia]

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

[Joe]

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

[Katia]

Hello Joe,

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


Regards,
Katia
Telerik

[Joe]

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

[Cezar]

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 [e-mail] 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 [e-mail] I answer you with the same attached

[Katia]

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

[Mike]

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

[Mike]

I have also added a rwo shot of the data used to produce this if it helps?

[Ivan Hristov]

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