Hi
I have a new requirement where i need to show more than one group in a page and when both groups have same headers i should suppress the group header. if they are different i need to show them.
Is there any kind of formula i should use or any section/group/header settings change? :?
Start by posting your question in the Crystal corner
But if they have the same group header then aren’t they the same group??
From my memory (but is has been a while since i used cr) you can (mis)use the visibilty setting.
Try creating a formula there like an if [previous header]=[current header] then [true] else [false].
Maybe you need to create variables that get filled with the info from previous groups titles.
easy way to do that
Go to design.
Right click on group name/label to which you want to suppress
Select option ‘Format Field’ from Popup menu
Select ‘Common’ tab
Check option ‘Suppress if Duplicates’
at last press ‘Ok’
I followed the steps you told and i could not find suppress if Duplicated.
I have to suppress the group header if it is repeating in a page. If in a page two groups have different groupheaders are there they should not be suppressed.
Go to the section expert. There is an option to suppress the header based on a formula. Note: If the formula evaluates to true the header is suppressed!. You need to find a formula that evaluates to true if you have a “second header”