Correct me if i am wrong, but crystal reads a report from top to bottom. I have two sections on my report, Section 1 and Section 2. I would like to supress section 1 if a value in section 2 meets the requirements. How can i achieve this?
Printable View
Correct me if i am wrong, but crystal reads a report from top to bottom. I have two sections on my report, Section 1 and Section 2. I would like to supress section 1 if a value in section 2 meets the requirements. How can i achieve this?
What are sections 1 and 2? Details, Group Headers or Footers.
Do they show information from the same record? If yes then the value that is displayed in section 2 is available in section 1 - so just use it in the suppression formula.
If section 2 prints data from the next record then use the Next(fld) function in your section 1 formula.
If this does not help, can you give more information on your report and how it is laid out.
Hi Brucevde
Hope i explain this good enough.
1. What i have is a one to many relationship from Trust > Options.
2. I have three tables Tust;Options;Transactions
3. I have a group header called 'Trust' in which i put a description
4. I have a group footer called 'Option' in which i display summaries and formulas based on information in the transaction table displayed in the details section.
So as per my previous post..
Section 1 is my Group header 'Trust' and section 2 is my group footer called 'Option'. If all the summaries in section 2 is zero i would like to supress section 1.
Thanks
:)
You should be able to include the same formulas that are in your Options group footer in the formula to suppress the Trust group header. For example,
If Sum({Transaction.SomeField}, {Options.GroupField}) = 0 Then True Else False
Although, based on your information, something does not make sense. If you have two groups, the inner group may print one or more group footers for each outer group. This means only the last group footer would dictate the suppression of the outer group header.