Using a Custom Crystal Report with my data

Sort:
You are not authorized to post a reply.
Author
Messages
ErikaS
Basic Member
Posts: 19
Basic Member
    Hello,

    I'm very new to Crystal Reporting and the Lawson OLEDB connection.

    Another one of Lawson's clients gave me a Crystal Report file that they have customized for their reporting needs.

    How would I use that report with  my data through the OLEDB connection?

    I see their formula fields and I see something that looks like they created with the Query Builder...can I/will I be able to view what they created in Query Builder?

    I'm sorry if I'm not using the right terminology.

    Thanks,
    Erika
    Donna
    Veteran Member
    Posts: 110
    Veteran Member
      Ericka,

      I can't give you a quick answer to some of your questions without knowing a little more. I have been preparing Crystal reports from Lawson tables since the late 1990s.

      I can tell you that you may be able to open the report and view the formulas, grouping and a lot of other general information without connecting to your database. I am going out of town in the morning and am onsite with a client today so I probably could not give you direct support until early next week. I am willing to look at the crystal file and do some quick analysis of your options if it does not violate your agreement with the person who gave it to you to send it to me. You can communicate with me through my personal email dwolbee@aol.com.
      Donna Shelton
      Greg Dey
      Advanced Member
      Posts: 23
      Advanced Member
        It may be as simple as using the Set Datasource Location in Crystal assuming you already have OLE DB installed.  I use it all the time to switch from test to prod.  If you buy a report from lawsonguru you would use the Set Datasource Location to get it to work with your data.

        Greg
        ErikaS
        Basic Member
        Posts: 19
        Basic Member
          I can view the formulas and the groupings without connecting to the database.

          I also tried using the Set Datasource Location. When I try to refresh, I get a "failed to retrieve data" error message.

          Seems to me like I need to have something "built" or tables already selected in the Query Builder??
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
            Try testing your query on the ole db Query builder.

            You can do this by openning the query builder of oledb which should be installed under Lawson software. Put in the datasource and userid as well as password for your oledb connection. This userid and password will also be defined un LS or laua security and checks which all areas you have access to.

            Once you connect the query builder opens up. Paste you dme query. Now parse and execute. Once you click on execute you should be able to see the data.

            If you get failed to retreive data error check you userid and password as well as your oledb connection.
            Matthew Nye
            Veteran Member
            Posts: 514
            Veteran Member
              are you certain the person you got this from was on the same release of Lawson Apps/Env?
              If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
              Ruma Malhotra
              Veteran Member
              Posts: 412
              Veteran Member
                In case of oledb Matt's question is the million dollar question.

                I have known a lot of ole db queries to fail if the versions are not the same between the one that is saved and the one that needs to get executed.
                ErikaS
                Basic Member
                Posts: 19
                Basic Member
                  That's a very good point.  I will have to ask what version that customer was/is on when the report was sent to us.

                  Thanks!
                  You are not authorized to post a reply.