Format with multiple columns for group header

[crystaldev1]

Hello, I'm using CR 11 and Sql Server 2008. I would like to format group header with multiple columns. I know this is definitely possible for details but not available for group header section. I have the detail section suppressed. Following is a layout:

GH1
GH2
GH3
GH4name1 GH4name2 GH4name3 .....

Let me know how this can be achieved. Thanks.

 

[lbass]

Well, you can use multiple columns for groups--see the layout tab->format groups with multiple columns. However, you can't just do it for one group, so this method won't work. Instead, you could either insert a subreport that uses multiple column formatting that is linked on your first three groups and placed in the GF3 and which shows group #4 as the only group, with details and group formatted to multiple columns. Or you could collect the group 4 field in a variable that is reset in the group #3 header, and displayed in a group #3 footer:

//{@reset} for the GH3 section:
whileprintingrecords;
stringvar grp4fld;
if not inrepeatedgroupheader then
grp4fld := "";

//{@accum} for the GH4 section:
whileprintingrecords;
stringvar grp4fld := grp4fld + {table.group4field}+ " ";

//{@display} for the GF3 section:
whileprintingrecords;
stringvar grp4fld;

-LB