Using a Custom Crystal Report with my data

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

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

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??

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.

are you certain the person you got this from was on the same release of Lawson Apps/Env?

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.

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!