Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

ODBC Connection problem.

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
jjcyeshua
Veteran Member
Posts: 49
Veteran Member
9/12/2007 10:17 PM
    Hello.. I need help. I am having problem creating sql expression). When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. Also when I use sql command to pull all the data that I need, the report runs very..very..very slow…. Please help… Thanks

    Error in compiling SQL Expression:
    Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'select'.[Database Vendor Code:156]'.

    Thanks
    John Henley
    Posts: 3353
    9/13/2007 1:23 PM

      Hi Jonathan,
      The SQL Expression is not a full SELECT / SQL statement. It's just a replacement for a formula, where instead of Crystal doing the processing after retrieving the data, you're forcing the database to do the processing BEFORE returning the results to Crystal. An example would be a MONTH(datefield) function.

      Take a look at slide 32 of this presentation:
      https://www.lawsonguru.co...0Crystal.pdf#search="sql expressions"

      Thanks for using the LawsonGuru.com forums!
      John
      jjcyeshua
      Veteran Member
      Posts: 49
      Veteran Member
      9/13/2007 10:52 PM
        Thanks.. John.. do you happen to know where i can find a resource on crystal sql expression syntax.
        John Henley
        Posts: 3353
        9/13/2007 11:40 PM
          See if this explains it for you:
          http://www.ml-crystal.com.../sql-expressions.htm
          Thanks for using the LawsonGuru.com forums!
          John