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

Group Table, how does it work ?

13 Answers 1280 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Antonio Avanic
Top achievements
Rank 2
Antonio Avanic asked on 16 Jun 2009, 09:21 PM
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

13 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 17 Jun 2009, 01:36 PM
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:


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.
0
Kwan Fu Sit
Top achievements
Rank 1
answered on 20 Aug 2009, 05:27 PM
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.
0
Steve
Telerik team
answered on 24 Aug 2009, 02:13 PM
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.
0
Kwan Fu Sit
Top achievements
Rank 1
answered on 24 Aug 2009, 07:16 PM
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.
0
Steve
Telerik team
answered on 27 Aug 2009, 02:26 PM
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.
0
Kyle
Top achievements
Rank 1
answered on 21 Jul 2016, 08:01 PM
Could you reattach in a format people use? Thanks.
0
Kwan Fu Sit
Top achievements
Rank 1
answered on 21 Jul 2016, 09:30 PM

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?

0
Kyle
Top achievements
Rank 1
answered on 22 Jul 2016, 12:09 PM
Ah yeah :). Opened in Chrome but not IE.
0
Kyle
Top achievements
Rank 1
answered on 22 Jul 2016, 12:10 PM
When I try to add a child group it says "Error: no grouping cell"
0
Stef
Telerik team
answered on 22 Jul 2016, 03:47 PM
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
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
Ruben
Top achievements
Rank 1
answered on 23 Feb 2018, 09:48 PM
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.
0
Ruben
Top achievements
Rank 1
answered on 26 Feb 2018, 09:31 PM
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
0
Ruben
Top achievements
Rank 1
answered on 27 Feb 2018, 06:19 PM

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

Tags
General Discussions
Asked by
Antonio Avanic
Top achievements
Rank 2
Answers by
Steve
Telerik team
Kwan Fu Sit
Top achievements
Rank 1
Kyle
Top achievements
Rank 1
Stef
Telerik team
Ruben
Top achievements
Rank 1
Share this question
or