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
Excel file as a datasource for Crystal in LBI
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
100
Members:
0
Total:
100
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
Excel file as a datasource for Crystal in LBI
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Frank Z
Advanced Member
Posts: 32
9/28/2010 4:52 PM
We have several CXI reports that use Excel as a datasource (From a network share) and I have been approached to see if there is a way for me to get them into LBI. I have been attempting to get it to work, to no avail. The reports work fine when they are run in Crystal, but once I upload the rpt to LBI, I get the following error:
Error
Failed to load database information. Error in File C:\WINDOWS\TEMP\PE LBI Test 01 {1FCAF25D-D167-41B6-93B1-E92A1D6B7B2D}.rpt: Failed to load database information.
When I bypass CXI and set the datasource as the xls file, the data is brought through. I tried to put the xls in the lawson docs folder on the LBI server, reset the datasource in the RPT, then republish the report and I get the same results.
Is this even possible or am I barking up the wrong tree?
amynelson
Advanced Member
Posts: 25
9/28/2010 5:01 PM
The excel files as a data source need to be located on the LBI Server for them to work in LBI.
Frank Z
Advanced Member
Posts: 32
9/28/2010 8:51 PM
Thanks, Amy. I do have them on the LBI server, is there a folder in particular that they should be located in?
amynelson
Advanced Member
Posts: 25
9/28/2010 9:21 PM
Sorry, I thought you were saying that the files were on a shared drive outside of the LBI server. No, you shouldn't have to put them in a particular folder. Just to omit any mis-communication: Do you have Crystal XI installed on the LBI server? If so, can you run the reports from that installation of XI and see if you get an error.
TIP - Whenever I develop reports that use Excel files, I develop the rpt locally on the LBI server so that the path to the files is local to LBI and not referencing the shared drive, even though the shared drive is on the LBI server. Your error may be coming from the fact that you developed them on your local machine, using a mapped LBI server drive. LBI is trying to use that mapping when it executes the report.
Hope this helps
Joe
Basic Member
Posts: 5
9/28/2010 9:43 PM
Another consideration. Keep in mind that not all users may have access to the LBI server. Make sure to account on how your datasource will updated: real-time vs. batch.
Frank Z
Advanced Member
Posts: 32
9/29/2010 11:48 AM
Amy-
You are 100% on the mark. I am developing the rpt on my desktop, and then uploading to the server. The file path is the full file name (\\Pncllwbi\e$\LawsonDocuments\Colgan CO-Q400 DOT Late Flight Report Jun 2010.xls) in this case, so I can see why the datasource is unrecognized.
Thanks Amy and Joe. I will get CXI installed locally and try this again.
You are not authorized to post a reply.