Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help: Error thrown that a Number is required

Author  Topic 

Nav522
Starting Member

27 Posts

Posted - 2010-04-06 : 15:29:24
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

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-04-06 : 16:51:42
I'm no Crystal expert, but seems like ?@Payer is empty
Go to Top of Page
   

- Advertisement -