Suppress text box in last group header 1

[lmohr79]

I have a text box in Group Header 1 that I want to suppress if it's the "last" group of the report. I'm sure I need to put a reference to evaluation time "while reading records", but haven't work with this feature in the formula editor.

Thanks in advance!

 

[chinjk]

Hi,

Go to the 'Format Text' / 'Suppress' x+2 and type down the following and see

groupname({table.field})=maximum({table.field})

It should work.

 

[chinjk]

I mean, the filed name you give in groupname({table.field}) as well as maximum({table.field}) should be te name of the field on which you have your first group.

 

[lmohr79]

Thanks for the post, chinjk. However, when I tried this to suppress, the field is not suppressed on the last group. Here's my actual "formula":

GroupName({JRNL_report.OpenDate})= maximum({JRNL_report.OpenDate})

The field I'm trying to suppress is a simple text box plotted in the Group 1 header. The report has a total of 3 groups.

OpenDate is actually a string, not a true date. In my data the field is mmddyyyy (01102006), so it sorts in the report in date order (there should never be more than a few days worth of data, starting at the beginning of 2006, not expected to run into 2007).

Any other suggestions, or is my formula not correct?

Thank you!

 

[chinjk]

Could you please tell me the value of you groupheader 1 for the first time and the value for the same in the last group?

 

[lmohr79]

I just realized that I had customized the group name field. I removed the customization and the formula you gave me works just fine.

I'll redo my header name a different way so the suppress continues to function correctly.

Thank you for the quick reply!

 

[chinjk]

you're welcome!