ERROR Message in report

[Frank Murren]

I have created a report which includes a calculated field of the type
.....=Sum(QUANT ITY]*[Expr1]) and the report also does a group total which
gives an overall sum for the report.
My problem is that when I run the report, if there are no records to return,
I get an ERROR message in a couple of the fields.
Is there anyway that I can eliminate this ERROR message when there are no
results from the underlying query.
Thanks for any help

Frank Murren

[Bas Cost Budde]

Re: ERROR Message in report

Frank Murren wrote:
[color=blue]
> I have created a report which includes a calculated field of the type
> ....=Sum(QUANTI TY]*[Expr1]) and the report also does a group total which
> gives an overall sum for the report.
> My problem is that when I run the report, if there are no records to return,
> I get an ERROR message in a couple of the fields.
> Is there anyway that I can eliminate this ERROR message when there are no
> results from the underlying query.
> Thanks for any help
>
> Frank Murren
>
>[/color]
You can use the HasData property of your report here. Such as

=iif(hasdata,su m(quantity*expr 1),"")

--
Bas Cost Budde

http://www.heuveltop.nl/BasCB

[Mick Hardy]

Re: ERROR Message in report

A short search in this NewsGroup found "Another #error in report". It
has several good solutions. You should search before posting. I
rarely come across a problem no-one else has experienced.