Subreport printing question.

[fiat2]

Visual Studio 2005
Crystal version 10??

I have a CR report which contains a subreport.
I am passing 2 parameters to the subreport, group and subgroup.
For each group, there can be mutliple subgroups.
For example, Group A can have multiple subgroups of the same subgroup.

Group  Subgroup  Value
A       1         456
A       1         100
A       1         3939
A       2         9393
A       2         29
A       3         0303
A       3         4
..
..
..

When I run the report this subreport is printing 3 times for (Group/Subgroup) A/1, twice for A/2 and twice for A/3.

Is there a way to have the subreport print once for each group/subgroup combination without changing the backend?

Thanks!!

 

[kskid]

Based on the data provided, looks like your subreport is in the detail section.

To pass the group and subgroup, your subreport should reside in either the Group 2 Header or Footer section, assuming you inserted the group as Group 1 subgroup as Group 2.

 

[fiat2]

You are absolutely correct.Moving this from the Detail section to the Group 2 header worked...BUT....
I lost the ability to print multiple columns, which I could do in the Detail section....


I hate to do this...is there a way to handle multiple columns in the Header rather than in the detail section?

Thanks again for tip.

 

[lbass]

You still format the details to format with multiple columns, and then in the layout tab check "format groups with multiple columns".

-LB