Suppressing multiple group headers. 1

[prevost999]

I have created 6 custom group headers based on user-defined date ranges.(formula fields) The grouping is working fine, it's just that for every header, all 6 Group Names are showing up. How do I suppress all non-relevant headers for each individual group? Thanks in advance.

 

[kenhamady]

You can conditionally suppress the section or object using Format Field, or Format Section. Use the same logic you used for creating the group. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[prevost999]

Kenhamady: Thank you very much, I got it to work, but there is 1 remaining problem. When I do this, all of my group footers reside at the bottom of the report, and not where they should, at the end of the detail for the section they belong to. I've tried to re-position the footers with no success. Any thoughts?

 

[FoxG]

Hi,

Have you set the Print at bottom of page tick box on the Group Format Section...

Alternatively, have you put the footer field details in a group footer outside the group containing the 6 group header fields

Geoff

 

[prevost999]

I got everything working, and here's how:
1) To make the group footers appear correctly:
** In the Change Group Options dialog box, I changed
the "The Section Will Be Printed" option to
"on any change". (I previously had it set to "on
change to yes".)**

2) For the original problem, using Kenhamady's input:
** For each group I had to conditionally suppress, I
used logic to OMIT each of the other 5 groups, by
omitting the date ranges they belonged to. Then
only the correct group header would appear. **