Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide/Suppress Fields Base on Group

Status
Not open for further replies.

xyle

Programmer
Jul 2, 2003
23
US
I have a report that is grouped by a field that contains different types of changes. On one of change types I would like to hide or suppress some fields that are irrelevant to the group. Is there any simple ways to accomplish this?
 
Right click on the field or fields that is irrelevant to the group.

Select Format Field.
Under Common Tab, click on x-2 button on the right of the Suppress checkbox. If you need to suppress the fields for only one change type (as you have mentioned in your post, type the following in the Format Formula Editor window that opens up

[tt]{FieldThatContainChange} ="Your Change Type"[/tt]

Click Save and Close button
Click OK

In case you need to suppress for multiple change types use the following in the formula editor instead:
[tt]{FieldThatContainChange} in ["Your Change Type1","Your Change Type2][/tt]

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top