Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Using a Custom Crystal Report with my data
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
253
Members:
0
Total:
253
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Using a Custom Crystal Report with my data
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
ErikaS
Basic Member
Posts: 19
2/16/2011 8:13 PM
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
2/16/2011 8:58 PM
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
2/16/2011 9:11 PM
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
2/17/2011 12:44 PM
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
2/17/2011 2:04 PM
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
2/17/2011 2:19 PM
are you certain the person you got this from was on the same release of Lawson Apps/Env?
Ruma Malhotra
Veteran Member
Posts: 412
2/17/2011 4:05 PM
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
2/28/2011 3:37 PM
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.