Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Excel file as a datasource for Crystal in LBI

 5 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Frank Z
Advanced Member
Posts: 32
Advanced Member
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
    Advanced Member
    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
      Advanced Member
      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
        Advanced Member
        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
          Basic Member
          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
            Advanced Member
            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.