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
LRS / LBI vs. Microsoft REporting Services
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LynneB
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5123
People Online:
Visitors:
317
Members:
0
Total:
317
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
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
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
1357
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
LRS / LBI vs. Microsoft REporting Services
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Joe O'Toole
Veteran Member
Posts: 314
12/4/2007 6:04 PM
I'm looking for a reference that uses or has used both MRS and LRS/LBI. Specifically, I would like to understand how these products compliment each other, what each can do that the other cannot and where the overlap is. We're currently at V 8.03 of Env and Apps and just started to use MRS for some non Lawson reporting. We will be installing LRS 9 after we get on LSF 9 and will need to make a decision on which tool would be best to rewrite our legacy Lawson and non Lawson reports with. Thanks.
k-rock
Veteran Member
Posts: 142
12/4/2007 7:04 PM
the big one off the top of my head is LBI's ability to drill down to transaction level detail.
LBI is basically Business Objects/Crystal, so you could expand you question to anyone that has used MRS and Crystal.
John Henley
Posts: 3352
12/4/2007 7:31 PM
Joseph, what a great question! I wrote about MS SQL Reporting Services a few years ago (
https://www.danalytics.co...rchive/2004-06.htm),
but perhaps it's time for an updated side-by-side comparison.
LBI - Advantages / MSSQL RS - Disadvantages
- LBI is an umbrella product set, and includes a number of other products beyond Reporting Services, e.g., Dashboards/Scorecards, Smart Notiifications.
- This may not be true anymore (I need to get a new copy installed) but the MSSQL report designer, while look/feel similar to Microsoft Access, is hosted in Visual Studio much more difficult to use than Crystal. Crystal's designer just "feels" easier to use.
- LBI supports "bursting" of standard Lawson reports (i.e. GL290) into separate pieces of content.
- LBI 9.0 supports single-sign on.
- If you use Lawson OLEDB, the Query Builder is integrated into Crystal. If you use MSSQL RS, you have to figure out the DME syntax and past it into the report query. Not a big deal.
MSSQL RS - Advantages / LBI Disadvantages
- The HUGE advantage of MSSQL RS is COST. It's essentially free, whereas LBI (or Business Objects) = $$.
- Since it's a .NET application, you have the whole .NET framework at your disposal, and can embedded .NET code into the report.
Where I think they're about even:
- Database support. MSSQL RS is not just for SQL Server--it can report off of any OLEDB/ODBC data source. As can Crystal/LBI.
- Report management / scheduling / delivery.
In my mind, two of the "advantages" noted by Lawson are really a wash, as they can be implemented pretty easily in either product:
1. Security. Lawson touts the OLEDB provider, but when the "rubber meets the road" most clients end up writing their reports using native/ODBC providers to eliminate speed issues associated with Lawson OLEDB provider. What I always recommend as a "best practice" is a two-pronged approach: 1) implement the parameter selection via Lawson OLEDB (so that user can only select the records they have access to via Lawson security), and 2) implement the report itself via native database provider using parameters selected. It's the best of both worlds. And can be implemented with LBI as well as MSSQL RS.
2. Drill-Around. It's pretty easy to add it in MSSQL RS (it's really just a matter of a dynamic URL).
You are not authorized to post a reply.