Double grouping and multiple columns

[#1]

Hi all,

I have a main report, in it the subreport and in this subreport I need to have two groups, but:

1) first group I need to display normally, one group under the other

2) second group I need to display with multiple columns.

There is a sketch of this situation:

I am using CR 2011, I have the possibility to change the package with query in database. I just need to know the way, how to reach the layout above.

Thanks a lot for your answers.

Filip

[JWiseman · Accepted solution]

hi Filip,

with a multi-column report (using the multi-column option available in the Details section) you can't choose which groups are going to be multi-column or not...it's all or nothing with the Format Groups option.

based on your sketch though you can do this type of report with the following specs:

1) you have a main report which has one group on the AAA, BBB, CCC field

2) in group header 1b, you have a subreport which is linked on that field used in the group above

3) the subreport is formatted to use multi-columns including the second group

please see the attachment. extract the contents and change the .txt extension to .rpt. note that there's also a top n (n=2) in the group sort expert of the subreport to keep the number of group 2 columns to 2.

cheers,

jamie

MutliColumnTwoGroups.txt.zip

[Former Member · Accepted solution]

Hi Jamie,

thank for reply. Your solution is possible and nice, however, in my case is not suitable 😞 I already have one grouping in my main report, which I am not able to cancel (because of clients requirements).

Because it is not possible to put subreport into another subreport or use grouping only in one specific detail sub part (e.g. Details d), I will have to apparently develop some nasty function in database to prepare data in way I am able to display.

Anyway, many thanks for reply.

[JWiseman · Accepted solution]

the other choice is to then concatonate two groups in the subreport so it's actually one group, but looks like 2. please see the attached where a concatonation formula in the subreport is the main group but uses two values. you'll need to use the suppression formulas on things above the boxes...see the suppression formulas on the country field as an example.

i don't think that you'll be able to change the display at the database end due to the way that multi-columns work in crystal. this functionality is a bit restrictive.

MutliColumnTwoGroups.txt.zip