Group Table, how does it work ?

[Antonio Avanic]

Can anyone tell me how can I group by a column in a table and make it look like this

Company:   Company One
Item	Spend	Unit	Price
Item 1	10	Kg	10.2
Item 3	15	Oz	1.5
Item8	20	grs	50
Company: Comapny Two
Item	Spend	Unit	Price
Item 2	9	Kg	10.2
Item 3	15	Oz	1.5
Item 7	20	grs	50

[Steve]

Hello Antonio,

I've attached a sample report that show how to implement the desired behavior using our CrossTab report item. Please check the following links for more info on it:

• Table/Crosstab/List
• Understanding the CrossTab/Table/List report items
• Understanding CrossTab areas
• Understanding table cells, rows and columns

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kwan Fu Sit]

Hi, I'm trying to get a similar table to work as well.  I've looked at the examples on the website and included sample reports but they do not contain the information I need.  I downloaded the zip file in this thread and created a new winform project and added the files in the zip file but it would not compile properly and giving a compile error of

"The type or namespace name 'MyCatalogue' could not be found (are you missing a using directive or an assembly reference?)"

All I'm trying to do is have a table grouped by one field showing two columns

Group A
Detail 1     Detail 2     <----- detail line associated with group A
Detail 3     Detail 4     <----- detail line associated with group A
Group B
Detail 5     Detail 6     <----- detail line associated with group B
Detail 7     Detail 8     <----- detail line associated with group B

Are there any samples that you can point me to or if you can update the attached sample with the project (so that all the references are there) that would be greatly appreciated.

[Steve]

Hello Kwan Fu Sit,

I did not had any problems running the report in a windows forms application and there is no MyCatalogue type or namespace in it. Anyway find one sample project attached and let us know how it goes.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kwan Fu Sit]

Thank you for the new sample.  The sample works like a charm but I tried to duplicate your row grouping and had a heck of time and ultimately just gave up.  I had to cut and paste what you had there and then re-set the datasource to what I needed to use.

How did you do the grouping for this sample report because no matter the combination I could not figure out how you got the RowGroup1 underneath the Company group.  When I tried it kept putting the RowGroup1 to the right side of the Company group which is what I did not want.

[Steve]

Hi Kwan Fu Sit,

I've attached a video that shows you how we've created this table layout. Please review it and let us know if further help is needed.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Kyle]

Could you reattach in a format people use? Thanks.

[Kwan Fu Sit]

Hello Kyle,

Are you referring to the video file CrossTabVideo.swf?  If so you can just drag it onto Internet Explorer or Chrome and it should play.  If that's not what your referring to, can you clarify?

[Kyle]

Ah yeah :). Opened in Chrome but not IE.

[Kyle]

When I try to add a child group it says "Error: no grouping cell"

[Stef]

Hi Kyle,

Please check my last post in Crosstab rows repeat.

If you prefer to add a parent row group by the field, please check the attached video - SWF file that can be previewed in IE browser.


If you need further help, please let us continue the discussion in one of both threads, in order to keep a better track on the exchanged information. You can also submit a support ticket with a demo report and details about the layout you want to achieve.

Regards,
Stef
Telerik by Progress

[Ruben]

Hello,
I need help! I am trying to get a report using crosstable, that is grouped by one field, for example, Company. Also, I need totals by columns and rows. It should look like on attached image. Thank you in advance for help, if you could create video for this request.

[Ruben]

Hello,

Sorry, if my question was not clear. In your example crosstabvideo.zip, the final result was crosstab grouped by Company. So, Company name looks like a row ahead of items. (Capture1.jpg)
I am looking for a way to create crosstab report grouped by Company, but Company should be a textbox as a title heading table of items (Capture2.jpg)

Thank you in advance

[Ruben]

Thank you, Telerik, for you assistance.

After of two days of searching I found solution here: https://www.telerik.com/forums/grouped-crosstab-with-static-rows