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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Details Formula Editor Problems

Status
Not open for further replies.

apospical

Technical User
May 20, 2004
2
US
I have a group of reports that have been running for many months with a conditional formula in the Details Suppression Section. I recently added additional criteria to the formula in the Details Suppression Section_Visibility formula editor. Ater saving and closing the report, if I re-open the report and go back to view or edit the details suppresion formula, the 'X2' button brings up a Font_Color Formula Editor for another field on the report instead of the Section_Visibility Formula Editor for the Details Section. This happened to all 24 reports. Has anyone experience or heard anything like this before.

Previous Formula:
{LP_HRISHRFRHNF;1.CURRENT_EMPL_STATUS} <>"S" or
{LP_HRISHRFRHNF;1.PREVIOUS_EMPL_STATUS} <> "A" OR
{LP_HRISHRFRHNF;1.CURRENT_TERM_CODE_201_HNF} = "02"

Added Criteria:
OR
{LP_HRISHRFRHNF;1.TYPE_OUT} = 'INVALID TYPE' OR
{LP_HRISHRFRHNF;1.TYPE_OUT} = 'WRONG MONTH CONTROL - USE HRISMON'

 
Update to this. The reports contain a string field embedded in a text object. The string field has a formula on the Font control that sets the font color red based on specific value of the field. I am addind additional conditions into the formula to turn the font red. To do this I r-click on the embedded field and selet "format embedded field" from the drop down, make my changes and save the report. The report work fine. If I leave the report and come back, the only formula editor that will open is the Font_Color Formula Editor for the embedded field. No matter where you try to open a formula editor from it always opens the Font_Color Formula Editor
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top