Str is non-numeric error 1

[slh020]

lost again..I want my report to display transactions for our general revenue fund or for specific client(using SID#). The GRevenue fund sid# =0. The user will generate the grevenue(0) report most often so I have parameter to default to 0. I am trying to display in gh1 the name of client if a sid# other than o is entered, if sid# 0 is entered I want name of client to display in detail section. To do this I have used 2 subreports;
The reference# used in the sub is the same as the SID but in the grevenue database it was used instead of SID#. The report will work if I enter a sid other than o, but if I enter 0, I get error message "The string is non-numeric" and it goes to record selection formula editor. This is the formula:

{TrustClient.Client}=tonumber ({PmTrustTransaction.Reference})

The report is grouped by revenue code which includes numbers and dep,wd,etc.
Parameter Code;

TrustTransaction.Client=0.00
{TrustTransaction.TransactionDate}>={?start date} and
{TrustTransaction.TransactionDate}<={?end date} and
iif(left({?SID{,1)="0",true{?SID}={@strReference})

 

[slh020]

Is this too simple of a problem to warrant replies???? I know it is something very simple I am overlooking, but I am new to crystal and I am not a programmer....I am easily confused in other words....need help...please..Thanks...Steve

 

[Madawc]

I think most people got baffled about what you were doing. I'm far from sure I follow it, but I'll try.

Why are you converting to numeric within a comparison?

Could you have null values? (Use SEARCH if you don't know about nulls.)

The other thing I'd suggest is breaking up your test into formula fields and displaying each individually, just to see what you get.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[slh020]

Thanks Madawc, it was null values..I realized that this morning after I checked posting...I know I was not very clear about what I was doing b/c I was not clear on what I was doing..lol...I have been thrown into this job so I am having to learn on the fly..you know what I mean....Thank you again for your reply...