Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help: Error thrown saying it needs a Number Post Reply Post New Topic
Author Message
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Topic: Help: Error thrown saying it needs a Number
     Posted: 06 Apr 2010 at 9:51am
Hello Folks,
I have a crystal report which is populated by a stored procedure and when i try to run the report Its throwing an error saying "Number is required" and its pointing to the formula below.
{?@Payer}={rptInvoiceAnalysisB;1.clientid} or {?@Payer}=-1


Here ?@payer is parameter coming from Stored prodcedure and {rptInvoiceAnalysisB;1.clientid} is the field which is a numeric and the parameter is a number.


I think its throwing error because of -1 but not sure.Any thoughts about this.

Thanks a lot


Edited by Nav522 - 06 Apr 2010 at 9:52am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 07 Apr 2010 at 3:22am
as set up, that will return true or false, but not a number....basically you have     (true/false) or (true/false).  Not sure what you are looking to do.
 
HTH
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum