Forums
Lawson Business Intelligence/Reporting/Crystal
Crystal report not refreshing
Author
Messages
BMcKay
New Member
Posts: 3
8/21/2013 6:07 PM
1. Modified Crystal report, did save without data
2. Republished on dashboard via LBI>Report Details
3. LBI>Report Details>Data Settings, chose the datasource and entered user id/password.
Now I go to Dashboard, click on report and it has old data in it. I'm new at both Crystal and LBI.
Beth
Greg Moeller
Veteran Member
Posts: 1498
8/21/2013 6:24 PM
By chance, did you ever configure a schedule for this report? Generally for on-demand reports, a schedule is not set up.
Once it has been set up, however, even if you delete the schedule the dashboard could still be displaying the scheduled report and it's data.
Check your LawsonDocuments folder for the report-id_ReportName\Instances folder
If there is anything in the Instances folder, delete it, and re-try the dashboard link again.
Robby
Veteran Member
Posts: 87
8/22/2013 12:49 PM
Beth,
If you are still having an issue here, please try this;
Go to LBI>Reporting Services Administration>Report Management>Maintain Reports
Find this report in the list, select [Details]
In the Left Navigation Bar go to: Report Actions>View with Data Refresh
Your report will now run, and should give you fresh data:
If the resulting data is indeed fresh, your problem is the link on the dashboard. This link may be set to pull "View Latest Instance".
Hope this helps! And welcome to the world of LBI :-) !!
-Robby
BMcKay
New Member
Posts: 3
8/22/2013 1:14 PM
Greg,
That worked! Thanks so much.
Beth
NatalieD
Veteran Member
Posts: 53
7/28/2016 1:25 PM
I was also told by Infor to add "&Refresh=True" to the end of my URL link on the dashboard as a quick fix to avoid pulling the last scheduled instance.