• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Cannot update Crystal Report in LBI

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dcaiani
Veteran Member
Posts: 52
Veteran Member
Helpful Replier
New Poster
Engaged Poster
Engaged Reader
Avid Reader
6/13/2013 6:51 PM
Good afternoon,
We have a Crystal report, data source is a view built by our IT department. When I run it in Crystal I can get it to refresh after inputting new parameters (date range). I publish it in LBI and I can get to the report via the dashboard, but when I try to refresh and enter a new date range I get the following error message:

Failed to open the connection. Failed to open the connection. EE Listing by HM AU with parameter {9C50237D-53A6-411C-A755-7C6B10D036D5}.rpt

We have another Crystal report that allows us to enter a date range and the report refreshes correctly without any issues.

Thanks

Dave
Chris Martin
Veteran Member
Posts: 277
Veteran Member
Helpful Replier
New Poster
Engaged Reader
Avid Reader
6/13/2013 7:03 PM
This sounds like a report data source issue. I would suggest running the report using Crystal Reports designer that is installed on the LBI server. This will require remote access to the LBI server.
dcaiani
Veteran Member
Posts: 52
Veteran Member
Helpful Replier
New Poster
Engaged Poster
Engaged Reader
Avid Reader
7/16/2013 11:58 AM
Turns out that the issue was that the ODBC driver needed to be configured in Lawson/LBI