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
crystal reports/LBI dynamic data
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
482
Members:
0
Total:
482
Online Now:
New Topics
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
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
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
crystal reports/LBI dynamic data
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
DougAB
Advanced Member
Posts: 28
12/11/2012 8:28 PM
i'm new to crystal and LBI....from initial testing, it seems we only get static data when we run our Crystal Reports. It's my understanding we can schedule times to refresh the data which is nice, but i am looking for a way for our users to get up-to-date data on these reports when they open them. Is there a way to do this using either Crystal or LBI?
Thanks,
Doug
Greg Moeller
Veteran Member
Posts: 1498
12/11/2012 9:04 PM
Ahhh!! I think I know what the issue is. You must save your reports (at development time) with the 'Save Data with Report' box UNCHECKED. This will allow you to refresh the data every time the report runs.
Check that, and post back if you find it is already unchecked.
Matthew Nye
Veteran Member
Posts: 514
12/11/2012 11:05 PM
If gregs suggestion is not the case it may just be that your reports are scheduled and you viewing the historical instances. There are several ways to go about it but essentially you need to give your users the ability to run the reports with data refresh.
If this is the case post back and we can elaborate on your options. The short answer is, yes, for sure you can get dynamic data with crystal and LBI.
dcaiani
Veteran Member
Posts: 52
12/12/2012 1:04 PM
I'm somewhat new to using Crystal and LBI together as well. I using Crystal XI which is installed on my desktop then publishing my reports onto LBI. I understand that there is an instance of Crystal that comes with LBI. Am I better off using the stand alone version on my desktop or what comes packaged with LBI or does it even matter?
Dave
Matthew Nye
Veteran Member
Posts: 514
12/12/2012 1:44 PM
Dcaiani,
The desktop version is ideally meant for you to create reports that are then published to LBI for distribution to a wider audience. Unless you are the only person consuming these reports I dont think using the desktop version as a method for distribution is a very efficient way to do things.
John Henley
Senior Member
Posts: 3348
12/12/2012 2:16 PM
[quote]
I dont think using the desktop version as a method for distribution is a very efficient way to do things.
[/quote]
Unless I misunderstood the question, that's not what he was asking.
I think what he was asking was "should I use the Crystal on my desktop, or the Crystal on the server for developing reports"?
If that was the actual question, then it doesn't really matter. In either case, you still have to publish them to LBI.
DougAB
Advanced Member
Posts: 28
12/12/2012 3:38 PM
Greg/Matt - I'll look into your suggestions, thanks. Another point that came up, is it possible to get on-demand data from our Crystal Reports if our users use Crystal Viewer? We noticed that data seems to be static also.
-Doug
dcaiani
Veteran Member
Posts: 52
12/12/2012 3:44 PM
Yes, I was wondering if using one version or another had any advantages in development,deployment, or data access both during deployment or when the end user would be refreshing the report. Sounds like it doesn't matter.
Matthew Nye
Veteran Member
Posts: 514
12/12/2012 4:35 PM
I think there maybe a misunderstanding of the components at play here. Crystal Reports Designer is the desktop tool used to create reports. You can then publish them via Reporting Services (RS) and deliver them through RS or on dashboards. Once the latter is done, regardless of whether the data is historical (saved in an instance of the report) or ondemand (returned from the database when the user requests the report) they will be using the Crystal Viewer. There are permissions that have to be granted to a user in order to access ondemand reports. Also the method in which you expose the Crystal Reports will determine whether they see ondemand vs. historical (OnDemand) reports.
If you really want to give all your users the Crystal Report Designer (which is highly inadvisable), you will need licenses for each install (LBI only comes with 3 as i recall) and each user will need a logon to the data source that is used. With the Designer and a logon the user has the power to pull as much data as is granted his logon which can really be a dangerous thing if security is left open. Its really not the standard way to deploy Crystal Reports.
hope this helps clarify.
DougAB
Advanced Member
Posts: 28
12/12/2012 5:02 PM
Thanks, Matt. I am beginning to see the picture here. In regards to your comment, "There are permissions that have to be granted to a user in order to access ondemand reports.",
Where are these done? In LSF security? Can you be more specific?
Thanks.
Matthew Nye
Veteran Member
Posts: 514
12/14/2012 3:28 PM
Doug,
This is done via Reporting Services Administration. it can be done on a global lever in the System Settings section or per report in the Detail of each published report.
You are not authorized to post a reply.