Group Table, how does it work ?

11 posts, 0 answers
  1. Antonio Avanic
    Antonio Avanic avatar
    4 posts
    Member since:
    Jul 2008

    Posted 16 Jun 2009 Link to this post

    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

  2. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 17 Jun 2009 Link to this post

    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.
  3. DevCraft banner
  4. Kwan Fu Sit
    Kwan Fu Sit avatar
    3 posts
    Member since:
    Aug 2009

    Posted 20 Aug 2009 Link to this post

    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.
  5. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 24 Aug 2009 Link to this post

    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.
  6. Kwan Fu Sit
    Kwan Fu Sit avatar
    3 posts
    Member since:
    Aug 2009

    Posted 24 Aug 2009 Link to this post

    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.
  7. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 27 Aug 2009 Link to this post

    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.
  8. Kyle
    Kyle avatar
    15 posts
    Member since:
    Mar 2016

    Posted 21 Jul in reply to Steve Link to this post

    Could you reattach in a format people use? Thanks.
  9. Kwan Fu Sit
    Kwan Fu Sit avatar
    3 posts
    Member since:
    Aug 2009

    Posted 21 Jul Link to this post

    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?

  10. Kyle
    Kyle avatar
    15 posts
    Member since:
    Mar 2016

    Posted 22 Jul in reply to Kwan Fu Sit Link to this post

    Ah yeah :). Opened in Chrome but not IE.
  11. Kyle
    Kyle avatar
    15 posts
    Member since:
    Mar 2016

    Posted 22 Jul in reply to Steve Link to this post

    When I try to add a child group it says "Error: no grouping cell"
  12. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 22 Jul Link to this post

    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
Back to Top
DevCraft banner