Skip to Content
avatar image
Former Member

how To create groups in Crystal Reports at same hierarchy level

Hi ,

In my report i have 3 groups:G1, G2,G3

and i want to create e schema like this:

G1 Level1

G2 Level2

G3 Level2

wich means i want that group 2 and group 3 be both dependnet from group 1. I want first to show the all the records of group 2 and only after that i want to show the records of group 3.

Is it this possbile in CR, pls?

Pls if someone has an answer , share it 😊

Thanks ,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 27, 2008 at 06:35 PM

    repost

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2008 at 07:14 PM

    Sounds like what you need is just two groups, and not three.

    You can use 'Specified order' in your grouping options to create a custom group:

    (copied from the CR 11 help files)

    On the Insert menu, click Group.

    The Insert Group dialog box appears.

    Select the field you want the data grouped by from the top drop-down list.

    Select in specified order as your sort option from the second drop-down list.

    On the Specified Order tab, enter the name of the group in the Named Group field.

    Click New.

    In the Define Named Group dialog box, use the drop-down lists to select the data to be part of the group.

    Click the <New> tab to add more selection criteria to your specified group, if necessary.

    Click OK.

    Click New to create more custom groups as necessary.

    Click the Others tab to specify how you want to organize the data that is not part of the group(s) you defined.

    Click OK.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      After placing the subreports in main report for subreport2 in GH2, since you are passing the value of grouped field in subreport create a group using the same field and place the data in detail section. So now you can see all the grouped data for GH2 without the next group data. Do the same for next subreport also.

      Regards,

      Raghavendra

  • avatar image
    Former Member
    Nov 28, 2008 at 10:29 PM

    Without similar data it's going to be hard for me to validate my suggestion, but I'm pretty sure that the custom grouping functionality will do what you need to do here.

    To use the same creditor/debitor example as stated in the thread, you'd create a group that pulls all related records, and breaks them into creditors and debitors, rather than a group for creditors, and a group for debitors.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your replys.

      Can you explain me a little bit more what you mean with "To use the same creditor/debitor example as stated in the thread, you'd create a group that pulls all related records, and breaks them into creditors and debitors, rather than a group for creditors, and a group for debitors"

      How to break them in creditoris and debitors? And is it possibilt from CR to create a group by a field wich is composed by 2 values(by 2 id for example)

      Thanks:)

  • Oct 25, 2009 at 05:17 AM

    Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

    http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage∥entCategoryID=&categoryID=11522300?resid=-Z5tUwoHAiwAAA8@NLgAAAAS&rests=1254701640551

    Add comment
    10|10000 characters needed characters exceeded