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

Crystal report needs to reference non-odbc data

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Jan
Veteran Member
Posts: 55
Veteran Member
7/7/2009 12:53 PM
    Hi
    I’m working on an LBI/Crystal report where two of the tables are smaller Excel files (each less than 1,000 lines). I can develop the report in Crystal okay, but once I publish the report onto the LBI server, the report won’t be able to find the network location where the spreadsheets are. Due to limited I.T. resources, I can’t have them create these tables in the database for me. Also, there are issues with having the LBI server map to the network drive where the spreadsheets exist, meaning there are difficulties having the Crystal report continue to reference the spreadsheets once the report is published into LBI.
    My questions are:
    1)      Has anyone else dealt with a similar issue and found a way to deal with it?
    2)      Is it possible to build a data array in an sql statement that I could add to the report via the “Add Command” in Crystal’s database expert – the intent of this being that I could create a type of virtual table that could then be used in the report?
    I appreciate any ideas that can be passed along - thanks
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    7/7/2009 1:51 PM
      Jan:

      Yes, this is possible. You just need to have the Report Application Server (aka RAS) service log in as a user who has rights to this path, then as long as you create the DSN on the RAS server, you'd be set to go.

      If you need more details about how to do this, please contact me!

      To answer your question #2, I know that is also possible, but can't explain to you how to do it. I never deal that much with actually writing reports, just in the LBI administration of them.
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      7/7/2009 2:21 PM
        You will probably also have to develop the report using the same UNC path to the Excel files that you create as a DSN on your RAS server.
        muffntuf
        Advanced Member
        Posts: 41
        Advanced Member
        7/9/2009 6:24 PM
          Have you conisdered housing the excel files on the actual LBI server?