#Error# in Calculated field

[vani65]

Hi,
I have a main report with several subreports.I have totals from two subreports adding up in main report. In the calculated field in control source I am using following code:

=[Reports]![rptJobCostAnalysis]![rptJobRep: Expenses].[Form]![ExpenseTotals]+IIf([JobSheet].[Report].[HasData],[JobSheet].[Report]![Text19],0).

All was working fine.all of sudden in this field #Error# is being displayed.I am confused can anyone highlight what should I do.
Thanks in advance

 

[THWatson]

vani65
The check for HasData normally needs to evaluate to either True (=-1) or False (=0). An example...
=IIf([JobSheet].[Report].[HasData]=-1,[JobSheet].[Report]![Text19],0)

Could that be the problem?

Tom

 

[vani65]

Hi THWatson,
I tried using following but still getting #Error# in the field.
=[Reports]![rptJobCostAnalysis]![rptJobRep: Expenses].[Form]![ExpenseTotals]+IIf([JobSheet].[Report].[HasData]=-1,[JobSheet].[Report]![Text19],0)

Could you please point me where I am doing wrong.
Thanks

 

[Remou]

Have you checked the exact spelling of everything, in case a letter has gone astray?
You have Form rather than Report here:
=[Reports]![rptJobCostAnalysis]![rptJobRep: Expenses].[red][Form][/red]![ExpenseTotals]+IIf([JobSheet].[Report].[HasData]=-1,[JobSheet].[Report]![Text19],0)

 

[vani65]

Hi Remou,
I was away just back to work. That was wonderful I have been missing all the time. Thanks for your pointing the error.