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!

Formula works in CR8.5, but not 10

Status
Not open for further replies.

gshadz37

Technical User
Mar 21, 2005
102
US
I have two formulas, I'm not sure where the breakdown is, but they produce records in CR 8.5, but I get no data in 10. I have used the datasource migration wiz, and everything else in the report seems fine:
Formula #1 -
if isnull({area_codes.state}) = true then "XXX"
else UpperCase ({area_codes.state})

Formula #2 -
if ( {state_dtl.calls offered} = 1 and {@GroupST} = "XXX") then 1
else 0

Does anyone see something that would cause an issue in CR 10?

 
Chekc your table linking in 8.5 versus 10 and see if there is any difference.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
It may not be version dependednt at all, rather null checking, so I'd check that first.

Crystal has the option to turn off null checking (most versions of Crysat under the report options or options pull down under File), in which case the first formula would fail.

If that fails, then as dgillz suggests, check the data source.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top