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
Microsoft Reporting Services vs. LRS on LBI
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
389
Members:
0
Total:
389
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
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
1351
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
Microsoft Reporting Services vs. LRS on LBI
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Joe O'Toole
Veteran Member
Posts: 314
4/19/2013 8:33 PM
We have LBI running a number of Crystal reports but the bulk of our corporate reporting outside of Lawson is done with Microsoft Reporting Services. Because this is a company standard and reports are easier to deploy, schedule and maintain in MSRS we are considering moving new Lawson report development to MSRS. Has anyone used both MS RS and Crystal with Lawson that could offer their experiences? We are curious about any limitations encountered with Crystal and MS RS accessing both Lawson and non Lawson data as well as the ability to deploy MS RS reports on an LBI dashboard.
John Henley
Senior Member
Posts: 3348
4/19/2013 9:11 PM
I have used both, and they both have their pros and cons. I think simple report development is actually easier/faster with Crystal because the designer is better, and built-in formulas are pretty comprehensive. Where SSRS shines is more robust data sources (i.e. you can report against SharePoint lists, etc.) and since it's .NET, anything can be customized (need a formula, write some code; yes, you can do same in Crystal, but not really...) Deployment in LBI is fairly easy for Crystal, although you can't use data-driven parameters without removing the LBI UI for the report (I know there is a proper term, but I can't remember off the top of my head...). I haven't tried deploying SSRS within LBI, but I'm guessing it's just going to be a dashboard over an IFRAME
One thing to remember: Infor has their own BI tools, and LBI uses Crystal, which is owned by SAP. Don't expect Crystal to be the reporting engine for LBI, or for LBI to be the end-game product. Also, when you get to Infor 10, you're working in SharePoint, so you have SSRS option there as well. Given the unknowns, and the costs associated with Crystal and LBI, clients were looking to preserve their existing Crystal investment, so I developed and sell a product (DecisionPoint) that hosts both Crystal and SSRS within the same site, and integrates with Lawson and SharePoint for parameters.
John Henley
Senior Member
Posts: 3348
4/21/2013 1:52 PM
http://kenhamady.com/cru/archives/2449
Adam Jacobson
Veteran Member
Posts: 69
4/23/2013 10:14 PM
We have experience writing reports in both tools and we've put together a comparison chart which I can send you separately (adam@redthree.com)
Here's my quick answer: Crystal is better for non-technical people, SSRS is better for developers and SSRS is cheaper.
Crystal was always sold as a way for users to be independent from IT - "you'll write your own reports". In my experience, this is only true (and sometimes not even then) when you have a dedicated reporting function (think director of financial reporting or HRIS). For the vast majority of customers, while the tool isn't complex the data is.
So, Crystal's promise isnt' realized.
While you don't want to give SSRS over to an end user, it can get you almost everything you can get in Crystal. And you don't pay a fortune to create a web site for it - it's already part of SQL Server.
Hope to see you at the next MRLUG.
Adam
You are not authorized to post a reply.