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!

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

Mass change to Default Values for Nulls in Formula Editor

Status
Not open for further replies.
retsyboss

retsyboss

MIS
Sep 6, 2002
12
US
I'm upgrading reports from 8.5 to XI. I changed the default for NEW reports to use Default Values for Nulls in formulas.

However, all the existing/converted reports' formulas are set to Exceptions for Nulls.

Is there a way to change ALL the formulas at once in a report/subreport to 'Use Default' ?

I tried the report options for Convert DB nulls to default, but that causes other issues. I could deal with it if that's the best option, though. I'd rather not change dozens of formulas per report.
 
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
478
TPG_IT
T
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
699
dgillz
dgillz
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
344
john432
john432
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
331
lbass
lbass
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
282
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top