• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI Error

 10 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
11/14/2007 5:09 PM
Has anyone seen this error. I am having troubles creating an instance on a report and keep getting this error.

The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CDEF6F-DD88-407B-B733-9378F9645DC3}.rpt: Error in formula . 'tonumber({@Convert Date to Period})' The string is non-numeric. Details: errorKind

Unable to retrieve Object.
The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CDEF6F-DD88-407B-B733-9378F9645DC3}.rpt: Error in formula . 'tonumber({@Convert Date to Period})' The string is non-numeric. Details: errorKind



It has something to do with a formula I created however the report works fine on my stand alone crystal verison. I am using crystal version 11.0.0.2178

Thank





Will
Veteran Member Send Private Message
Posts: 39
Veteran Member
11/14/2007 5:20 PM
Hi Marc,

Does it work when you publish the report on LBI and then run it from the Crystal Launchpad (located on your LBI box, under the Crystal Server (I believe) start menu)?
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
11/14/2007 5:21 PM
No it doesn't work in the launchpad either it returns the same error
John Henley
Send Private Message
Posts: 3351
11/14/2007 5:41 PM
Is this a formula that is stored in the report, or are you referencing a formula stored in a Crystal/BO repository?
Try renaming the formula to not have spaces, e.g. @ConvertDateToPeriod.
Thanks for using the LawsonGuru.com forums!
John
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
11/14/2007 6:24 PM
I just tried to remove the spaces and that didn't work I recieved the same error.

The formulas I am using are

left(totext({Command.CUQED}),2)

This converts the date totext and just picks out the period and I am also using this formula then to make the period a number

tonumber({@ConvertDatetoPeriod})
John Henley
Send Private Message
Posts: 3351
11/14/2007 7:09 PM
Since you're getting the same error when you run the report from the CE Launchpad, this is Crystal/BO error, not an LBI error.
Are you using the Lawson OLEDB connector to get the data?
Thanks for using the LawsonGuru.com forums!
John
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
11/14/2007 7:12 PM
I am using the Query Builder for Lawson OLEDB Services...and then I am using the reports tab and pulling my data from RW reports.
John Henley
Send Private Message
Posts: 3351
11/14/2007 8:12 PM
Are you able to run this report from the Report Designer? Have you been able to run Lawson OLEDB/Query Builder reports from the server (not from the Report Designer)?
Thanks for using the LawsonGuru.com forums!
John
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
11/14/2007 8:15 PM
When you say report designer do you mean --in crystal when I hit the refresh button. Because when I run the report in Crystal Reports 11 it works.
John Henley
Send Private Message
Posts: 3351
12/18/2007 7:32 PM
Marc, did you ever get this working?
Thanks for using the LawsonGuru.com forums!
John
Marc
Basic Member Send Private Message
Posts: 6
Basic Member
12/18/2007 7:35 PM
Yes we did get it to work. There was a formula error in the crystal report that was not allowing it to run in LBI. Eventhough it did work in crystal before we changed the formula there was a isnull formula that needed to be added. Thanks for checking up