Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

LBI Error

Sort:
You are not authorized to post a reply.
Author
Messages
Marc
Basic Member
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
    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
      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
        Senior Member
        Posts: 3348
        Senior Member
        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
          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
            Senior Member
            Posts: 3348
            Senior Member
            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
              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
                Senior Member
                Posts: 3348
                Senior Member
                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
                  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
                    Senior Member
                    Posts: 3348
                    Senior Member
                    12/18/2007 7:32 PM
                      Marc, did you ever get this working?
                      Thanks for using the LawsonGuru.com forums!
                      John
                      Marc
                      Basic Member
                      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

                        You are not authorized to post a reply.